Multi-leg option trades
core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
312,778 rowsCSV — whole table, not this view
Sources in this table
uw_multileg312,778 rowsexportable
| idtext | tickertext | executed_at ↓timestamp with time zone | strategytext | leg_countinteger | txnsinteger | sizebigint | total_premiumnumeric | directiontext | 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b5e9-f347-79e0-af27-f3129b42bf83 | MATX | 2026-09-18 15:06 | call_calendar | 2 | 2 | 100 | 106500.00 | unknown | bid | 232.5400 | 3.7500 | ["230"] | ["0.6377"] | [] | ["XCBO"] | 230.0000 | 230.0000 | 0 | 28 | false | false | true | false | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:07:06Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5d9-6ccf-7b53-ad63-bb4270e3b455 | SPX | 2026-09-18 14:48 | call_calendar | 2 | 1 | 100 | 54100.00 | unknown | bid | 7643.5800 | 0.4500 | ["7800"] | ["0.0798"] | [] | ["XCBO"] | 7800.0000 | 7800.0000 | 7 | 11 | false | true | true | false | false | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:48:56Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b59f-26d7-72c3-ad48-954cbf5c4999 | SPX | 2026-09-18 13:44 | call_calendar | 2 | 2 | 100 | 1423600.00 | unknown | bid | 7628.0400 | 0.6000 | ["7625"] | ["0.1089"] | [] | ["XCBO"] | 7625.0000 | 7625.0000 | 7 | 21 | false | false | true | false | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:45:17Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b562-298f-7541-888f-c8adf2722393 | FDX | 2026-09-18 12:38 | call_calendar | 2 | 2 | 100 | 995800.00 | unknown | bid | 302.5100 | 5.5500 | ["300"] | ["0.3159"] | [] | ["XCBO"] | 300.0000 | 300.0000 | 272 | 854 | true | false | true | false | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:38:27Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0afdb-a88b-7231-b5d9-83681b975f97 | TECK | 2026-09-17 10:53 | call_calendar | 2 | 3 | 573 | 200616.00 | unknown | — | 65.9300 | 1.6246 | ["65"] | ["1.1635"] | [] | ["XCBO"] | 65.0000 | 65.0000 | 1 | 29 | false | false | true | false | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:53:48Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0ab53-ab83-7b70-b830-07a6bc27da7f | SPX | 2026-09-16 13:46 | call_calendar | 2 | 2 | 315 | 439110.00 | unknown | — | 7606.4900 | 0.6000 | ["7800"] | ["0.1053"] | [] | ["XCBO"] | 7800.0000 | 7800.0000 | 13 | 16 | false | true | true | false | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T17:46:29Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab20-df9b-7c62-b74f-70818c9affd2 | VIX | 2026-09-16 12:50 | call_calendar | 2 | 2 | 800 | 320300.00 | unknown | — | 16.7700 | 0.4700 | ["25"] | ["0.9901"] | [] | ["XCBO"] | 25.0000 | 25.0000 | 154 | 217 | false | true | true | false | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T16:51:30Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a5c5-363e-7cd0-a69c-f50be163b4b4 | RUT | 2026-09-15 11:52 | call_calendar | 2 | 1 | 220 | 1111280.00 | unknown | — | 2866.7474 | 1.0000 | ["2900"] | ["0.2256"] | [] | ["XCBO"] | 2900.0000 | 2900.0000 | 3 | 94 | false | true | true | false | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T15:53:25Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a08ceb-94e8-79c3-8102-1147ae3164ee | VIX | 2026-09-10 16:04 | call_calendar | 2 | 1 | 26703 | 5474115.00 | unknown | — | 18.0600 | 0.1500 | ["35"] | ["1.2702"] | [] | ["XCBO"] | 35.0000 | 35.0000 | 69 | 97 | false | true | true | false | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T20:05:22Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08bd8-5be1-7ef1-876f-442fd70d95ab | ETN | 2026-09-10 11:03 | call_calendar | 2 | 1 | 58 | 148770.00 | unknown | — | 412.5000 | 1.5500 | ["450"] | ["0.3845"] | [] | ["XCBO"] | 450.0000 | 450.0000 | 8 | 127 | false | true | true | false | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T15:03:57Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a086d2-8be8-7103-8499-ec88d7e3c0df | VIX | 2026-09-09 11:38 | call_calendar | 2 | 1 | 35606 | 6907564.00 | unknown | — | 16.4500 | 0.0900 | ["35"] | ["1.3818"] | [] | ["XCBO"] | 35.0000 | 35.0000 | 70 | 98 | false | true | true | false | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T15:39:41Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08192-23f0-7512-8525-69f83ad51782 | VIX | 2026-09-08 11:10 | call_calendar | 2 | 1 | 35607 | 6658509.00 | unknown | — | 15.4000 | 0.0900 | ["35"] | ["1.4581"] | [] | ["XCBO"] | 35.0000 | 35.0000 | 71 | 99 | false | true | true | false | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T15:10:46Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |