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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0a5a4-5ffe-7303-951e-2310379d95b9 | SPX | 2026-09-15 11:16 | call_ladder | 3 | 3 | 300 | 2429220.00 | unknown | — | 7581.9400 | 0.6000 | ["7590","7600","7605"] | ["0.1856","0.1828","0.1809"] | [] | ["XCBO"] | 7590.0000 | 7605.0000 | 3 | 3 | false | true | false | true | false | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T15:17:21Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0abab-35aa-7a82-b225-5b2367207d6c | SPX | 2026-09-16 15:21 | call_ladder | 3 | 2 | 900 | 3455000.00 | unknown | — | 7516.2900 | 1.5500 | ["7450","7550","7625"] | ["0.2511","0.2127","0.1890"] | [] | ["XCBO"] | 7450.0000 | 7625.0000 | 1 | 1 | false | false | false | true | false | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:22:00Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0c525-23c6-72b2-945e-3db51d668fb7 | SPX | 2026-09-21 14:05 | call_ladder | 3 | 2 | 650 | 5455481.00 | unknown | bid | 7762.5500 | 2.3000 | ["7715","7720","7730"] | ["0.1181","0.1171","0.1150"] | ["7786.82"] | ["XCBO"] | 7715.0000 | 7730.0000 | 4 | 4 | false | false | false | true | false | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T18:06:02Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |