Simplify AnalyticsMulti-leg option trades
core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
403,968 rowsCSV — whole table, not this view
Sources in this table
uw_multileg403,968 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a091f5-e920-7bf3-9868-111c467f2d2a | SPY | 2026-09-11 15:33 | put_frontspread | 2 | 2 | 525 | 163602.00 | long | ask | 764.9900 | 0.0400 | ["710","746"] | ["0.2149","0.1583"] | ["675.81","744.32"] | ["XCBO"] | 710.0000 | 746.0000 | 21 | 21 | false | true | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:33:27Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a091f0-4ba0-7a31-bbd7-db36609d8038 | SPY | 2026-09-11 15:27 | put_frontspread | 2 | 1 | 525 | 161767.00 | long | ask | 765.1764 | 0.0400 | ["710","746"] | ["0.2150","0.1581"] | ["675.78","744.35"] | ["XCBO"] | 710.0000 | 746.0000 | 21 | 21 | false | true | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:27:33Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a091ea-38f0-76e3-bb49-10a0abf66cb3 | SPY | 2026-09-11 15:20 | put_frontspread | 2 | 2 | 525 | 163601.00 | long | ask | 764.9500 | 0.0300 | ["710","746"] | ["0.2144","0.1585"] | ["675.85","744.28"] | ["XCBO"] | 710.0000 | 746.0000 | 21 | 21 | false | true | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:20:43Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08222-dad0-77e1-8436-5b8bb028fc11 | SPY | 2026-09-08 13:48 | put_frontspread | 2 | 1 | 165 | 139953.00 | long | ask | 767.5400 | 0.0800 | ["710","760"] | ["0.1955","0.1525"] | ["694.23"] | ["XCBO"] | 710.0000 | 760.0000 | 73 | 73 | false | true | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T17:48:39Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |