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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a09202-9f08-7b32-8531-43426807f27e | XOM | 2026-09-11 15:47 | call_diagonal_spread | 2 | 1 | 10 | 33380.00 | short | bid | 165.2600 | 1.0500 | ["150","155"] | ["0.3698","0.2839"] | [] | ["XMIO"] | 150.0000 | 155.0000 | 7 | 126 | false | false | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:47:31Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a09136-c770-73b0-893e-c2cf33daf3de | XOM | 2026-09-11 12:04 | call_calendar | 2 | 1 | 161 | 507472.00 | long | ask | 165.6200 | 1.0500 | ["150"] | ["1.3396"] | [] | ["XMIO"] | 150.0000 | 150.0000 | 0 | 7 | false | false | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T16:04:51Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a09132-bc48-7d43-9171-e6048faa907f | XOM | 2026-09-11 12:00 | call_calendar | 2 | 1 | 6 | 25392.00 | short | ask | 165.7300 | 1.2000 | ["145"] | ["0.3963"] | [] | ["XCBO"] | 145.0000 | 145.0000 | 7 | 35 | false | false | true | false | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T16:00:24Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 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 |
| 01a090e1-48b8-7d63-a50d-c48c9c28f595 | XOM | 2026-09-11 10:31 | call_diagonal_spread | 2 | 1 | 50 | 322200.00 | long | ask | 166.0050 | 3.1000 | ["135","145"] | ["0.4309","0.2416"] | [] | ["XCBO"] | 135.0000 | 145.0000 | 35 | 371 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T14:31:23Z"} | 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 |
| 01a08c5d-fae8-7c73-b139-516cee55e1e4 | XOM | 2026-09-10 13:29 | call_condor | 4 | 1 | 5 | 57285.00 | long | ask | 165.5475 | 8.6000 | ["135","140","175","180"] | ["0.1998","0.2172","0.2436","0.2472"] | ["136.37","178.63"] | ["XMIO"] | 135.0000 | 180.0000 | 498 | 498 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T17:29:30Z"} | 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 |
| 01a08b90-8158-7e53-8071-20a7a5d3492b | XOM | 2026-09-10 09:44 | call_vertical_spread | 2 | 1 | 100 | 59500.00 | long | ask | 164.8050 | 0.4900 | ["170","180"] | ["0.3001","0.3027"] | ["172.59"] | ["XMIO"] | 170.0000 | 180.0000 | 36 | 36 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T13:45:04Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a086d9-0040-7a32-bc5e-cc0f59f9f2e6 | XOM | 2026-09-09 11:46 | call_diagonal_spread | 2 | 1 | 17 | 34663.00 | short | bid | 163.3950 | 0.6000 | ["155","165"] | ["0.3366","0.2840"] | [] | ["EDGO"] | 155.0000 | 165.0000 | 9 | 128 | false | false | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T15:46:13Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a086d8-15e0-7c43-992f-f20ea11bb9ed | XOM | 2026-09-09 11:45 | call_diagonal_spread | 2 | 1 | 20 | 40846.00 | short | bid | 163.3750 | 0.5000 | ["155","165"] | ["0.3411","0.2848"] | [] | ["EDGO"] | 155.0000 | 165.0000 | 9 | 128 | false | false | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T15:45:34Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a086c2-d478-7c33-b619-70f6c0b25bbe | XOM | 2026-09-09 11:21 | call_calendar | 2 | 1 | 13 | 62361.00 | short | ask | 163.3600 | 2.2500 | ["140"] | ["0.4831"] | [] | ["XMIO"] | 140.0000 | 140.0000 | 9 | 44 | false | false | true | false | false | mlat | tracked | 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 |
| 01a08670-a950-76e1-8aa5-d0f8bbc5ea1c | XOM | 2026-09-09 09:52 | call_vertical_spread | 2 | 1 | 6 | 30120.00 | short | bid | 164.7200 | 3.7000 | ["170","180"] | ["0.2373","0.2403"] | ["173.88"] | ["XPHO"] | 170.0000 | 180.0000 | 828 | 828 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T13:52:26Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 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 |
| 01a06d89-3486-72e1-98a5-1e7fae851f73 | XOM | 2026-09-04 13:48 | call_diagonal_spread_bearish | 2 | 1 | 18 | 46494.00 | long | bid | 160.1500 | 1.5500 | ["150","155"] | ["0.2885","0.2694"] | [] | ["XCBO"] | 150.0000 | 155.0000 | 42 | 105 | false | false | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T17:48:28Z"} | 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 |
| 01a06d53-4fa5-7802-8caa-152512c155b0 | XOM | 2026-09-04 12:49 | call_butterfly_spread | 3 | 1 | 1560 | 158858.00 | short | bid | 160.5000 | 0.2500 | ["162.5","167.5","172.5"] | ["0.2376","0.2522","0.2821"] | ["163.26","171.74"] | ["EDGO"] | 162.5000 | 172.5000 | 7 | 7 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T16:49:50Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |