core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
Simplify Analyticsuw_multileg508,354 rowsexportable| idtext | tickertext | executed_at ↓timestamp with time zone | strategytext | leg_countinteger | txnsinteger | sizebigint | total_premiumnumeric | directiontext | net_side |
|---|
| underlying_pricenumeric |
|---|
| bid_ask_spreadnumeric |
|---|
| strikesjsonb |
|---|
| ivsjsonb |
|---|
| breakevensjsonb |
|---|
| uniq_exchangesjsonb |
|---|
| min_strikenumeric |
|---|
| max_strikenumeric |
|---|
| min_dteinteger |
|---|
| max_dteinteger |
|---|
| all_opening_legsboolean |
|---|
| all_otmboolean |
|---|
| diff_expirationsboolean |
|---|
| diff_strikesboolean |
|---|
| diff_typesboolean |
|---|
| codetext |
|---|
| kept_bytext |
|---|
| sourcetext |
|---|
| endpointtext |
|---|
| request_paramsjsonb |
|---|
| as_ofdate |
|---|
| vintage_tstimestamp with time zone |
|---|
| retrieved_attimestamp with time zone |
|---|
| 01a06e07-97fd-7c53-bc8a-9271696701c2 | DIA | 2026-09-04 16:06 | call_calendar | 2 | 1 | 10 | 139620.00 | short | bid | 533.9123 | 0.8500 | ["465"] | ["0.3297"] | [] | ["XCBO"] | 465.0000 | 465.0000 | 14 | 42 | false | false | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T20:07:16Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06e07-038d-7d63-bfe5-ccd19a585c25 | DIA | 2026-09-04 16:05 | call_calendar | 2 | 1 | 18 | 233586.00 | short | bid | 533.9123 | 0.8500 | ["470"] | ["0.3116"] | [] | ["SPHR"] | 470.0000 | 470.0000 | 14 | 42 | false | false | true | false | false | mlet | |||||||
| 01a06dee-7a4d-7b03-a90a-0ad9df930b79 | DIA | 2026-09-04 15:38 | call_vertical_spread | 2 | 1 | 150 | 49200.00 | short | bid | 533.7100 | 0.1400 | ["554","559"] | ["0.1076","0.1087"] | ["554.70"] | ["EMLD"] | 554.0000 | 559.0000 | 42 | 42 | false | true | false | true | false | ||||||||
| 01a06dd0-c8bd-7183-9433-5206313c58d5 | DIA | 2026-09-04 15:06 | call_diagonal_spread_bearish | 2 | 1 | 6 | 26700.00 | short | ask | 533.8400 | 0.6500 | ["510","530"] | ["0.1216","0.1265"] | [] | ["XISX"] | 510.0000 | 530.0000 | 14 | 105 | false | false | true | true | false | ||||||||
| 01a06dcb-c395-7d12-b2da-53f9e709296c | DIA | 2026-09-04 15:01 | other | 4 | 1 | 12 | 61740.00 | unknown | — | 534.0400 | 1.2000 | ["515","530"] | ["0.7833","0.3327"] | [] | ["XPHO"] | 515.0000 | 530.0000 | 0 | 21 | false | false | true | true | false | mlet | |||||||
| 01a06dbc-0455-71a0-b0c3-f0efeab7718a | DIA | 2026-09-04 14:43 | strangle | 2 | 1 | 10 | 32000.00 | long | ask | 534.3800 | 0.8000 | ["540","545"] | ["0.1451","0.1223"] | ["508","577.00"] | ["XISX"] | 540.0000 | 545.0000 | 133 | 133 | false | false | false | true | true | mlet | |||||||
| 01a06d9b-ca55-72f3-b442-c3054a6793f3 | DIA | 2026-09-04 14:08 | other | 2 | 1 | 9 | 45342.00 | unknown | — | 534.1000 | 0.5500 | ["490","530"] | ["0.1977","0.0974"] | [] | ["XISX"] | 490.0000 | 530.0000 | 7 | 14 | false | false | true | true | false | mlet | |||||||
| 01a06d99-362d-7830-bab2-87806487b00c | DIA | 2026-09-04 14:05 | other | 2 | 1 | 2 | 31114.00 | unknown | — | 534.0100 | 4.6000 | ["458","475"] | ["0.3103","0.1476"] | [] | ["XISX"] | 458.0000 | 475.0000 | 26 | 299 | false | false | true | true | false | mlet | |||||||
| 01a06d84-f695-7952-a7f1-4f209ebf1204 | DIA | 2026-09-04 13:43 | other | 2 | 1 | 8 | 120672.00 | unknown | — | 533.9252 | 1.2000 | ["455","470"] | ["0.2660","0.1390"] | [] | ["MCRY"] | 455.0000 | 470.0000 | 14 | 133 | false | false | true | true | false | mlet | |||||||
| 01a06d6b-1595-7103-ae9f-e17c04e33928 | DIA | 2026-09-04 13:15 | put_vertical_spread | 2 | 3 | 12 | 29496.00 | unknown | — | 534.2500 | 0.7583 | ["515","535"] | ["0.1563","0.1465"] | [] | ["XBOX","XPHO"] | 515.0000 | 535.0000 | 133 | 133 | false | false | false | true | false | mlet | |||||||
| 01a06d2b-033d-7f83-8592-ed5bcd9b6b09 | DIA | 2026-09-04 12:05 | other | 2 | 1 | 55 | 64068.00 | unknown | — | 534.1400 | 0.5500 | ["535","536"] | ["0.1272","0.1268"] | [] | ["EDGO"] | 535.0000 | 536.0000 | 42 | 42 | false | false | false | true | false | mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T20:07:16Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:39:09Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:06:36Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:01:26Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:44:16Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:09:19Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:06:02Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T17:43:44Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T17:15:45Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:05:43Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |