core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg403,968 rowsexportable| idtext | tickertext | executed_at ↑timestamp with time zone | strategytext | leg_countinteger | txnsinteger | sizebigint | total_premiumnumeric | directiontext |
|---|
| 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 |
|---|
| 01a06d30-bffd-70e2-9e25-103690ded5a0 | XOM | 2026-09-04 12:11 | call_calendar | 2 | 1 | 20 | 38200.00 | short | bid | 160.2200 | 1.8000 | ["155"] | ["0.2764"] | [] | ["XISX"] | 155.0000 | 155.0000 | 42 | 49 | false | false | true | false | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T16:12:10Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d3b-acdd-77b2-815f-f03cae47fc10 | XOM | 2026-09-04 12:23 | call_calendar | 2 | 2 | 18 | 110070.00 | short | ask | 160.1600 | 4.4000 | ["130"] | ["3.1692"] | [] | ["C2OX","EDGO"] | 130.0000 | 130.0000 | 0 | 21 | false | false | true | false | |||||||||
| 01a06d3b-b4ae-70b3-b17c-39f2fff29eb5 | XOM | 2026-09-04 12:23 | call_calendar | 2 | 1 | 30 | 183420.00 | short | ask | 160.1600 | 4.4000 | ["130"] | ["3.1490"] | [] | ["EDGO"] | 130.0000 | 130.0000 | 0 | 21 | false | false | true | false | |||||||||
| 01a08165-ef88-7d02-bde3-182b8a118029 | XOM | 2026-09-08 10:22 | call_calendar | 2 | 1 | 8 | 69080.00 | short | bid | 161.2350 | 5.0000 | ["120"] | ["0.3371"] | [] | ["XMIO"] | 120.0000 | 120.0000 | 129 | 192 | false | false | true | false | |||||||||
| 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 | |||||||||
| 01a08c88-2bb0-7d42-8b5b-75da9fa40f2b | XOM | 2026-09-10 14:15 | call_calendar | 2 | 1 | 10 | 100910.00 | short | ask | 165.7200 | 4.8000 | ["115"] | ["2.4421"] | [] | ["BATO"] | 115.0000 | 115.0000 | 1 | 43 | false | false | true | false | |||||||||
| 01a0912b-e260-7c42-aaef-edb3e132b70a | XOM | 2026-09-11 11:52 | call_calendar | 2 | 1 | 8 | 34832.00 | short | bid | 165.5985 | 1.4500 | ["145"] | ["0.4056"] | [] | ["MCRY"] | 145.0000 | 145.0000 | 7 | 70 | false | false | true | false | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 01a0a0e6-57d0-7c60-a786-6beb84517074 | XOM | 2026-09-14 13:10 | call_calendar | 2 | 1 | 23 | 82455.00 | short | bid | 165.2000 | 3.0500 | ["150"] | ["0.3263"] | [] | ["C2OX"] | 150.0000 | 150.0000 | 32 | 67 | false | false | true | false | |||||||||
| 01a0a178-2fc0-7ca0-90ab-e7601c20b9c1 | XOM | 2026-09-14 15:50 | call_calendar | 2 | 1 | 14 | 30842.00 | short | ask | 164.4800 | 1.5000 | ["155"] | ["0.3616"] | [] | ["XISX"] | 155.0000 | 155.0000 | 4 | 32 | false | false | true | false | |||||||||
| 01a0a5a0-a2f6-78e0-bbce-9a2599db39b9 | XOM | 2026-09-15 11:12 | call_calendar | 2 | 1 | 28 | 136836.00 | unknown | — | 168.2100 | 3.0500 | ["145"] | ["0.2748"] | [] | ["ARCO"] | 145.0000 | 145.0000 | 31 | 66 | false | false | true | false | false | mlet | |||||||
| 01a0a615-88be-7400-86dc-eac4e83b44a0 | XOM | 2026-09-15 13:20 | call_calendar | 2 | 1 | 4 | 27924.00 | unknown | — | 169.1700 | 2.6000 | ["135"] | ["0.8757"] | [] | ["XCBO"] | 135.0000 | 135.0000 | 3 | 94 | false | false | true | false | false | mlat | |||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 01a0ab21-02c3-7c52-a91a-839058f0aec7 | XOM | 2026-09-16 12:51 | call_calendar | 2 | 1 | 5 | 38325.00 | unknown | — | 164.8650 | 1.2000 | ["130"] | ["0.2431"] | [] | ["C2OX"] | 130.0000 | 130.0000 | 93 | 274 | false | false | true | false | false | mesl | |||||||
| 01a0aba3-1b73-7d81-ac89-62cff875f743 | XOM | 2026-09-16 15:13 | call_calendar | 2 | 3 | 30 | 34246.00 | short | ask | 163.0400 | 0.6500 | ["160"] | ["0.3509"] | [] | ["AMXO","XCBO","XISX"] | 160.0000 | 160.0000 | 2 | 30 | false | false | true | false | |||||||||
| 01a0afb1-ae74-7f60-954f-7c12d7f83ba3 | XOM | 2026-09-17 10:07 | call_calendar | 2 | 1 | 100 | 27400.00 | unknown | — | 161.9000 | 0.2300 | ["172.5"] | ["0.3040"] | [] | ["EDGO"] | 172.5000 | 172.5000 | 8 | 36 | false | true | true | false | false | mlet | |||||||
| 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 | |||||||||
| 01a0b539-40e7-7761-ac24-12c8e483371e | XOM | 2026-09-18 11:53 | call_calendar | 2 | 1 | 12 | 27540.00 | short | ask | 162.9000 | 1.9000 | ["155"] | ["0.3059"] | [] | ["XISX"] | 155.0000 | 155.0000 | 35 | 42 | false | false | true | false | |||||||||
| 01a0b55c-97c7-7272-a439-88a80d8d8567 | XOM | 2026-09-18 12:32 | call_calendar | 2 | 1 | 4 | 26820.00 | short | bid | 162.7500 | 1.9500 | ["155"] | ["0.2162"] | [] | ["XCBO"] | 155.0000 | 155.0000 | 819 | 854 | 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 | |||||||||
| 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 | |||||||||
| 01a0c95e-fce7-7373-bea5-b52bdda52363 | XOM | 2026-09-22 09:47 | call_calendar | 2 | 1 | 13 | 30446.00 | short | ask | 157.6050 | 1.3500 | ["160"] | ["0.2684"] | [] | ["XMIO"] | 160.0000 | 160.0000 | 87 | 268 | false | true | true | false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:23:43Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:23:43Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T14:22:33Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| 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 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T18:16:10Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T15:53:05Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| 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 |
| 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 |
| 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 |
| 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 |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T17:11:21Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T19:50:08Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T15:12:55Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T17:20:49Z"} |
| 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 |
| 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 |
| 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 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T16:51:30Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T19:13:09Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T14:07:36Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| 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 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T15:53:44Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T16:32:49Z"} |
| 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-18T18:21:39Z"} |
| 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-21T13:47:36Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T13:47:20Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |