Multi-leg option trades
core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
312,778 rowsCSV — whole table, not this view
Sources in this table
uw_multileg312,778 rowsexportable
| idtext | tickertext | executed_at ↓timestamp with time zone | strategytext | leg_countinteger | txnsinteger | sizebigint | total_premiumnumeric | directiontext | 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b50b-5317-79c0-8f6f-4e46fea12347 | USO | 2026-09-18 11:03 | call_calendar | 2 | 1 | 85 | 997050.00 | short | ask | 155.8500 | 8.8000 | ["120"] | ["0.3654"] | [] | ["SPHR"] | 120.0000 | 120.0000 | 819 | 854 | false | false | true | false | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:03:49Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b507-4407-7360-becd-84410a52ecf9 | USO | 2026-09-18 10:59 | other | 4 | 3 | 20 | 408100.00 | unknown | ask | 155.9700 | 16.6500 | ["133","137"] | ["0.3693","0.3750"] | [] | ["AMXO"] | 133.0000 | 137.0000 | 819 | 854 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:59:10Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0aa6a-784b-72f0-b966-912437962884 | USO | 2026-09-16 09:31 | put_vertical_spread | 2 | 1 | 115 | 344425.00 | unknown | — | 159.1500 | 2.0500 | ["155","165"] | ["0.5554","0.5681"] | [] | ["AMXO"] | 155.0000 | 165.0000 | 65 | 65 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T13:31:46Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aa69-479b-7410-88f5-c3bb56c062ef | USO | 2026-09-16 09:30 | put_butterfly_spread | 3 | 1 | 400 | 1059800.00 | short | bid | 159.2800 | 6.3500 | ["152","161","170"] | ["0.5496","0.5675","0.5824"] | ["152.95","169.05"] | ["SPHR"] | 152.0000 | 170.0000 | 44 | 44 | true | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T13:30:23Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 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 | mlft | 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 |
| 01a091e0-1731-7933-a805-5acbb6701d7d | USO | 2026-09-11 15:09 | other | 3 | 1 | 100 | 108350.00 | unknown | — | 154.6750 | 1.3300 | ["70","90","110"] | ["0.5535","0.4980","0.4654"] | [] | ["SPHR"] | 70.0000 | 110.0000 | 497 | 497 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:09:46Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a0913a-4dc8-7f92-a9cf-a06ab930ff7d | USO | 2026-09-11 12:08 | call_vertical_spread | 2 | 1 | 527 | 886941.00 | unknown | — | 154.1650 | 1.2500 | ["250","260"] | ["0.4026","0.4063"] | [] | ["SPHR"] | 250.0000 | 260.0000 | 497 | 497 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T16:09:02Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a09102-8c58-7ab2-b50d-15deb3df02f0 | USO | 2026-09-11 11:07 | call_vertical_spread | 2 | 1 | 79 | 127190.00 | unknown | — | 153.7900 | 2.4000 | ["250","260"] | ["0.3976","0.4014"] | [] | ["SPHR"] | 250.0000 | 260.0000 | 497 | 497 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T15:08:00Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08cd7-45b0-73f1-b50d-4a20a9e81d13 | USO | 2026-09-10 15:41 | call_diagonal_spread | 2 | 1 | 4000 | 15660000.00 | unknown | — | 158.3314 | 1.6000 | ["134","151"] | ["0.8146","0.5339"] | [] | ["XPHO"] | 134.0000 | 151.0000 | 8 | 36 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:42:01Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c91-d458-7931-8591-5687e99046c7 | USO | 2026-09-10 14:25 | other | 3 | 1 | 15000 | 11575000.00 | unknown | — | 158.4153 | 2.5600 | ["70","100","130"] | ["0.5760","0.4972","0.4697"] | [] | ["SPHR"] | 70.0000 | 130.0000 | 280 | 280 | true | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:26:01Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c61-cf60-7983-b15e-27e81dac371b | USO | 2026-09-10 13:33 | other | 4 | 1 | 2000 | 2302000.00 | unknown | — | 157.2600 | 1.0100 | ["150","165","200"] | ["0.5441","0.5729","0.7746"] | [] | ["XPHO"] | 150.0000 | 200.0000 | 8 | 36 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T17:33:42Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08ba6-ff28-71c0-811b-87e69cfb7c37 | USO | 2026-09-10 10:09 | other | 4 | 1 | 3800 | 508380.00 | unknown | — | 153.9500 | 0.5100 | ["120","130","135","145"] | ["0.7269","0.5809","0.5103","0.4995"] | [] | ["SPHR"] | 120.0000 | 145.0000 | 8 | 15 | false | true | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T14:09:55Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08ba1-fa00-7291-805c-d4f5aa60ecb5 | USO | 2026-09-10 10:04 | call_vertical_spread | 2 | 1 | 50 | 130000.00 | short | bid | 153.7900 | 1.2000 | ["150","200"] | ["0.4592","0.5385"] | ["162.50"] | ["SPHR"] | 150.0000 | 200.0000 | 127 | 127 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T14:04:07Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a0872a-2d81-7252-b685-824f7e8ca351 | USO | 2026-09-09 13:14 | put_condor | 4 | 1 | 250 | 152500.00 | long | ask | 147.8750 | 0.4200 | ["127","135","140","148"] | ["0.5552","0.4650","0.4427","0.4543"] | ["129.68","145.32"] | ["SPHR"] | 127.0000 | 148.0000 | 9 | 9 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T17:15:06Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0871f-b5d0-7c10-9f13-e228dca529c0 | USO | 2026-09-09 13:03 | put_condor | 4 | 1 | 250 | 151750.00 | long | ask | 148.0300 | 0.5100 | ["127","135","140","148"] | ["0.5582","0.4687","0.4429","0.4623"] | ["129.71","145.29"] | ["SPHR"] | 127.0000 | 148.0000 | 9 | 9 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T17:03:21Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0868c-8df0-7360-b061-43636429f793 | USO | 2026-09-09 10:22 | call_backspread | 2 | 1 | 2000 | 397000.00 | long | bid | 149.1350 | 0.2300 | ["150","200"] | ["0.4445","0.8096"] | ["153.65","246.35"] | ["AMXO"] | 150.0000 | 200.0000 | 9 | 9 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:22:44Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0828c-6658-72a0-abd5-e7d28c044a73 | USO | 2026-09-08 15:43 | other | 2 | 1 | 4000 | 7544000.00 | unknown | — | 145.2850 | 1.5000 | ["134","151"] | ["0.5045","0.4600"] | [] | ["XPHO"] | 134.0000 | 151.0000 | 10 | 38 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T19:44:16Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08147-0190-7dc3-87fc-9ef26435fecb | USO | 2026-09-08 09:48 | put_vertical_spread | 2 | 1 | 140 | 235340.00 | unknown | — | 145.0200 | 0.9500 | ["130","135"] | ["0.4408","0.4454"] | [] | ["SPHR"] | 130.0000 | 135.0000 | 129 | 129 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T13:48:38Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |