Multi-leg option trades
core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
367,592 rowsCSV — whole table, not this view
Sources in this table
uw_multileg367,592 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c44c-30b6-7ac2-8e55-7de9fb8454c2 | XOM | 2026-09-21 10:08 | call_vertical_spread | 2 | 1 | 60 | 33600.00 | unknown | bid | 159.4100 | 0.4200 | ["160","175"] | ["0.2942","0.2970"] | ["165.60"] | ["XCBO"] | 160.0000 | 175.0000 | 25 | 25 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T14:08:55Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c430-9e1f-7930-b322-412b175eafc5 | XOM | 2026-09-21 09:38 | iron_butterfly | 4 | 1 | 170 | 107780.00 | unknown | bid | 160.5200 | 1.0600 | ["157.5","162.5","170"] | ["0.3606","0.3536","0.3564"] | ["161.52"] | ["XMIO"] | 157.5000 | 170.0000 | 4 | 4 | false | false | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T13:38:43Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b58e-6d97-7f02-9061-4632b4078bea | XOM | 2026-09-18 13:26 | call_diagonal_spread | 2 | 1 | 149 | 262389.00 | unknown | ask | 162.6700 | 0.9000 | ["155","160"] | ["1.9630","0.2895"] | [] | ["XBOX"] | 155.0000 | 160.0000 | 0 | 63 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:26:47Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b0d6-ecc3-7f02-88fc-d7c0f3979e0d | XOM | 2026-09-17 15:27 | call_vertical_spread | 2 | 1 | 630 | 85050.00 | unknown | — | 162.7600 | 0.1600 | ["167.5","172.5"] | ["0.2832","0.2888"] | [] | ["EDGO"] | 167.5000 | 172.5000 | 8 | 8 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:28:00Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0d5-6a0b-74f3-9e33-dfb803e801c0 | XOM | 2026-09-17 15:26 | call_vertical_spread | 2 | 1 | 500 | 120000.00 | unknown | — | 162.7801 | 0.1100 | ["165","170"] | ["0.2837","0.2840"] | [] | ["EDGO"] | 165.0000 | 170.0000 | 8 | 8 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:26:38Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0b3-4bab-7282-977d-c5841e2d7a96 | XOM | 2026-09-17 14:48 | call_diagonal_spread | 2 | 1 | 120 | 129280.00 | unknown | — | 162.8400 | 1.1000 | ["155","160"] | ["0.4471","0.2890"] | [] | ["XMIO"] | 155.0000 | 160.0000 | 1 | 15 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:49:10Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0a643-14e6-7622-9f72-6aea9d6b2d5a | XOM | 2026-09-15 14:10 | call_diagonal_spread | 2 | 1 | 25 | 48650.00 | unknown | — | 169.2650 | 0.5000 | ["155","185"] | ["0.5740","0.2937"] | [] | ["XCBO"] | 155.0000 | 185.0000 | 3 | 94 | false | false | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T18:10:45Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a615-88be-7400-86dc-eac4e83b44a0 | XOM | 2026-09-15 13:20 | call_calendar | 2 | 1 | 4 | 27924.00 | unknown | — | 169.1700 | 2.6000 | ["135"] | ["0.8757"] | [] | ["XCBO"] | 135.0000 | 135.0000 | 3 | 94 | false | false | true | false | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:20:49Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 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 | 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 |
| 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 | 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 |
| 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 | 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 |
| 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 | 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 |
| 01a0a06b-1908-7740-8d37-3a0cfa784cff | XOM | 2026-09-14 10:56 | put_vertical_spread | 2 | 1 | 120 | 137760.00 | unknown | — | 167.5100 | 0.5000 | ["155","160"] | ["0.3211","0.3199"] | [] | ["XCBO"] | 155.0000 | 160.0000 | 95 | 95 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T14:56:27Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a06a-da88-74c0-966b-7199b09d431d | XOM | 2026-09-14 10:55 | put_vertical_spread | 2 | 1 | 42 | 49392.00 | unknown | — | 167.4500 | 0.5500 | ["155","160"] | ["0.3255","0.3237"] | [] | ["XBOX"] | 155.0000 | 160.0000 | 95 | 95 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T14:55:57Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 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 | 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 |
| 01a090fa-7dd8-74d3-8066-c753897ebd5b | XOM | 2026-09-11 10:58 | call_vertical_spread | 2 | 1 | 2 | 36950.00 | unknown | — | 164.8750 | 2.4000 | ["70","75"] | ["3.1435","2.9083"] | [] | ["AMXO"] | 70.0000 | 75.0000 | 7 | 7 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T14:59:16Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 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 | 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 |
| 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 | 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 |
| 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 | 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 |
| 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 | 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 |
| 01a08666-6467-7651-8a3c-467b7f957283 | XOM | 2026-09-09 09:40 | iron_condor | 4 | 1 | 170 | 99620.00 | unknown | — | 164.7950 | 0.7500 | ["155","160","167.5","170"] | ["0.3452","0.3293","0.3342","0.3328"] | [] | ["XMIO"] | 155.0000 | 170.0000 | 9 | 9 | false | true | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T13:41:03Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 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 | 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 |
| 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-04T16:50:23Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |