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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b552-81c0-7260-b38e-098e1581c4d3 | GLD | 2026-09-18 12:21 | strangle | 2 | 1 | 50 | 129250.00 | long | ask | 400.3700 | 0.5500 | ["400","430"] | ["0.2340","0.2378"] | ["374.15","455.85"] | ["AMXO"] | 400.0000 | 430.0000 | 91 | 91 | false | true | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:21:23Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b54c-ec0f-7192-8270-1bef0037cd64 | GLD | 2026-09-18 12:15 | strangle | 2 | 1 | 200 | 517000.00 | long | ask | 399.8100 | 0.4000 | ["400","430"] | ["0.2330","0.2380"] | ["374.15","455.85"] | ["AMXO"] | 400.0000 | 430.0000 | 91 | 91 | false | false | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:15:44Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0a050-5190-7342-ba69-d68982b04663 | GLD | 2026-09-14 10:26 | strangle | 2 | 1 | 200 | 390000.00 | short | bid | 391.1000 | 0.4100 | ["410","415"] | ["0.3086","0.3527"] | ["390.50","434.50"] | ["XPHO"] | 410.0000 | 415.0000 | 4 | 4 | false | false | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T14:27:15Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |