core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg541,738 rowsexportable| idtext | tickertext | executed_at ↓timestamp with time zone | strategytext | leg_countinteger | txnsinteger | sizebigint | total_premiumnumeric | direction |
|---|
| 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 |
|---|
| 01a0d92a-568e-73e1-9ee2-c9e66d067ab8 | XLE | 2026-09-25 11:23 | call_calendar | 2 | 1 | 24 | 136176.00 | short | bid | 62.1500 | 2.3000 | ["35"] | ["0.3187"] | [] | ["XCBO"] | 35.0000 | 35.0000 | 812 | 847 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-25T15:24:09Z"} | 2026-09-25 | 2026-09-25 17:15 | 2026-09-25 17:15 |
| 01a0d40b-41d7-7be1-9a44-0d067fb24770 | XLE | 2026-09-24 11:31 | call_calendar | 2 | 1 | 20 | 72080.00 | short | bid | 63.3050 | 2.2500 | ["50"] | ["0.2078"] | [] | ["XISX"] | 50.0000 | 50.0000 | 813 | 848 | false | false | true | false | |||||||||
| 01a0d409-51be-7f83-9c51-f3d351b97a21 | XLE | 2026-09-24 11:29 | call_calendar | 2 | 1 | 28 | 45444.00 | short | bid | 63.3250 | 1.5500 | ["70"] | ["0.2064"] | [] | ["AMXO"] | 70.0000 | 70.0000 | 813 | 848 | false | true | true | false | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T15:31:44Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T15:29:52Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |