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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0afb7-0d74-7090-9308-737db3a1cc59 | VRT | 2026-09-17 10:13 | put_vertical_spread | 2 | 1 | 30 | 115350.00 | unknown | — | 242.2250 | 6.2500 | ["257.5","265"] | ["0.7499","0.9743"] | [] | ["C2OX"] | 257.5000 | 265.0000 | 1 | 1 | false | false | false | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:13:28Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a08b92-0fc8-7de1-9a70-b7674b38830c | VRT | 2026-09-10 09:46 | other | 4 | 1 | 25 | 199375.00 | unknown | — | 249.8100 | 3.9000 | ["250","260","265","270"] | ["0.6149","0.6149","0.9491","0.9854"] | [] | ["XISX"] | 250.0000 | 270.0000 | 1 | 36 | false | false | true | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T13:46:51Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08212-5458-7011-b5e5-27e38bb2b642 | VRT | 2026-09-08 13:30 | call_diagonal_spread | 2 | 1 | 36 | 106380.00 | short | ask | 293.9050 | 1.8500 | ["295","300"] | ["0.6000","0.5672"] | [] | ["C2OX"] | 295.0000 | 300.0000 | 17 | 24 | false | true | true | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T17:30:59Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a081c5-2a70-7c30-a2e3-d1cbc909426a | VRT | 2026-09-08 12:06 | call_calendar | 2 | 1 | 5 | 162850.00 | short | bid | 294.8700 | 3.2000 | ["135"] | ["0.7444"] | [] | ["XISX"] | 135.0000 | 135.0000 | 73 | 192 | false | false | true | false | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T16:06:16Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a06daa-54fd-7332-bbad-217e72796c58 | VRT | 2026-09-04 14:24 | call_vertical_spread | 2 | 1 | 60 | 290700.00 | unknown | — | 276.8000 | 5.7000 | ["252.5","255"] | ["0.5157","0.5098"] | [] | ["XISX"] | 252.5000 | 255.0000 | 7 | 7 | true | false | false | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T18:25:02Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |