Simplify AnalyticsMulti-leg option trades
core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
312,778 rowsCSV — whole table, not this view
Sources in this table
uw_multileg312,778 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b056-79f3-7813-a350-450993dfca3d | ARM | 2026-09-17 13:07 | put_butterfly_spread | 3 | 1 | 272 | 234872.00 | short | bid | 265.8800 | 3.3800 | ["245","247.5","255"] | ["0.7019","0.7070","0.7138"] | ["253.25"] | ["XISX"] | 245.0000 | 255.0000 | 8 | 8 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T17:07:36Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0abb2-7cf3-79b1-9183-df59383c32b2 | ARM | 2026-09-16 15:29 | put_butterfly_spread | 3 | 1 | 76 | 2341070.00 | unknown | — | 242.1250 | 8.4000 | ["390","400","410"] | ["4.0625","4.2222","4.3765"] | [] | ["XBOX"] | 390.0000 | 410.0000 | 2 | 2 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:29:57Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aba9-4d63-76a3-bdf7-d7d17725b80e | ARM | 2026-09-16 15:19 | put_butterfly_spread | 3 | 1 | 60 | 1859600.00 | unknown | — | 240.5500 | 9.6000 | ["390","400","410"] | ["3.6356","3.7551","3.8676"] | [] | ["XBOX"] | 390.0000 | 410.0000 | 2 | 2 | true | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:20:02Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |