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 |
|---|
| 01a0caad-db77-72c0-9e42-86f89f32f81f | VIX | 2026-09-22 15:53 | call_calendar | 2 | 1 | 5095 | 331850.00 | unknown | bid | 14.2500 | 0.1600 | ["35"] | ["1.6957"] | [] | ["XCBO"] | 35.0000 | 35.0000 | 57 | 85 | false | true | true | false | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T19:53:11Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0caa0-eaf7-7661-b05a-33ba0a10de87 | SPX | 2026-09-22 15:38 | call_calendar | 2 | 1 | 100 | 92100.00 | short | ask | 7777.7000 | 0.2000 | ["7875"] | ["0.0933"] | [] | ["XCBO"] | 7875.0000 | 7875.0000 | 3 | 6 | false | true | true | ||||||||||
| 01a0ca09-0ff7-76a3-bc67-e43897fe5f5e | VIX | 2026-09-22 12:53 | call_calendar | 2 | 1 | 5094 | 313590.00 | unknown | bid | 14.2700 | 0.1200 | ["35"] | ["1.6916"] | [] | ["XCBO"] | 35.0000 | 35.0000 | 57 | 85 | false | true | true | ||||||||||
| 01a0c9a3-2dee-70a1-968a-9497fdf02883 | VIX | 2026-09-22 11:01 | call_calendar | 2 | 1 | 5094 | 326006.00 | unknown | bid | 14.4200 | 0.1100 | ["35"] | ["1.6874"] | [] | ["XCBO"] | 35.0000 | 35.0000 | 57 | 85 | false | true | true | ||||||||||
| 01a0c58d-401f-7842-b411-cc1df7c19372 | SPX | 2026-09-21 15:59 | call_calendar | 2 | 1 | 100 | 99300.00 | unknown | bid | 7767.2100 | 0.4000 | ["7890"] | ["0.1010"] | [] | ["XCBO"] | 7890.0000 | 7890.0000 | 4 | 7 | false | true | true | ||||||||||
| 01a0c43a-ac57-7ed2-b85b-26e0a50cd105 | SPX | 2026-09-21 09:49 | call_calendar | 2 | 1 | 51 | 102969.00 | long | bid | 7700.3000 | 0.4000 | ["8075"] | ["0.1072"] | [] | ["XCBO"] | 8075.0000 | 8075.0000 | 25 | 39 | false | true | true | ||||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 01a0b52e-a60f-7123-be45-451d8ca47a3e | JNJ | 2026-09-18 11:42 | call_calendar | 2 | 4 | 950 | 3016250.00 | short | bid | 269.2800 | 2.5500 | ["260"] | ["0.2666"] | [] | ["XCBO"] | 260.0000 | 260.0000 | 28 | 63 | false | false | true | ||||||||||
| 01a0afdf-fdeb-7c83-9608-5a47b82f4a13 | SPX | 2026-09-17 10:58 | call_calendar | 2 | 1 | 51 | 71553.00 | long | ask | 7620.0700 | 0.3000 | ["8075"] | ["0.1089"] | [] | ["XCBO"] | 8075.0000 | 8075.0000 | 29 | 43 | false | true | true | ||||||||||
| 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 | ||||||||
| 01a0afc9-2e13-7a62-8593-fe5f102b7539 | CRML | 2026-09-17 10:33 | call_calendar | 2 | 3 | 2000 | 106000.00 | short | ask | 6.8850 | 0.3300 | ["8"] | ["1.0178"] | [] | ["XCBO"] | 8.0000 | 8.0000 | 15 | 22 | false | true | true | ||||||||||
| 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 | ||||||||
| 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 | ||||||||
| 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 | ||||||||
| 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 | ||||||||
| 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 | ||||||||
| 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 | ||||||||
| 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 |
| false |
| mfsl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T19:39:22Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mfsl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T16:53:50Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mfsl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T15:01:55Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mfsl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T19:59:27Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mfsl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T13:49:47Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| 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 |
| 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 |
| 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 |
| 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 |
| false |
| mfsl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T15:42:11Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mfsl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T14:58:26Z"} |
| 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-17T14:53:48Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| false |
| mfsl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T14:33:27Z"} |
| 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-16T17:46:29Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |