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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c56a-df57-7932-8cd8-2af833490ff6 | SMH | 2026-09-21 15:21 | call_diagonal_spread | 2 | 1 | 7000 | 6034000.00 | unknown | bid | 596.8200 | 4.0900 | ["570","610"] | ["0.5256","0.3035"] | [] | ["AMXO"] | 570.0000 | 610.0000 | 2 | 3 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T19:22:22Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0a5b1-f0a5-7320-9dd1-c8163bfb7a6a | SMH | 2026-09-15 11:31 | call_diagonal_spread | 2 | 2 | 200 | 1618200.00 | unknown | — | 543.0900 | 2.0000 | ["575","600"] | ["0.3614","0.3394"] | [] | ["AMXO"] | 575.0000 | 600.0000 | 94 | 275 | false | true | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T15:31:59Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a08cbe-7a08-7d81-8410-cd40b0dae145 | SMH | 2026-09-10 15:14 | call_diagonal_spread | 2 | 2 | 21 | 62916.00 | long | bid | 561.2400 | 4.9500 | ["547.5","550"] | ["0.5467","0.3176"] | [] | ["AMXO"] | 547.5000 | 550.0000 | 1 | 4 | false | false | true | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:15:20Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |