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 |
|---|
| 01a0ca51-2516-7302-9170-235b5079e95e | USO | 2026-09-22 14:11 | call_calendar | 2 | 1 | 100 | 219800.00 | long | ask | 144.4600 | 4.2500 | ["135"] | ["0.5289"] | [] | ["BATO"] | 135.0000 | 135.0000 | 8 | 10 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T18:11:57Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0c9b1-fee7-7703-a111-43396f3ec4fd | USO | 2026-09-22 11:17 | call_calendar | 2 | 1 | 60 | 174900.00 | long | ask | 146.4200 | 2.6000 | ["185"] | ["0.3781"] | [] | ["XPHO"] | 185.0000 | 185.0000 | 360 | 542 | false | true | true | false | |||||||||
| 01a0c9b1-ef47-7b81-b950-6c70f9253eed | USO | 2026-09-22 11:17 | call_calendar | 2 | 2 | 135 | 393465.00 | long | bid | 146.4200 | 2.8222 | ["185"] | ["0.3783"] | [] | ["XCBO","XISX"] | 185.0000 | 185.0000 | 360 | 542 | false | true | true | false | |||||||||
| 01a0c95f-b866-7072-b8e8-1c313c776914 | USO | 2026-09-22 09:48 | call_calendar | 2 | 1 | 25 | 288750.00 | long | ask | 145.7500 | 4.0000 | ["100"] | ["0.3667"] | [] | ["XPHO"] | 100.0000 | 100.0000 | 542 | 633 | false | false | true | false | |||||||||
| 01a0c94f-7070-72c3-a7ee-fa7044faa15b | USO | 2026-09-22 09:30 | call_calendar | 2 | 2 | 26 | 300923.00 | long | bid | 145.3500 | 9.5500 | ["100"] | ["0.3799"] | [] | ["ARCO","XMIO"] | 100.0000 | 100.0000 | 542 | 633 | false | false | true | false | |||||||||
| 01a0c94f-457c-7302-896a-7e77a8d7c94a | USO | 2026-09-22 09:30 | call_calendar | 2 | 1 | 50 | 583300.00 | long | ask | 145.4200 | 11.4000 | ["100"] | ["0.3918"] | [] | ["XCBO"] | 100.0000 | 100.0000 | 542 | 633 | false | false | true | false | |||||||||
| 01a0c572-93ff-73c1-9321-49c540336596 | USO | 2026-09-21 15:30 | call_calendar | 2 | 1 | 10 | 121360.00 | long | bid | 147.9762 | 5.7000 | ["100"] | ["0.3927"] | [] | ["XISX"] | 100.0000 | 100.0000 | 543 | 634 | false | false | true | false | |||||||||
| 01a0c4fc-8d27-7b33-a851-b8be14823199 | USO | 2026-09-21 13:21 | call_calendar | 2 | 1 | 69 | 820065.00 | long | ask | 147.4100 | 2.0500 | ["100"] | ["0.3719"] | [] | ["XISX"] | 100.0000 | 100.0000 | 543 | 634 | false | false | true | false | |||||||||
| 01a0c4fb-6fff-7170-9d1a-7b0ee0ccd83e | USO | 2026-09-21 13:20 | call_calendar | 2 | 1 | 53 | 630064.00 | long | bid | 147.3600 | 2.2000 | ["100"] | ["0.3736"] | [] | ["BATO"] | 100.0000 | 100.0000 | 543 | 634 | false | false | true | false | |||||||||
| 01a0c4fb-0a6f-7da2-bd4c-9442ddd251e7 | USO | 2026-09-21 13:19 | call_calendar | 2 | 1 | 50 | 594100.00 | long | ask | 147.3400 | 2.4000 | ["100"] | ["0.3732"] | [] | ["XPHO"] | 100.0000 | 100.0000 | 543 | 634 | false | false | true | false | |||||||||
| 01a0c4f8-2827-7463-a8ca-515c360b77b6 | USO | 2026-09-21 13:16 | call_calendar | 2 | 2 | 25 | 296900.00 | long | ask | 147.3950 | 2.9000 | ["100"] | ["0.3710"] | [] | ["BATO"] | 100.0000 | 100.0000 | 543 | 634 | false | false | true | false | |||||||||
| 01a0c440-1326-79d3-a9f9-6420cb36e49c | USO | 2026-09-21 09:55 | call_calendar | 2 | 1 | 75 | 154125.00 | long | bid | 149.2226 | 0.6000 | ["144"] | ["0.4700"] | [] | ["XPHO"] | 144.0000 | 144.0000 | 18 | 32 | false | false | true | false | |||||||||
| 01a0c43f-ec17-7dd0-b79c-42f821af13d9 | USO | 2026-09-21 09:55 | call_calendar | 2 | 1 | 75 | 155025.00 | long | ask | 149.3300 | 0.3500 | ["144"] | ["0.4691"] | [] | ["AMXO"] | 144.0000 | 144.0000 | 18 | 32 | true | false | true | false | |||||||||
| 01a0b50f-94ef-7132-883b-b0071acb99b5 | USO | 2026-09-18 11:08 | call_calendar | 2 | 1 | 14 | 115178.00 | long | ask | 155.8891 | 1.7000 | ["115"] | ["3.0180"] | [] | ["XCBO"] | 115.0000 | 115.0000 | 0 | 28 | false | false | true | false | |||||||||
| 01a0b50f-94ef-7132-883b-affd0369f099 | USO | 2026-09-18 11:08 | call_calendar | 2 | 4 | 18 | 147644.00 | long | ask | 155.8891 | 1.9500 | ["115"] | ["2.7871"] | [] | ["ARCO","EMLD","SPHR","XPHO"] | 115.0000 | 115.0000 | 0 | 28 | false | false | true | false | |||||||||
| 01a0b4d3-958f-7cc2-b5d0-3c15a87d2f86 | USO | 2026-09-18 10:02 | call_calendar | 2 | 1 | 33 | 120318.00 | long | bid | 156.9300 | 0.9000 | ["140"] | ["1.2683"] | [] | ["XMIO"] | 140.0000 | 140.0000 | 0 | 28 | false | false | true | false | |||||||||
| 01a0b4ba-8f4f-7c01-83f6-1e467f489418 | USO | 2026-09-18 09:35 | call_calendar | 2 | 1 | 30 | 109500.00 | long | bid | 157.1100 | 1.0500 | ["140"] | ["1.4902"] | [] | ["XCBO"] | 140.0000 | 140.0000 | 0 | 28 | false | false | true | false | |||||||||
| 01a0afdc-44cb-7541-86a2-b2dde6019def | USO | 2026-09-17 10:54 | call_calendar | 2 | 1 | 10 | 109020.00 | long | bid | 154.7900 | 2.9500 | ["100"] | ["1.1012"] | [] | ["XMIO"] | 100.0000 | 100.0000 | 8 | 29 | false | false | true | false | |||||||||
| 01a0ab9c-2e03-7012-b57c-c179292282eb | USO | 2026-09-16 15:05 | call_calendar | 2 | 1 | 80 | 113680.00 | long | ask | 156.9999 | 1.7500 | ["150"] | ["2.2273"] | [] | ["XMIO"] | 150.0000 | 150.0000 | 0 | 2 | false | false | true | false | |||||||||
| 01a0ab9a-e9cb-7b32-94a7-7abdbf609d66 | USO | 2026-09-16 15:04 | call_calendar | 2 | 1 | 60 | 144480.00 | long | ask | 156.8700 | 1.8500 | ["145"] | ["2.5229"] | [] | ["BATO"] | 145.0000 | 145.0000 | 0 | 2 | false | false | true | false | |||||||||
| 01a0ab98-ea13-76b1-9ace-198f8dbc03b6 | USO | 2026-09-16 15:01 | call_calendar | 2 | 1 | 40 | 103360.00 | long | ask | 157.1682 | 2.8500 | ["144"] | ["3.5149"] | [] | ["BATO"] | 144.0000 | 144.0000 | 0 | 2 | false | false | true | false | |||||||||
| 01a0ab1a-404b-7bc2-9df7-83caf50efdf7 | USO | 2026-09-16 12:43 | call_calendar | 2 | 3 | 22 | 121911.00 | long | ask | 156.9999 | 1.0000 | ["130"] | ["0.9745"] | [] | ["BATO","C2OX","EDGO"] | 130.0000 | 130.0000 | 2 | 30 | false | false | true | false | |||||||||
| 01a0a5c1-2b16-7b10-a4ad-79c7028ed934 | USO | 2026-09-15 11:48 | call_calendar | 2 | 6 | 24 | 148462.00 | long | ask | 160.2890 | 2.1917 | ["130"] | ["1.1715"] | [] | ["ARCO","EMLD","SPHR","XBOX","XISX","XPHO"] | 130.0000 | 130.0000 | 1 | 31 | false | false | true | ||||||||||
| 01a0a54e-54a5-71c1-ac09-951b2a00c917 | USO | 2026-09-15 09:42 | call_calendar | 2 | 4 | 15 | 113710.00 | long | ask | 159.1800 | 3.1967 | ["121"] | ["2.1726"] | [] | ["ARCO","EMLD","SPHR","XBOX"] | 121.0000 | 121.0000 | 1 | 10 | false | false | true | false | |||||||||
| 01a090cb-0198-76b3-a0fd-bd213e0f63b5 | USO | 2026-09-11 10:06 | call_calendar | 2 | 1 | 30 | 239100.00 | long | ask | 153.1500 | 5.8000 | ["122"] | ["0.8153"] | [] | ["XISX"] | 122.0000 | 122.0000 | 7 | 553 | false | false | true | false | |||||||||
| 01a08700-52a8-7370-a76a-aaa06bbce85c | USO | 2026-09-09 12:28 | call_calendar | 2 | 5 | 21 | 104967.00 | long | ask | 149.3614 | 1.2476 | ["125"] | ["0.5340"] | [] | ["ARCO","EMLD","SPHR","XBOX","XPHO"] | 125.0000 | 125.0000 | 9 | 37 | false | false | true | false | |||||||||
| 01a08260-0ae0-7f50-966f-abfa30cbf81f | USO | 2026-09-08 14:55 | call_calendar | 2 | 1 | 16 | 118464.00 | long | bid | 145.8111 | 2.2000 | ["109"] | ["0.6331"] | [] | ["XCBO"] | 109.0000 | 109.0000 | 17 | 38 | false | false | true | false | |||||||||
| 01a08260-0ae0-7f50-966f-abe5d5ba219e | USO | 2026-09-08 14:55 | call_calendar | 2 | 6 | 24 | 177540.00 | long | bid | 145.8111 | 2.6125 | ["109"] | ["0.5782"] | [] | ["ARCO","EMLD","SPHR","XBOX","XISX","XPHO"] | 109.0000 | 109.0000 | 17 | 38 | false | false | true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T15:18:13Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T15:18:13Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T13:48:25Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T13:30:17Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T13:30:06Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T19:30:19Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T17:21:23Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T17:20:17Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T17:19:42Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T17:16:41Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T13:55:30Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T13:55:30Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T15:08:20Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T15:08:20Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:02:38Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T13:35:24Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T14:54:08Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T19:05:59Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T19:04:23Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T19:02:02Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T16:43:46Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T15:48:16Z"} |
| 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-15T13:43:01Z"} |
| 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-11T14:07:00Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T16:29:18Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T18:55:53Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T18:55:53Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |