Multi-leg option trades
core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
312,778 rowsCSV — whole table, not this view
Sources in this table
uw_multileg312,778 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b5c6-9497-7f60-93a6-d90730c590eb | XLE | 2026-09-18 14:28 | call_calendar | 2 | 1 | 25 | 60825.00 | short | bid | 64.4450 | 0.5500 | ["52.5"] | ["4.0702"] | [] | ["XMIO"] | 52.5000 | 52.5000 | 0 | 119 | false | false | true | false | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:28:37Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b582-a5f7-7293-b52b-4ef062097b3f | XLE | 2026-09-18 13:13 | call_calendar | 2 | 1 | 10 | 34940.00 | unknown | bid | 64.3650 | 0.5000 | ["47"] | ["3.3120"] | [] | ["BATO"] | 47.0000 | 47.0000 | 0 | 119 | false | false | true | false | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:14:06Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b51a-a10f-73a3-b4d6-829434777f8a | XLE | 2026-09-18 11:20 | call_calendar | 2 | 1 | 20 | 49520.00 | short | ask | 64.6850 | 0.7000 | ["52.5"] | ["2.4912"] | [] | ["XCBO"] | 52.5000 | 52.5000 | 0 | 119 | false | false | true | false | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:20:33Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b503-f847-7610-8146-32bee3072bee | XLE | 2026-09-18 10:55 | call_calendar | 2 | 1 | 16 | 46592.00 | unknown | bid | 64.4100 | 0.9000 | ["50"] | ["3.0645"] | [] | ["XCBO"] | 50.0000 | 50.0000 | 0 | 63 | false | false | true | false | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:55:47Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b502-8147-7292-95d4-759fecd37e4f | XLE | 2026-09-18 10:53 | call_calendar | 2 | 1 | 50 | 55300.00 | short | bid | 64.4600 | 0.4500 | ["60"] | ["1.0547"] | [] | ["XCBO"] | 60.0000 | 60.0000 | 0 | 119 | false | false | true | false | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:54:00Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4db-1388-7321-a814-f6fb67de5469 | XLE | 2026-09-18 10:10 | call_calendar | 2 | 1 | 10 | 35940.00 | long | ask | 64.3950 | 0.7500 | ["46.5"] | ["3.1932"] | [] | ["XISX"] | 46.5000 | 46.5000 | 0 | 91 | false | false | true | false | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:11:06Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4d7-6238-7ab2-8a0f-40fd3171508d | XLE | 2026-09-18 10:06 | call_calendar | 2 | 1 | 35 | 101500.00 | short | ask | 64.3400 | 0.7000 | ["50"] | ["2.0517"] | [] | ["XISX"] | 50.0000 | 50.0000 | 0 | 91 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:06:48Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4d6-f4d7-7770-87a2-07cd0dca1f5e | XLE | 2026-09-18 10:06 | call_calendar | 2 | 1 | 500 | 72500.00 | short | ask | 64.3500 | 0.0200 | ["65"] | ["0.2592"] | [] | ["AMXO"] | 65.0000 | 65.0000 | 0 | 28 | false | true | true | false | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:06:30Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4c0-9a30-7913-a959-114037dd9fdb | XLE | 2026-09-18 09:41 | call_calendar | 2 | 1 | 10 | 35500.00 | long | ask | 64.2600 | 0.7000 | ["46.5"] | ["2.9396"] | [] | ["XMIO"] | 46.5000 | 46.5000 | 0 | 91 | false | false | true | false | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T13:41:57Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4bd-d33f-78a1-9c68-4029357462cd | XLE | 2026-09-18 09:38 | call_calendar | 2 | 1 | 10 | 35400.00 | long | ask | 64.1300 | 0.5000 | ["46.5"] | ["3.1533"] | [] | ["XMIO"] | 46.5000 | 46.5000 | 0 | 91 | false | false | true | false | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T13:39:02Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b07b-24ab-73c2-8911-afd85dc7411e | XLE | 2026-09-17 13:47 | call_calendar | 2 | 1 | 30 | 58650.00 | short | ask | 64.3100 | 0.3000 | ["55"] | ["0.2912"] | [] | ["BATO"] | 55.0000 | 55.0000 | 13 | 105 | false | false | true | false | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T17:48:18Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b03f-1993-7c91-b42a-d3769fb66795 | XLE | 2026-09-17 12:41 | call_calendar | 2 | 1 | 44 | 126324.00 | short | ask | 64.1350 | 1.9500 | ["50"] | ["0.4115"] | [] | ["ARCO"] | 50.0000 | 50.0000 | 13 | 105 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T16:42:32Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b036-3c0b-7990-912a-367765edb4d5 | XLE | 2026-09-17 12:32 | call_calendar | 2 | 1 | 19 | 50521.00 | unknown | — | 64.1900 | 0.7000 | ["51"] | ["1.1969"] | [] | ["ARCO"] | 51.0000 | 51.0000 | 1 | 92 | false | false | true | false | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T16:32:34Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0a546-2eb6-7391-8f16-2279fe570f49 | XLE | 2026-09-15 09:33 | call_calendar | 2 | 1 | 100 | 113000.00 | short | ask | 65.0400 | 0.4000 | ["60"] | ["0.3893"] | [] | ["EDGO"] | 60.0000 | 60.0000 | 3 | 66 | false | false | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T13:34:05Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a059-0fd9-7751-82f1-be2b43ac9b95 | XLE | 2026-09-14 10:36 | call_calendar | 2 | 5 | 23 | 72915.00 | short | bid | 65.6450 | 0.3500 | ["50"] | ["0.7666"] | [] | ["ARCO","EMLD","SPHR","XISX","XPHO"] | 50.0000 | 50.0000 | 4 | 95 | false | false | true | false | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T14:36:31Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0824a-40c0-7780-a13e-5d67f57e3fa7 | XLE | 2026-09-08 14:31 | call_calendar | 2 | 1 | 10 | 29800.00 | short | ask | 64.8450 | 5.5000 | ["50"] | ["1.3465"] | [] | ["XCBO"] | 50.0000 | 50.0000 | 3 | 15 | false | false | true | false | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T18:32:13Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08231-a7e0-7f42-b63c-918380ae6138 | XLE | 2026-09-08 14:04 | call_calendar | 2 | 1 | 296 | 1185598.00 | short | bid | 64.6770 | 2.2500 | ["45"] | ["0.7441"] | [] | ["XCBO"] | 45.0000 | 45.0000 | 10 | 192 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T18:05:26Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a06d7c-f7b5-77f3-84e8-de4edbdf0e44 | XLE | 2026-09-04 13:34 | call_calendar | 2 | 1 | 10 | 28330.00 | short | ask | 64.2150 | 3.3500 | ["50"] | ["7.2743"] | [] | ["BATO"] | 50.0000 | 50.0000 | 0 | 7 | false | false | true | false | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T17:35:32Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |