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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a06d46-5f25-74e1-92ea-d4f8f1548ef3 | VIX | 2026-09-04 12:35 | call_condor | 4 | 1 | 20 | 27060.00 | long | bid | 13.9900 | 0.3500 | ["14","14.5","20","25"] | ["1.7406","1.6512","1.3477","1.3386"] | ["20.91"] | ["XCBO"] | 14.0000 | 25.0000 | 103 | 103 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T16:35:27Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a086a0-3530-76a1-84dc-ed3af92e95cc | VIX | 2026-09-09 10:43 | call_condor | 4 | 1 | 30 | 36570.00 | unknown | — | 16.0500 | 0.3100 | ["13","14","22","24"] | ["1.9165","1.6705","1.3438","1.3905"] | [] | ["XCBO"] | 13.0000 | 24.0000 | 42 | 42 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:44:22Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a09169-7fd0-7262-9a6b-ad5e2a82b17a | VIX | 2026-09-11 13:00 | call_condor | 4 | 1 | 20 | 34840.00 | unknown | — | 15.7400 | 4.0600 | ["10","11","20","23"] | ["3.7276","3.2926","1.4674","1.5464"] | [] | ["XCBO"] | 10.0000 | 23.0000 | 26 | 26 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T17:00:26Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |