core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg637,282 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 |
|---|
| 01a0f8ff-d7ff-7212-815f-50546446ca51 | XOM | 2026-10-01 15:45 | call_calendar | 2 | 1 | 15 | 28605.00 | long | bid | 163.6600 | 1.4500 | ["160"] | ["0.2799"] | [] | ["XMIO"] | 160.0000 | 160.0000 | 36 | 78 | false | false | true | false | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-10-01T19:45:30Z"} | 2026-10-01 | 2026-10-01 17:15 | 2026-10-01 17:15 |
| 01a0e98a-1c4f-7b60-ba44-56463f0cb078 | XOM | 2026-09-28 15:42 | call_calendar | 2 | 1 | 20 | 25640.00 | long | bid | 162.6300 | 0.6600 | ["165"] | ["0.2797"] | [] | ["XISX"] | 165.0000 | 165.0000 | 18 | 109 | false | true | true | false | |||||||||
| 01a0cf77-b7c7-7d30-a095-baec26edd7ea | XOM | 2026-09-23 14:12 | call_calendar | 2 | 1 | 5 | 41550.00 | long | ask | 161.0500 | 4.6500 | ["120"] | ["0.5722"] | [] | ["XISX"] | 120.0000 | 120.0000 | 23 | 114 | false | false | true | false | |||||||||
| 01a0b5c0-a8f8-7110-a8ef-32e346f6ec15 | XOM | 2026-09-18 14:21 | call_calendar | 2 | 1 | 10 | 31720.00 | long | bid | 162.8100 | 0.7500 | ["150"] | ["1.7606"] | [] | ["XMIO"] | 150.0000 | 150.0000 | 0 | 119 | false | false | true | false | |||||||||
| 01a0aa69-ebab-7f73-99a2-8a5ee0230951 | XOM | 2026-09-16 09:31 | call_calendar | 2 | 1 | 29 | 33814.00 | long | ask | 166.8500 | 2.4000 | ["162.5"] | ["0.4356"] | [] | ["XISX"] | 162.5000 | 162.5000 | 2 | 9 | false | false | true | false | |||||||||
| 01a0a650-ff66-7ab3-9d19-5832b5a60d84 | XOM | 2026-09-15 14:25 | call_calendar | 2 | 1 | 30 | 155370.00 | long | ask | 169.0200 | 1.7500 | ["145"] | ["0.3051"] | [] | ["XCBO"] | 145.0000 | 145.0000 | 31 | 94 | false | false | true | false | |||||||||
| 01a0a650-5b56-78c1-928d-36bcacc00562 | XOM | 2026-09-15 14:24 | call_calendar | 2 | 1 | 100 | 519299.00 | long | bid | 169.0100 | 2.3000 | ["145"] | ["0.3172"] | [] | ["XCBO"] | 145.0000 | 145.0000 | 31 | 94 | false | false | true | false | |||||||||
| 01a09136-dee0-76d3-924c-d2a877fdbb58 | XOM | 2026-09-11 12:04 | call_calendar | 2 | 1 | 75 | 236400.00 | long | ask | 165.5900 | 1.0500 | ["150"] | ["1.4261"] | [] | ["XMIO"] | 150.0000 | 150.0000 | 0 | 7 | false | false | true | false | |||||||||
| 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 | |||||||||
| 01a09135-2d48-7271-af0a-664ec3a4b1f5 | XOM | 2026-09-11 12:02 | call_calendar | 2 | 1 | 21 | 66024.00 | long | ask | 165.7000 | 1.0500 | ["150"] | ["1.8651"] | [] | ["XISX"] | 150.0000 | 150.0000 | 0 | 7 | false | false | true | false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-28T19:42:29Z"} |
| 2026-09-28 |
| 2026-09-28 17:15 |
| 2026-09-28 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T18:12:39Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T18:21:39Z"} |
| 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-16T13:31:02Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T18:25:43Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T18:24:42Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlet |
| 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 |
| 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 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T16:02:56Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |