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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c53c-8fdf-7400-b4e8-8ddccf0651bc | XOM | 2026-09-21 14:31 | synthetic | 2 | 1 | 10 | 51670.00 | short | bid | 158.9300 | 1.6500 | ["160"] | ["0.2803"] | ["165.85"] | ["XMIO"] | 160.0000 | 160.0000 | 816 | 816 | false | false | false | false | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T18:31:22Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c539-b567-7852-836e-2ee20ca0ca3e | XOM | 2026-09-21 14:28 | synthetic | 2 | 1 | 10 | 52230.00 | short | bid | 158.8550 | 2.6500 | ["160"] | ["0.2778"] | ["166.15"] | ["XCBO"] | 160.0000 | 160.0000 | 851 | 851 | false | false | false | false | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T18:28:12Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c539-347e-78b0-9c1b-f8b998aad769 | XOM | 2026-09-21 14:27 | synthetic | 2 | 1 | 10 | 52230.00 | short | bid | 158.9400 | 2.6500 | ["160"] | ["0.2776"] | ["166.15"] | ["XCBO"] | 160.0000 | 160.0000 | 851 | 851 | false | false | false | false | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T18:27:43Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c43b-3cdf-7623-af44-f5b69c86292a | XOM | 2026-09-21 09:50 | call_vertical_spread | 2 | 1 | 5 | 30820.00 | short | bid | 160.0200 | 4.7000 | ["130","135"] | ["0.3099","0.3050"] | ["134.32"] | ["XCBO"] | 130.0000 | 135.0000 | 116 | 116 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T13:50:15Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c438-bc3f-7c93-a7fe-76ae3f6cdf6d | XOM | 2026-09-21 09:47 | call_calendar | 2 | 1 | 6 | 93018.00 | short | ask | 160.0100 | 5.9500 | ["85"] | ["0.3660"] | [] | ["XCBO"] | 85.0000 | 85.0000 | 487 | 851 | false | false | true | false | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T13:47:36Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c431-cae7-7f61-9f4b-50272996b99a | XOM | 2026-09-21 09:39 | call_vertical_spread | 2 | 1 | 42 | 25998.00 | short | bid | 159.9648 | 0.7000 | ["160","175"] | ["0.3015","0.3081"] | ["164.27"] | ["XBOX"] | 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-21T13:40:03Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b041-adbb-7e63-9142-1ad8115d5070 | XOM | 2026-09-17 12:44 | call_calendar | 2 | 1 | 9 | 63801.00 | short | ask | 162.2551 | 1.0500 | ["150"] | ["0.2061"] | [] | ["XCBO"] | 150.0000 | 150.0000 | 820 | 855 | false | false | true | false | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T16:45:17Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0a5a3-6dce-7ee0-8448-4533b50066af | XOM | 2026-09-15 11:15 | call_condor | 4 | 1 | 5 | 51350.00 | short | bid | 168.3900 | 7.4000 | ["145","150","185","190"] | ["0.2121","0.2196","0.2543","0.2555"] | ["146.40","188.60"] | ["XCBO"] | 145.0000 | 190.0000 | 493 | 493 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T15:15:56Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a569-3f46-7202-af78-79905d7e8585 | XOM | 2026-09-15 10:12 | call_vertical_spread | 2 | 1 | 20 | 28340.00 | short | bid | 167.6700 | 0.5600 | ["155","170"] | ["0.5068","0.3733"] | ["166.53"] | ["XMIO"] | 155.0000 | 170.0000 | 3 | 3 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:12:25Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a560-a03e-7413-879a-21b5149f852d | XOM | 2026-09-15 10:02 | call_diagonal_spread | 2 | 1 | 30 | 62040.00 | short | ask | 167.6300 | 4.8500 | ["157.5","162.5"] | ["0.2607","0.2941"] | [] | ["XMIO"] | 157.5000 | 162.5000 | 10 | 45 | false | false | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:02:53Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a551-274e-7460-844f-6ce5cb1ba191 | XOM | 2026-09-15 09:45 | call_diagonal_spread | 2 | 1 | 8 | 39584.00 | short | bid | 167.3400 | 4.6500 | ["165","180"] | ["0.2401","0.2244"] | [] | ["XCBO"] | 165.0000 | 180.0000 | 493 | 822 | false | false | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T13:46:13Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a0c9-fa18-7bf3-b7fe-6eef4a14a853 | XOM | 2026-09-14 12:39 | call_diagonal_spread | 2 | 1 | 238 | 538356.00 | short | ask | 165.8600 | 0.6500 | ["150","175"] | ["0.3279","0.2920"] | [] | ["XPHO"] | 150.0000 | 175.0000 | 32 | 67 | 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 |
| 01a0a0ab-b030-7d23-881e-863e71da2085 | XOM | 2026-09-14 12:06 | call_condor | 4 | 1 | 10 | 79460.00 | short | bid | 166.0350 | 9.2000 | ["150","175","180","200"] | ["0.2589","0.2666","0.2680","0.2746"] | ["156.40","198.60"] | ["XPHO"] | 150.0000 | 200.0000 | 459 | 459 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T16:06:49Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a084-5dc8-7010-8508-130cef9d04c7 | XOM | 2026-09-14 11:23 | call_diagonal_spread | 2 | 1 | 12 | 28548.00 | short | ask | 167.0300 | 0.6000 | ["155","165"] | ["0.4364","0.2835"] | [] | ["XCBO"] | 155.0000 | 165.0000 | 4 | 95 | false | false | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T15:23:59Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a03a-9af8-70e1-b128-7eff4918b9ee | XOM | 2026-09-14 10:03 | call_vertical_spread | 2 | 1 | 5 | 28355.00 | short | bid | 168.2650 | 1.4000 | ["130","150"] | ["0.8700","0.5161"] | ["149.95"] | ["XPHO"] | 130.0000 | 150.0000 | 4 | 4 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T14:03:18Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 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 |
| 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 |
| 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 |
| 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 |