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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0a0b5-4d20-7862-9bb0-64938103ec2b | CRWD | 2026-09-14 12:17 | put_backspread | 2 | 1 | 200 | 38900.00 | unknown | — | 237.6900 | 0.2400 | ["217.5","220"] | ["0.7380","0.7297"] | [] | ["XMIO"] | 217.5000 | 220.0000 | 4 | 4 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T16:17:21Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a082-d340-7403-ab81-c6b01b9b525c | SNDK | 2026-09-14 11:22 | put_backspread | 2 | 2 | 2 | 25060.00 | unknown | — | 1527.7000 | 0.9000 | ["1540","1605"] | ["0.7616","0.7747"] | [] | ["XISX"] | 1540.0000 | 1605.0000 | 4 | 4 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T15:22:11Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a090b9-b7d0-7cc1-97e5-83fe3d0a53f8 | VIX | 2026-09-11 09:48 | put_backspread | 2 | 2 | 8000 | 130000.00 | unknown | — | 16.1100 | 0.0700 | ["15","15.5"] | ["0.5335","0.5014"] | [] | ["XCBO"] | 15.0000 | 15.5000 | 5 | 5 | false | true | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T13:48:13Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08146-c6f8-7410-83be-6adfc8c437f3 | MU | 2026-09-08 09:48 | put_backspread | 2 | 1 | 4 | 125868.00 | unknown | — | 1019.7499 | 9.9000 | ["900","1200"] | ["0.6538","0.6796"] | [] | ["XPHO"] | 900.0000 | 1200.0000 | 129 | 129 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T13:48:15Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |