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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0abb5-ebdb-7c42-922c-dfc4f1ce6712 | APP | 2026-09-16 15:33 | other | 8 | 1 | 302 | 19274940.00 | unknown | — | 323.2000 | 75.7000 | ["400","410","460","470","500","640","700","1110"] | ["1.9995","2.2499","2.9885","3.1577","3.7938","4.6323","5.4240","1.2906"] | [] | ["XBOX"] | 400.0000 | 1110.0000 | 2 | 121 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:33:51Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a091e5-04e9-7b93-b29b-5adb32d386cc | APP | 2026-09-11 15:14 | other | 7 | 1 | 100 | 3347040.00 | unknown | — | 324.9850 | 48.2000 | ["410","450","460","470","500","610","700"] | ["0.6939","1.7581","1.9864","2.0705","2.3068","3.0225","3.4890"] | [] | ["XBOX"] | 410.0000 | 700.0000 | 7 | 7 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:15:20Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a0826e-a528-78e3-b1bf-e8931072f5bd | APP | 2026-09-08 15:11 | other | 8 | 1 | 110 | 4169680.00 | unknown | — | 311.9800 | 73.3000 | ["420","440","450","460","470","500","640","700"] | ["1.3748","1.4934","1.5638","1.7378","1.7091","1.8714","2.6143","2.8592"] | [] | ["XBOX"] | 420.0000 | 700.0000 | 10 | 10 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T19:11:45Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |