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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0a67b-5b26-7692-b98e-d344780658a3 | TSM | 2026-09-15 15:11 | call_ladder | 6 | 1 | 10 | 1088880.00 | unknown | — | 414.7200 | 17.0000 | ["110","130","135","155","160","175"] | ["6.9789","6.1852","5.8305","5.0396","4.8861","4.6835"] | [] | ["XPHO"] | 110.0000 | 175.0000 | 3 | 3 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:12:14Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a678-cece-7740-91e5-09264ee21cb2 | TSM | 2026-09-15 15:08 | call_ladder | 8 | 1 | 80 | 13346880.00 | unknown | — | 414.6000 | 23.0000 | ["170","180","195","200","210","220","230","240"] | ["4.6637","4.5163","4.3239","3.9516","3.8140","3.5778","3.4370","3.1629"] | [] | ["XPHO"] | 170.0000 | 240.0000 | 3 | 3 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:08:58Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a678-693e-70b1-bb97-11472842b502 | TSM | 2026-09-15 15:08 | call_ladder | 8 | 1 | 60 | 10010160.00 | unknown | — | 414.4600 | 23.0000 | ["170","180","195","200","210","220","230","240"] | ["4.7921","4.6248","4.4078","4.0530","3.9009","3.6603","3.5087","3.2347"] | [] | ["XPHO"] | 170.0000 | 240.0000 | 3 | 3 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:08:58Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a677-6f3e-7781-991f-475f55128ee9 | TSM | 2026-09-15 15:07 | call_ladder | 8 | 1 | 60 | 10010160.00 | unknown | — | 414.5500 | 23.0000 | ["170","180","195","200","210","220","230","240"] | ["4.7113","4.5563","4.3546","3.9891","3.8459","3.6081","3.4632","3.1892"] | [] | ["XPHO"] | 170.0000 | 240.0000 | 3 | 3 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:07:26Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a676-dace-7453-b59f-15c68ac28801 | TSM | 2026-09-15 15:06 | call_ladder | 8 | 1 | 60 | 10010160.00 | unknown | — | 414.5000 | 23.0000 | ["170","180","195","200","210","220","230","240"] | ["4.7570","4.5949","4.3845","4.0251","3.8768","3.6374","3.4887","3.2148"] | [] | ["XPHO"] | 170.0000 | 240.0000 | 3 | 3 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:07:26Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |