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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c56d-831f-7b11-b824-df05ee9932b1 | RUT | 2026-09-21 15:24 | call_vertical_spread | 2 | 1 | 10 | 126400.00 | long | ask | 2881.8172 | 1.4000 | ["2820","2830"] | ["0.2029","0.1938"] | ["2829"] | ["XCBO"] | 2820.0000 | 2830.0000 | 4 | 4 | false | false | false | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T19:24:56Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b546-6817-7c10-a2c1-13729cc80fee | RUT | 2026-09-18 12:08 | call_vertical_spread | 2 | 1 | 10 | 34400.00 | short | bid | 2849.0876 | 1.6000 | ["2830","2835"] | ["0.2124","0.2058"] | ["2834.60"] | ["XCBO"] | 2830.0000 | 2835.0000 | 0 | 0 | false | false | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:08:19Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0abca-b42b-7b01-98d8-948af14fa594 | RUT | 2026-09-16 15:56 | call_vertical_spread | 2 | 1 | 10 | 147700.00 | short | bid | 2859.7133 | 1.5200 | ["2845","2850"] | ["0.1926","0.1914"] | ["2848.10"] | ["XCBO"] | 2845.0000 | 2850.0000 | 30 | 30 | false | false | false | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:56:30Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aa83-a59b-7fb2-b128-490955af79b2 | RUT | 2026-09-16 09:59 | call_vertical_spread | 2 | 1 | 50 | 27000.00 | short | bid | 2886.0865 | 0.4000 | ["3020","3025"] | ["0.1534","0.1539"] | ["3020.30"] | ["XCBO"] | 3020.0000 | 3025.0000 | 14 | 14 | false | true | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T13:59:35Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a08736-e750-7a31-9055-9422b827b40f | RUT | 2026-09-09 13:28 | call_vertical_spread | 2 | 1 | 20 | 42600.00 | unknown | — | 2925.5694 | 0.6000 | ["2980","2995"] | ["0.1725","0.1701"] | [] | ["C2OX"] | 2980.0000 | 2995.0000 | 9 | 9 | false | true | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T17:28:54Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08699-3050-72c3-91e6-f71fc548ae25 | RUT | 2026-09-09 10:36 | call_vertical_spread | 2 | 1 | 20 | 25000.00 | short | bid | 2937.8417 | 0.9000 | ["2935","2940"] | ["0.2075","0.2023"] | ["2937.70"] | ["C2OX"] | 2935.0000 | 2940.0000 | 0 | 0 | false | false | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:36:25Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |