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 | 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 |
|---|
| 01a0c991-e426-7172-8c5c-c0311079c769 | XOM | 2026-09-22 10:42 | other | 4 | 1 | 136 | 44472.00 | unknown | — | 159.4101 | 0.5700 | ["152.5","155","162.5","165"] | ["0.3078","0.3458","0.3400","0.2935"] | [] | ["XCBO"] | 152.5000 | 165.0000 | 3 | 10 | false | true | true | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T14:43:21Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0a58e-6ece-7640-a420-cd71fa4fae0f | XOM | 2026-09-15 10:52 | other | 4 | 1 | 43 | 43258.00 | unknown | — | 167.3450 | 0.6900 | ["165","170","175","185"] | ["0.3927","0.3034","0.3745","0.3047"] | [] | ["XPHO"] | 165.0000 | 185.0000 | 3 | 31 | false | false | true | true | false | mlat | |||||||
| 01a0a58d-b34e-7200-a146-896bbca91160 | XOM | 2026-09-15 10:51 | other | 4 | 1 | 25 | 25025.00 | unknown | — | 167.4001 | 0.6900 | ["165","170","175","185"] | ["0.3860","0.3000","0.3686","0.3040"] | [] | ["XPHO"] | 165.0000 | 185.0000 | 3 | 31 | false | false | true | true | false | mlat | |||||||
| 01a0a0c9-cf20-7712-b23a-12a9dd47e32a | XOM | 2026-09-14 12:39 | other | 2 | 1 | 259 | 490495.00 | unknown | — | 165.8750 | 0.8000 | ["160","170"] | ["0.3512","0.2806"] | [] | ["XMIO"] | 160.0000 | 170.0000 | 4 | 186 | false | false | true | true | false | mlat | |||||||
| 01a0a0a0-7918-7a92-894e-15591ef9fa75 | XOM | 2026-09-14 11:54 | other | 2 | 1 | 30 | 48780.00 | unknown | — | 165.8750 | 0.6000 | ["160","175"] | ["0.3065","0.2843"] | [] | ["XCBO"] | 160.0000 | 175.0000 | 32 | 95 | false | false | true | true | false | mlat | |||||||
| 01a09107-ef40-7920-bd06-43d0361ed9df | XOM | 2026-09-11 11:13 | other | 4 | 1 | 1300 | 495300.00 | unknown | — | 164.2900 | 1.2500 | ["162.5","167.5","172.5"] | ["0.4559","0.3688","0.2959"] | [] | ["EDGO"] | 162.5000 | 172.5000 | 0 | 7 | false | false | true | true | false | mlat | |||||||
| 01a090ec-1e28-7d10-b123-be9e1b5fe866 | XOM | 2026-09-11 10:43 | other | 4 | 1 | 1380 | 672056.00 | unknown | — | 165.0200 | 0.9600 | ["162.5","167.5","172.5"] | ["0.5017","0.3279","0.3053"] | [] | ["EDGO"] | 162.5000 | 172.5000 | 0 | 7 | false | false | true | true | false | mlat | |||||||
| 01a08ce1-1568-77a3-bde3-117177518161 | XOM | 2026-09-10 15:52 | other | 2 | 1 | 5 | 36055.00 | unknown | — | 165.5400 | 4.0000 | ["110","152.5"] | ["0.3892","0.2877"] | [] | ["XMIO"] | 110.0000 | 152.5000 | 43 | 190 | false | false | true | true | false | mlat | |||||||
| 01a08c1d-d120-7ec0-8f26-80a63b988111 | XOM | 2026-09-10 12:19 | other | 4 | 1 | 10 | 61160.00 | unknown | — | 165.1400 | 5.4800 | ["105","130","145","190"] | ["0.4032","0.1867","0.3277","0.2521"] | [] | ["XCBO"] | 105.0000 | 190.0000 | 127 | 463 | false | false | true | true | true | mlat | |||||||
| 01a08bb0-d2c7-7db1-bd7c-b67cfdb1ad22 | XOM | 2026-09-10 10:20 | other | 2 | 1 | 13 | 43589.00 | unknown | — | 163.9100 | 2.3500 | ["150","155"] | ["0.3421","0.2906"] | [] | ["XCBO"] | 150.0000 | 155.0000 | 36 | 127 | false | false | true | true | false | mlat | |||||||
| 01a06ded-804d-7e82-9a92-4cf91cd72aba | XOM | 2026-09-04 15:37 | other | 4 | 1 | 30 | 84420.00 | unknown | — | 159.7100 | 5.8100 | ["149","152.5","157.5","160"] | ["0.3121","0.3041","1.3221","0.5186"] | [] | ["XMIO"] | 149.0000 | 160.0000 | 0 | 49 | false | false | true | true | false | mlat | |||||||
| 01a06d53-b91d-7002-8e70-b1a7407cbc75 | XOM | 2026-09-04 12:49 | other | 3 | 1 | 800 | 81850.00 | unknown | — | 160.5150 | 0.2700 | ["162.5","167.5","172.5"] | ["0.2358","0.2518","0.2924"] | [] | ["XISX"] | 162.5000 | 172.5000 | 7 | 7 | false | true | false | true | false | mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T14:53:05Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T14:52:14Z"} |
| 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-14T16:40:05Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T15:54:35Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T15:13:53Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T14:43:24Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T19:52:53Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T16:19:19Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T14:20:26Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:38:12Z"} |
| 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-04T16:50:23Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |