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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b506-9ff8-7a73-a851-d58f94e3cd34 | GLW | 2026-09-18 10:58 | put_calendar | 2 | 1 | 20 | 185200.00 | unknown | — | 150.5700 | 5.6000 | ["180"] | ["0.6406"] | [] | ["ARCO"] | 180.0000 | 180.0000 | 91 | 455 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:58:40Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0a599-c90e-7de3-8979-839334483533 | GLW | 2026-09-15 11:05 | put_calendar | 2 | 1 | 50 | 362300.00 | unknown | — | 144.3150 | 3.0000 | ["180"] | ["0.8664"] | [] | ["XMIO"] | 180.0000 | 180.0000 | 3 | 31 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T15:05:20Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a08c3f-14c1-7583-b879-893b2d692f03 | GLW | 2026-09-10 12:55 | put_calendar | 2 | 3 | 102 | 390072.00 | unknown | — | 164.6520 | 1.3721 | ["180"] | ["0.6110"] | [] | ["AMXO","ARCO","EDGO"] | 180.0000 | 180.0000 | 8 | 36 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T16:56:07Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |