Simplify AnalyticsMulti-leg option trades
core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
367,592 rowsCSV — whole table, not this view
Sources in this table
uw_multileg367,592 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a08cb2-54a8-75a0-b0fe-ed123450f4db | CIFR | 2026-09-10 15:01 | other | 6 | 1 | 452 | 573608.00 | unknown | — | 15.9200 | 3.1500 | ["20","20.5","21","21.5","22","22.5"] | ["3.0814","4.0753","4.3341","4.5821","4.8000","5.0498"] | [] | ["XBOX"] | 20.0000 | 22.5000 | 1 | 1 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:01:41Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c93-fb20-7cf3-9be7-d2ab45134bb5 | CIFR | 2026-09-10 14:28 | other | 4 | 1 | 100 | 141800.00 | unknown | — | 16.0200 | 1.7300 | ["10","12","26","30"] | ["1.1233","0.7163","1.0008","1.0570"] | [] | ["SPHR"] | 10.0000 | 30.0000 | 99 | 127 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:28:24Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08260-4960-70b0-8a1e-da8bc6f26817 | CIFR | 2026-09-08 14:55 | other | 2 | 1 | 1994 | 327016.00 | unknown | — | 19.1750 | 0.4900 | ["25","34"] | ["1.0598","1.0719"] | [] | ["ARCO"] | 25.0000 | 34.0000 | 73 | 73 | false | true | false | true | false | mlft | 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 |
| 01a0814f-98c8-7c62-af99-e47e6d923567 | CIFR | 2026-09-08 09:57 | other | 2 | 1 | 5000 | 587500.00 | unknown | — | 18.1050 | 0.1300 | ["18","19"] | ["1.3697","1.3192"] | [] | ["SPHR"] | 18.0000 | 19.0000 | 3 | 3 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T13:58:09Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a06df6-bf7d-7ad0-8487-4df93bf57294 | CIFR | 2026-09-04 15:48 | other | 3 | 1 | 3750 | 1532500.00 | unknown | — | 17.7850 | 0.4300 | ["15","22","28"] | ["0.9668","1.0243","1.0430"] | [] | ["XBOX"] | 15.0000 | 28.0000 | 77 | 77 | false | true | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:48:12Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |