core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg403,968 rowsexportable| idtext | tickertext | executed_at ↓timestamp with time zone | strategytext | leg_countinteger | txnsinteger | sizebigint | total_premiumnumeric | direction |
|---|
| net_sidetext |
|---|
| 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 |
|---|
| 01a0c952-1fef-7872-b1bb-3984a0377519 | BLDR | 2026-09-22 09:33 | call_ratio_spread | 2 | 1 | 330 | 245025.00 | unknown | — | 60.6650 | 1.8000 | ["55","60"] | ["0.5946","0.5559"] | [] | ["XPHO"] | 55.0000 | 60.0000 | 24 | 24 | true | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T13:33:31Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0b59c-2550-70c2-9e69-e16ee279c5b3 | BLDR | 2026-09-18 13:41 | put_calendar | 2 | 1 | 40 | 226800.00 | unknown | — | 57.5500 | 1.6000 | ["85"] | ["0.6299"] | [] | ["XMIO"] | 85.0000 | 85.0000 | 91 | 182 | false | false | true | false | false | mlat | |||||||
| 01a0b505-7330-7d00-bc27-f8ae2f56f316 | BLDR | 2026-09-18 10:57 | other | 2 | 2 | 160 | 100400.00 | unknown | ask | 57.2500 | 1.1000 | ["65","80"] | ["0.6021","0.5584"] | [] | ["SPHR"] | 65.0000 | 80.0000 | 119 | 490 | false | false | true | true | |||||||||
| 01a0b0da-637b-7330-8c00-c434de7a7527 | BLDR | 2026-09-17 15:31 | put_calendar | 2 | 1 | 50 | 103000.00 | unknown | — | 57.4700 | 1.6000 | ["65"] | ["0.5269"] | [] | ["XBOX"] | 65.0000 | 65.0000 | 64 | 120 | false | false | true | false | false | mlet | |||||||
| 01a0b0b1-6362-7001-9da6-9cf70a84aef7 | BLDR | 2026-09-17 14:46 | other | 5 | 1 | 1288 | 3259720.00 | unknown | — | 57.4200 | 10.5000 | ["65","70","75","80","100"] | ["2.0864","2.8825","3.5854","4.2041","0.8595"] | [] | ["XBOX"] | 65.0000 | 100.0000 | 1 | 92 | false | false | true | true | false | ||||||||
| 01a0b046-419b-7552-a36f-57f167e53b83 | BLDR | 2026-09-17 12:49 | put_vertical_spread | 2 | 1 | 20 | 157140.00 | unknown | — | 57.8500 | 2.3000 | ["95","100"] | ["0.6155","0.6504"] | [] | ["XPHO"] | 95.0000 | 100.0000 | 120 | 120 | false | false | false | true | false | ||||||||
| 01a0b043-0963-7252-8906-1bbb1052a750 | BLDR | 2026-09-17 12:46 | put_vertical_spread | 2 | 1 | 50 | 346700.00 | unknown | — | 57.8700 | 0.9000 | ["90","95"] | ["0.6592","0.6996"] | [] | ["ARCO"] | 90.0000 | 95.0000 | 92 | 92 | false | false | false | true | false | ||||||||
| 01a0b042-c313-7613-8e9a-393699d3f924 | BLDR | 2026-09-17 12:45 | put_vertical_spread | 2 | 1 | 50 | 346300.00 | unknown | — | 57.8700 | 0.9000 | ["90","95"] | ["0.6526","0.6924"] | [] | ["XMIO"] | 90.0000 | 95.0000 | 92 | 92 | false | false | false | true | false | ||||||||
| 01a0b03f-67b3-7f22-8417-15bdff72cff6 | BLDR | 2026-09-17 12:42 | put_vertical_spread | 2 | 1 | 50 | 391050.00 | unknown | — | 57.8500 | 4.5000 | ["95","100"] | ["0.5901","0.6530"] | [] | ["XISX"] | 95.0000 | 100.0000 | 92 | 92 | false | false | false | true | false | ||||||||
| 01a0b039-a70b-7862-9cbf-590eb7cde6fc | BLDR | 2026-09-17 12:36 | put_vertical_spread | 2 | 1 | 49 | 289884.00 | unknown | — | 57.9350 | 1.1000 | ["85","90"] | ["0.6450","0.6875"] | [] | ["XPHO"] | 85.0000 | 90.0000 | 64 | 64 | false | false | false | true | false | ||||||||
| 01a0b039-3d93-7983-88c3-413f05af0ce9 | BLDR | 2026-09-17 12:35 | put_vertical_spread | 2 | 1 | 50 | 295800.00 | unknown | — | 57.9100 | 1.1000 | ["85","90"] | ["0.6399","0.6815"] | [] | ["BATO"] | 85.0000 | 90.0000 | 64 | 64 | false | false | false | true | false | ||||||||
| 01a08c82-0578-7d92-8782-4ebd44f6ba69 | BLDR | 2026-09-10 14:08 | put_vertical_spread | 2 | 1 | 36 | 311760.00 | unknown | — | 58.5300 | 5.2000 | ["100","105"] | ["0.5924","0.6487"] | [] | ["XMIO"] | 100.0000 | 105.0000 | 99 | 99 | false | false | false | true | false | ||||||||
| 01a08c81-af88-75a0-a411-8fa27fc9c49c | BLDR | 2026-09-10 14:08 | put_vertical_spread | 2 | 1 | 50 | 433000.00 | unknown | — | 58.5450 | 5.2000 | ["100","105"] | ["0.5962","0.6524"] | [] | ["XMIO"] | 100.0000 | 105.0000 | 99 | 99 | false | false | false | true | false | ||||||||
| 01a08c7e-8308-76c1-bddc-f87fcc1e09bc | BLDR | 2026-09-10 14:04 | put_vertical_spread | 2 | 1 | 50 | 338500.00 | unknown | — | 58.5350 | 1.7000 | ["90","95"] | ["0.6462","0.6895"] | [] | ["ARCO"] | 90.0000 | 95.0000 | 71 | 71 | false | false | false | true | false | ||||||||
| 01a08c7e-5040-7fe3-bc23-70eabaf111ec | BLDR | 2026-09-10 14:04 | put_vertical_spread | 2 | 1 | 50 | 338500.00 | unknown | — | 58.5350 | 1.7000 | ["90","95"] | ["0.6462","0.6895"] | [] | ["XISX"] | 90.0000 | 95.0000 | 71 | 71 | false | false | false | true | false | ||||||||
| 01a08c7c-7b81-7a62-b789-e2a95961df23 | BLDR | 2026-09-10 14:02 | put_vertical_spread | 2 | 1 | 43 | 328520.00 | unknown | — | 58.4500 | 4.8000 | ["95","100"] | ["0.8055","0.8717"] | [] | ["AMXO"] | 95.0000 | 100.0000 | 71 | 71 | false | false | false | true | false | ||||||||
| 01a08c7b-7d98-7d71-8493-ac3f8b952835 | BLDR | 2026-09-10 14:01 | put_vertical_spread | 2 | 1 | 50 | 382000.00 | unknown | — | 58.6300 | 4.8000 | ["95","100"] | ["0.4695","0.5479"] | [] | ["XMIO"] | 95.0000 | 100.0000 | 71 | 71 | false | false | false | true | false | ||||||||
| 01a08c75-d079-73d0-bee5-7e6e50bb83c0 | BLDR | 2026-09-10 13:55 | put_vertical_spread | 2 | 1 | 72 | 334728.00 | unknown | — | 58.6000 | 3.6000 | ["80","85"] | ["0.6870","0.8228"] | [] | ["XCBO"] | 80.0000 | 85.0000 | 36 | 36 | false | false | false | true | false | ||||||||
| 01a086c2-bd08-76b3-b97e-078441982f29 | BLDR | 2026-09-09 11:21 | call_vertical_spread | 2 | 1 | 100 | 380000.00 | unknown | — | 61.5500 | 3.8000 | ["50","60"] | ["0.6273","0.6064"] | [] | ["XPHO"] | 50.0000 | 60.0000 | 373 | 373 | true | false | false | true | false |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T17:42:21Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:57:13Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T19:31:57Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T18:47:23Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T16:50:00Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T16:46:45Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T16:45:59Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T16:42:32Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T16:36:07Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T16:36:07Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T18:08:55Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T18:08:55Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T18:05:05Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T18:05:05Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T18:02:41Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T18:02:10Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T17:56:19Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T15:22:09Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |