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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b4d5-2017-7d91-a2c5-f7713db15865 | IWM | 2026-09-18 10:04 | strangle_swap | 4 | 1 | 30 | 53880.00 | unknown | ask | 282.9200 | 0.2500 | ["280","282","284","286"] | ["0.1865","0.1745","0.1669","0.1696"] | [] | ["AMXO"] | 280.0000 | 286.0000 | 21 | 35 | false | true | true | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:04:31Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0a576-c81d-7e13-b79f-7c8a721c2113 | IWM | 2026-09-15 10:26 | strangle_swap | 4 | 1 | 12 | 44352.00 | unknown | — | 285.2700 | 0.8900 | ["265","300"] | ["0.2354","0.1818"] | [] | ["EDGO"] | 265.0000 | 300.0000 | 94 | 275 | false | true | true | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:27:11Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a56f-f605-70d3-8f07-f2263a476993 | IWM | 2026-09-15 10:19 | strangle_swap | 4 | 1 | 19 | 53409.00 | unknown | — | 285.6400 | 0.7800 | ["265","305"] | ["0.2348","0.1760"] | [] | ["XCBO"] | 265.0000 | 305.0000 | 94 | 213 | false | true | true | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:19:32Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a18c-34c0-7a13-80e8-f28f9e8cf85f | IWM | 2026-09-14 16:11 | strangle_swap | 4 | 1 | 11 | 53966.00 | unknown | — | 287.8800 | 2.3300 | ["268","270","285","290"] | ["0.6238","0.2036","0.2022","0.2545"] | [] | ["MCRY"] | 268.0000 | 290.0000 | 4 | 32 | false | false | true | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a03c-8340-7b91-a473-6d6b39093d6d | IWM | 2026-09-14 10:05 | strangle_swap | 4 | 1 | 11 | 42977.00 | unknown | — | 288.6200 | 1.0800 | ["265","300"] | ["0.2396","0.1805"] | [] | ["XCBO"] | 265.0000 | 300.0000 | 95 | 276 | false | true | true | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T14:05:26Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a091dc-7198-7d80-8047-89a0160c6d5d | IWM | 2026-09-11 15:05 | strangle_swap | 4 | 1 | 26 | 25194.00 | unknown | — | 289.2150 | 0.2300 | ["288","290","292","295"] | ["0.1989","0.1869","0.1359","0.1450"] | [] | ["XCBO"] | 288.0000 | 295.0000 | 5 | 19 | false | false | true | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:05:49Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a091dc-3700-70a2-9518-1dbabff9a63a | IWM | 2026-09-11 15:05 | strangle_swap | 4 | 1 | 107 | 81320.00 | unknown | — | 289.2450 | 0.1900 | ["288","291"] | ["0.2047","0.1437"] | [] | ["XCBO"] | 288.0000 | 291.0000 | 5 | 7 | false | true | true | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:05:49Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |