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 |
|---|
| 01a0ca28-4c0f-7f91-ade0-29378297eb16 | USO | 2026-09-22 13:27 | put_calendar | 2 | 1 | 50 | 153750.00 | long | ask | 146.7600 | 6.4500 | ["125"] | ["0.4323"] | [] | ["XPHO"] | 125.0000 | 125.0000 | 542 | 633 | false | true | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T17:27:16Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0c9cc-a71e-7270-bb1b-e45aa316afbb | USO | 2026-09-22 11:47 | put_calendar | 2 | 1 | 50 | 149800.00 | long | bid | 147.5001 | 7.2000 | ["125"] | ["0.4286"] | [] | ["SPHR"] | 125.0000 | 125.0000 | 542 | 633 | false | true | true | false | false | ||||||||
| 01a0c9cb-dbff-7ea1-ab63-42fc906bc8c5 | USO | 2026-09-22 11:46 | put_calendar | 2 | 1 | 50 | 154250.00 | long | bid | 147.4599 | 3.5500 | ["125"] | ["0.4361"] | [] | ["XISX"] | 125.0000 | 125.0000 | 542 | 633 | false | true | true | false | false | ||||||||
| 01a0c9cb-207f-7f40-9c2e-df1c4c583d12 | USO | 2026-09-22 11:45 | put_calendar | 2 | 1 | 50 | 149900.00 | long | bid | 147.3900 | 7.2500 | ["125"] | ["0.4283"] | [] | ["SPHR"] | 125.0000 | 125.0000 | 542 | 633 | false | true | true | false | false | ||||||||
| 01a0c9c7-82b7-77a1-913c-970a64e543e1 | USO | 2026-09-22 11:41 | put_calendar | 2 | 1 | 50 | 149200.00 | long | ask | 147.4500 | 6.8000 | ["125"] | ["0.4273"] | [] | ["XMIO"] | 125.0000 | 125.0000 | 542 | 633 | false | true | true | false | false | ||||||||
| 01a0c9c5-d8ef-7f32-9b9c-edbd51a2fa22 | USO | 2026-09-22 11:39 | put_calendar | 2 | 1 | 50 | 152900.00 | long | ask | 147.3200 | 7.8500 | ["125"] | ["0.4332"] | [] | ["SPHR"] | 125.0000 | 125.0000 | 542 | 633 | false | true | true | false | false | ||||||||
| 01a0c9c5-159f-7422-bd80-6ccd2756071a | USO | 2026-09-22 11:38 | put_calendar | 2 | 1 | 50 | 153100.00 | long | ask | 147.1300 | 7.7500 | ["125"] | ["0.4327"] | [] | ["XMIO"] | 125.0000 | 125.0000 | 542 | 633 | false | true | true | false | false | ||||||||
| 01a0c98f-1567-7d33-a568-a4b3d2bf688f | USO | 2026-09-22 10:39 | put_calendar | 2 | 1 | 150 | 112650.00 | short | ask | 146.4300 | 8.7900 | ["65"] | ["0.5069"] | [] | ["XMIO"] | 65.0000 | 65.0000 | 815 | 850 | false | true | true | false | false | ||||||||
| 01a0c962-2d4f-72f0-9008-d7b292a8c640 | USO | 2026-09-22 09:50 | put_calendar | 2 | 1 | 50 | 159000.00 | long | bid | 145.9400 | 5.2000 | ["125"] | ["0.4380"] | [] | ["SPHR"] | 125.0000 | 125.0000 | 542 | 633 | false | true | true | false | false | ||||||||
| 01a0c94f-4d4a-7df2-a868-f2b45a64a94b | USO | 2026-09-22 09:30 | put_calendar | 2 | 1 | 28 | 156940.00 | long | ask | 145.3300 | 9.5500 | ["150"] | ["0.4389"] | [] | ["MCRY"] | 150.0000 | 150.0000 | 542 | 633 | false | false | true | false | false | ||||||||
| 01a0c94f-457c-7302-896a-7f03c71ed7c4 | USO | 2026-09-22 09:30 | put_calendar | 2 | 1 | 32 | 166688.00 | unknown | ask | 145.3300 | 11.9500 | ["140"] | ["0.4873"] | [] | ["XBOX"] | 140.0000 | 140.0000 | 542 | 633 | false | true | true | false | |||||||||
| 01a0c94f-457c-7302-896a-7ef83ea2e574 | USO | 2026-09-22 09:30 | put_calendar | 2 | 2 | 56 | 259112.00 | long | ask | 145.3300 | 11.7750 | ["140"] | ["0.4426"] | [] | ["MCRY","XPHO"] | 140.0000 | 140.0000 | 542 | 633 | false | true | true | false | false | ||||||||
| 01a0c54a-9d86-73f2-a290-c9127c9e572d | USO | 2026-09-21 14:46 | put_calendar | 2 | 1 | 38 | 106286.00 | long | ask | 148.6750 | 3.3500 | ["120"] | ["0.4500"] | [] | ["BATO"] | 120.0000 | 120.0000 | 543 | 634 | false | true | true | false | false | ||||||||
| 01a0c515-d1e7-7613-93c5-ce5e1eaa296b | USO | 2026-09-21 13:48 | put_calendar | 2 | 1 | 32 | 172640.00 | unknown | — | 148.3100 | 2.2000 | ["150"] | ["0.4385"] | [] | ["XISX"] | 150.0000 | 150.0000 | 543 | 634 | false | false | true | false | false | mlet | |||||||
| 01a0c514-187f-7842-a195-b14cab10ba54 | USO | 2026-09-21 13:47 | put_calendar | 2 | 1 | 32 | 174816.00 | long | bid | 148.1200 | 3.5500 | ["150"] | ["0.4425"] | [] | ["SPHR"] | 150.0000 | 150.0000 | 543 | 634 | false | false | true | false | false | ||||||||
| 01a0c50d-debf-7aa3-9e40-d893981a9e7e | USO | 2026-09-21 13:40 | put_calendar | 2 | 2 | 60 | 266336.00 | long | ask | 147.9900 | 2.1800 | ["140"] | ["0.4405"] | [] | ["SPHR","XPHO"] | 140.0000 | 140.0000 | 543 | 634 | false | true | true | false | false | ||||||||
| 01a0c50c-775e-78b3-a5c2-187f02ef3b67 | USO | 2026-09-21 13:38 | put_calendar | 2 | 1 | 50 | 160400.00 | long | ask | 148.0400 | 2.7500 | ["125"] | ["0.4489"] | [] | ["SPHR"] | 125.0000 | 125.0000 | 543 | 634 | false | true | true | false | false | ||||||||
| 01a0c50c-15b7-7313-81f6-6d323b36683c | USO | 2026-09-21 13:38 | put_calendar | 2 | 1 | 50 | 185000.00 | unknown | ask | 148.0200 | 1.9500 | ["130"] | ["0.4546"] | [] | ["XBOX"] | 130.0000 | 130.0000 | 543 | 634 | false | true | true | false | false | ||||||||
| 01a0c50b-eea6-7313-9f8c-495d452417fe | USO | 2026-09-21 13:38 | put_calendar | 2 | 1 | 50 | 181200.00 | long | ask | 148.0400 | 2.3000 | ["130"] | ["0.4483"] | [] | ["XISX"] | 130.0000 | 130.0000 | 543 | 634 | false | true | true | false | false | ||||||||
| 01a0c50b-564e-7341-9c2d-7cf28468011a | USO | 2026-09-21 13:37 | put_calendar | 2 | 1 | 50 | 183500.00 | long | bid | 148.0100 | 2.8500 | ["130"] | ["0.4521"] | [] | ["XBOX"] | 130.0000 | 130.0000 | 543 | 634 | false | true | true | false | false | ||||||||
| 01a0c50b-0c17-71e1-89d2-b7fb6af342e3 | USO | 2026-09-21 13:37 | put_calendar | 2 | 3 | 60 | 241240.00 | long | ask | 148.0100 | 2.8333 | ["135"] | ["0.4445"] | [] | ["C2OX","MCRY","XBOX"] | 135.0000 | 135.0000 | 543 | 634 | false | true | true | false | |||||||||
| 01a0c50a-d17f-78c3-8b53-dcb2e61b7526 | USO | 2026-09-21 13:36 | put_calendar | 2 | 3 | 56 | 157448.00 | long | ask | 148.0199 | 0.6786 | ["120"] | ["0.4488"] | [] | ["ARCO","XPHO"] | 120.0000 | 120.0000 | 543 | 634 | false | true | true | false | false | ||||||||
| 01a0c50a-6bef-78a1-98bc-675cc7a00326 | USO | 2026-09-21 13:36 | put_calendar | 2 | 4 | 80 | 287960.00 | long | ask | 148.0400 | 3.4625 | ["130"] | ["0.4465"] | [] | ["C2OX","MCRY","XBOX","XMIO"] | 130.0000 | 130.0000 | 543 | 634 | false | true | true | false | |||||||||
| 01a0c50a-6807-7161-8b92-81dda7e3e1e7 | USO | 2026-09-21 13:36 | put_calendar | 2 | 1 | 50 | 161750.00 | long | ask | 148.0400 | 2.4500 | ["125"] | ["0.4511"] | [] | ["XISX"] | 125.0000 | 125.0000 | 543 | 634 | false | true | true | false | false | ||||||||
| 01a0c509-d77f-7ea2-9d8b-aa4a86b8fa15 | USO | 2026-09-21 13:35 | put_calendar | 2 | 4 | 80 | 261600.00 | long | bid | 148.0500 | 3.5000 | ["125"] | ["0.4544"] | [] | ["AMXO","EMLD","MCRY","XBOX"] | 125.0000 | 125.0000 | 543 | 634 | false | true | true | false | |||||||||
| 01a0c509-c7df-7343-a9ce-0c129954b156 | USO | 2026-09-21 13:35 | put_calendar | 2 | 1 | 50 | 141700.00 | long | ask | 148.0500 | 2.6000 | ["120"] | ["0.4509"] | [] | ["XPHO"] | 120.0000 | 120.0000 | 543 | 634 | false | true | true | false | false | ||||||||
| 01a0c509-9ce7-7060-ad72-f988e24804ae | USO | 2026-09-21 13:35 | put_calendar | 2 | 1 | 40 | 125720.00 | long | ask | 148.0400 | 5.3500 | ["125"] | ["0.4434"] | [] | ["XMIO"] | 125.0000 | 125.0000 | 543 | 634 | false | true | true | false | false | ||||||||
| 01a0c509-0c5f-7261-a68d-d03cb0cea7bc | USO | 2026-09-21 13:34 | put_calendar | 2 | 1 | 50 | 163000.00 | long | ask | 148.0000 | 5.4500 | ["125"] | ["0.4532"] | [] | ["XISX"] | 125.0000 | 125.0000 | 543 | 634 | false | true | true | false | false | ||||||||
| 01a0c508-f107-7db2-b271-72a81a17665c | USO | 2026-09-21 13:34 | put_calendar | 2 | 1 | 50 | 136500.00 | long | ask | 148.0300 | 4.3000 | ["120"] | ["0.4413"] | [] | ["SPHR"] | 120.0000 | 120.0000 | 543 | 634 | false | true | true | false | false | ||||||||
| 01a0a063-f8d0-7332-9a36-8986555ce9c8 | USO | 2026-09-14 10:48 | put_calendar | 2 | 1 | 300 | 110700.00 | short | ask | 159.2900 | 0.1000 | ["150"] | ["0.6107"] | [] | ["XISX"] | 150.0000 | 150.0000 | 4 | 11 | false | true | true | false | false | ||||||||
| 01a0a032-e650-79e1-9d64-5936671de217 | USO | 2026-09-14 09:54 | put_calendar | 2 | 1 | 200 | 117400.00 | long | ask | 159.7250 | 0.8500 | ["155"] | ["0.6461"] | [] | ["SPHR"] | 155.0000 | 155.0000 | 2 | 11 | false | true | true | false | false |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T15:47:30Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T15:46:47Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T15:46:02Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T15:41:40Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T15:39:50Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T15:39:11Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:40:13Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T13:50:49Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| 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-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-22T13:30:06Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T18:46:59Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T17:49:01Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T17:47:08Z"} |
| 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:40:42Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T17:39:25Z"} |
| 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:38:41Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T17:38:41Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T17:37:33Z"} |
| 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:37:33Z"} |
| 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:37:02Z"} |
| 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:37:02Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T17:37:02Z"} |
| 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:35:51Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T17:35:51Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T17:35:51Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T17:35:17Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T17:35:17Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T14:48:28Z"} |
| 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-14T13:54:48Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |