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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0aa7d-ae43-7081-9025-83fdbf343e8b | IWM | 2026-09-16 09:52 | call_ratio_spread | 2 | 1 | 10000 | 1490000.00 | unknown | — | 286.7000 | 0.0700 | ["305","335"] | ["0.1700","0.1654"] | [] | ["AMXO"] | 305.0000 | 335.0000 | 65 | 65 | false | true | false | true | false | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T13:52:46Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aa7a-7ddb-76a2-ac48-5ecd24d0b13f | IWM | 2026-09-16 09:49 | call_ratio_spread | 2 | 1 | 3000 | 1325000.00 | long | ask | 286.4550 | 0.0700 | ["290","300"] | ["0.1803","0.1605"] | ["292.82","314.37"] | ["XPHO"] | 290.0000 | 300.0000 | 30 | 30 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T13:49:16Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a591-c25e-7f80-9045-1882cc8443a5 | IWM | 2026-09-15 10:56 | call_ratio_spread | 2 | 1 | 51 | 91534.00 | unknown | — | 284.1450 | 0.4400 | ["295","300"] | ["0.1853","0.1813"] | [] | ["XMIO"] | 295.0000 | 300.0000 | 157 | 157 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:56:53Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a08b88-3070-7c93-9292-286b2347e6ae | IWM | 2026-09-10 09:35 | call_ratio_spread | 2 | 2 | 2500 | 577500.00 | unknown | — | 288.4600 | 0.0800 | ["291","294"] | ["0.1894","0.1843"] | [] | ["EDGO"] | 291.0000 | 294.0000 | 8 | 8 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T13:35:56Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a0829e-6f88-7850-a665-0aca90ea3858 | IWM | 2026-09-08 16:03 | call_ratio_spread | 2 | 2 | 2000 | 607000.00 | long | ask | 294.6700 | 0.1200 | ["294","300"] | ["0.1647","0.1557"] | ["295.35","304.65"] | ["AMXO"] | 294.0000 | 300.0000 | 10 | 10 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T20:05:18Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |