core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg508,354 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 |
|---|
| 01a0d9f1-e097-7a70-bb6d-91b94b83b67a | XOM | 2026-09-25 15:01 | call_calendar | 2 | 1 | 161 | 341320.00 | unknown | ask | 160.4300 | 1.1500 | ["150"] | ["1.7260"] | [] | ["XISX"] | 150.0000 | 150.0000 | 0 | 7 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-25T19:01:54Z"} | 2026-09-25 | 2026-09-25 17:15 | 2026-09-25 17:15 |
| 01a0d9f1-28ff-7bf2-89fe-15a12db731d3 | XOM | 2026-09-25 15:00 | call_calendar | 2 | 1 | 21 | 44625.00 | short | ask | 160.4700 | 1.3000 | ["150"] | ["1.5685"] | [] | ["XMIO"] | 150.0000 | 150.0000 | 0 | 7 | false | false | true | false | |||||||||
| 01a0d9c6-4c57-7561-a22b-6c6c31383ef3 | XOM | 2026-09-25 14:14 | call_calendar | 2 | 1 | 11 | 152053.00 | short | ask | 160.3710 | 4.7500 | ["95"] | ["0.3505"] | [] | ["BATO"] | 95.0000 | 95.0000 | 483 | 812 | false | false | true | false | |||||||||
| 01a0d971-3aff-7f10-b27a-740d2987945f | XOM | 2026-09-25 12:41 | call_calendar | 2 | 1 | 15 | 83670.00 | short | ask | 160.4100 | 3.4500 | ["135"] | ["0.2733"] | [] | ["XISX"] | 135.0000 | 135.0000 | 84 | 112 | false | false | true | false | |||||||||
| 01a0d96a-b31f-7ac1-a606-3d811b513cbf | XOM | 2026-09-25 12:34 | call_calendar | 2 | 1 | 9 | 55566.00 | short | ask | 160.3200 | 4.5500 | ["130"] | ["3.8299"] | [] | ["C2OX"] | 130.0000 | 130.0000 | 0 | 7 | false | false | true | false | |||||||||
| 01a0d45d-da5e-7750-abe3-692f66db231e | XOM | 2026-09-24 13:01 | call_calendar | 2 | 1 | 4 | 51480.00 | short | ask | 162.1750 | 3.7000 | ["105"] | ["0.3356"] | [] | ["XISX"] | 105.0000 | 105.0000 | 813 | 848 | false | false | true | false | |||||||||
| 01a0d43a-f0df-7441-aeac-6d10f7fbdef1 | XOM | 2026-09-24 12:23 | call_calendar | 2 | 1 | 13 | 168480.00 | short | ask | 162.7200 | 6.8000 | ["105"] | ["0.3343"] | [] | ["XMIO"] | 105.0000 | 105.0000 | 813 | 848 | false | false | 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 | |||||||||
| 01a0cec2-7187-7fd1-ad38-1f5fc6742d35 | XOM | 2026-09-23 10:54 | call_calendar | 2 | 1 | 17 | 196350.00 | short | ask | 161.0150 | 6.0000 | ["110"] | ["0.3347"] | [] | ["XCBO"] | 110.0000 | 110.0000 | 485 | 849 | false | false | true | false | |||||||||
| 01a0cebd-e576-7540-bc04-8ddec20bfdcb | XOM | 2026-09-23 10:49 | call_calendar | 2 | 1 | 4 | 63232.00 | short | ask | 161.4500 | 8.1500 | ["85"] | ["0.3303"] | [] | ["XMIO"] | 85.0000 | 85.0000 | 814 | 849 | false | false | true | false | |||||||||
| 01a0cea2-04bf-72b0-9a87-8c6c7c08bb13 | XOM | 2026-09-23 10:18 | call_calendar | 2 | 2 | 6 | 74976.00 | unknown | ask | 161.8600 | 5.7000 | ["100"] | ["0.2740"] | [] | ["EMLD","SPHR"] | 100.0000 | 100.0000 | 114 | 359 | 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T19:00:56Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T18:14:36Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T16:41:28Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T16:34:03Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T17:02:05Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T16:23: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-23T18:12:39Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T14:54:02Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T14:49:38Z"} |
| 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-23T14:18:42Z"} |
| 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-22T13:47:20Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 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-18T15:53:44Z"} |
| 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-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-16T19:13:09Z"} |
| 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-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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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-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 |