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 | 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 |
|---|
| 01a0c986-4b67-7f53-8518-bf35d5bf6c8b | USO | 2026-09-22 10:30 | call_calendar | 2 | 1 | 45 | 338445.00 | short | ask | 145.8900 | 6.3000 | ["144"] | ["0.3481"] | [] | ["XCBO"] | 144.0000 | 144.0000 | 815 | 850 | false | false | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T14:30:17Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 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 | |||||||||
| 01a0b507-a1c8-7f61-8e6e-0941510d926c | USO | 2026-09-18 10:59 | call_calendar | 2 | 1 | 10 | 103400.00 | short | bid | 155.9550 | 8.8500 | ["133"] | ["0.3677"] | [] | ["XCBO"] | 133.0000 | 133.0000 | 819 | 854 | false | false | true | false | |||||||||
| 01a0b502-cb80-72d0-b12f-237810543aef | USO | 2026-09-18 10:54 | call_calendar | 2 | 1 | 10 | 105640.00 | short | ask | 155.8800 | 8.9500 | ["131"] | ["0.3696"] | [] | ["XCBO"] | 131.0000 | 131.0000 | 819 | 854 | false | false | true | false | |||||||||
| 01a0b501-73c0-7002-a9b2-fd71c315eb54 | USO | 2026-09-18 10:52 | call_calendar | 2 | 1 | 10 | 106610.00 | short | ask | 155.8701 | 7.6000 | ["130"] | ["0.3690"] | [] | ["XCBO"] | 130.0000 | 130.0000 | 819 | 854 | false | false | true | false | |||||||||
| 01a0b501-1217-75e1-8403-fa30377e6fd6 | USO | 2026-09-18 10:52 | call_calendar | 2 | 1 | 10 | 106230.00 | short | ask | 155.8800 | 9.2500 | ["131"] | ["0.3738"] | [] | ["XCBO"] | 131.0000 | 131.0000 | 819 | 854 | false | false | true | false | |||||||||
| 01a0b500-cbc7-7871-a110-ea920ca27225 | USO | 2026-09-18 10:52 | call_calendar | 2 | 1 | 10 | 106610.00 | short | ask | 155.9800 | 7.6000 | ["130"] | ["0.3677"] | [] | ["XCBO"] | 130.0000 | 130.0000 | 819 | 854 | false | false | true | false | |||||||||
| 01a0b500-6638-79c2-b81f-3fd8d9379e2f | USO | 2026-09-18 10:51 | call_calendar | 2 | 1 | 10 | 106610.00 | short | ask | 156.0000 | 7.6000 | ["130"] | ["0.3675"] | [] | ["XCBO"] | 130.0000 | 130.0000 | 819 | 854 | false | false | true | false | |||||||||
| 01a0b4ff-f108-71d1-96d1-6989ab2b1e54 | USO | 2026-09-18 10:51 | call_calendar | 2 | 1 | 10 | 106490.00 | short | ask | 156.0700 | 8.7500 | ["131"] | ["0.3735"] | [] | ["XCBO"] | 131.0000 | 131.0000 | 819 | 854 | false | false | true | false | |||||||||
| 01a0b4f4-e8d0-73a2-aea8-6fec7547f839 | USO | 2026-09-18 10:39 | call_calendar | 2 | 1 | 20 | 236200.00 | short | ask | 157.0460 | 8.0000 | ["120"] | ["0.3555"] | [] | ["XMIO"] | 120.0000 | 120.0000 | 819 | 854 | false | false | true | false | |||||||||
| 01a0b4f4-a667-7411-b685-4045c3565df3 | USO | 2026-09-18 10:38 | call_calendar | 2 | 1 | 9 | 106524.00 | short | ask | 157.0500 | 7.5000 | ["120"] | ["0.3576"] | [] | ["XCBO"] | 120.0000 | 120.0000 | 819 | 854 | false | false | true | false | |||||||||
| 01a0b4f4-7788-7692-a6e7-366f5185c783 | USO | 2026-09-18 10:38 | call_calendar | 2 | 1 | 10 | 118200.00 | short | ask | 157.0500 | 8.2000 | ["120"] | ["0.3563"] | [] | ["XCBO"] | 120.0000 | 120.0000 | 819 | 854 | false | false | true | false | |||||||||
| 01a0b4f3-db48-75d0-8a75-c61ab016d71c | USO | 2026-09-18 10:37 | call_calendar | 2 | 1 | 41 | 485686.00 | short | ask | 157.1250 | 8.3000 | ["120"] | ["0.3574"] | [] | ["XCBO"] | 120.0000 | 120.0000 | 819 | 854 | 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 | |||||||||
| 01a0a5c1-2b16-7b10-a4ad-79dbae4f9107 | USO | 2026-09-15 11:48 | call_calendar | 2 | 1 | 16 | 100128.00 | unknown | — | 160.2890 | 1.2500 | ["130"] | ["1.4360"] | [] | ["XBOX"] | 130.0000 | 130.0000 | 1 | 31 | false | false | true | false | false | mlat | |||||||
| 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 | |||||||||
| 01a06dc6-a6fd-7232-ac68-f7ddc4eef1f9 | USO | 2026-09-04 14:55 | call_calendar | 2 | 1 | 27 | 230796.00 | short | ask | 142.3400 | 4.2500 | ["100"] | ["0.6652"] | [] | ["XCBO"] | 100.0000 | 100.0000 | 28 | 49 | false | false | true | false | |||||||||
| 01a06db1-84d5-7481-8538-801e3e94a154 | USO | 2026-09-04 14:32 | call_calendar | 2 | 1 | 12 | 124380.00 | short | bid | 142.1800 | 3.3500 | ["100"] | ["0.3309"] | [] | ["XCBO"] | 100.0000 | 100.0000 | 504 | 560 | false | false | true | false |
| 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 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:59:43Z"} |
| 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-18T14:54:27Z"} |
| 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-18T14:52:48Z"} |
| 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-18T14:52:29Z"} |
| 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-18T14:52:06Z"} |
| 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-18T14:51:42Z"} |
| 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-18T14:51:20Z"} |
| 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-18T14:39:05Z"} |
| 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-18T14:39:05Z"} |
| 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-18T14:38:37Z"} |
| 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-18T14:38:08Z"} |
| 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 |
| 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 |
| 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 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:55:39Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:32:51Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |