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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0af8f-9fb4-7c83-8eb6-9b7683ad6e13 | SPX | 2026-09-17 09:30 | strangle_swap | 4 | 1 | 4 | 31440.00 | unknown | — | 7641.9900 | 1.0000 | ["7650","7710","7715"] | ["0.1336","0.0966","0.1525"] | [] | ["XCBO"] | 7650.0000 | 7715.0000 | 1 | 4 | false | false | true | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T13:30:12Z"} | 2026-09-17 | 2026-09-17 17:27 | 2026-09-17 17:27 |
| 01a0ab86-5ffa-76a1-8f89-a451f6ee37a8 | SPX | 2026-09-16 14:41 | strangle_swap | 4 | 1 | 6 | 54060.00 | unknown | — | 7598.3000 | 0.7000 | ["7585","7600","7620","7625"] | ["0.1858","0.4637","0.4551","0.1807"] | [] | ["XCBO"] | 7585.0000 | 7625.0000 | 0 | 2 | false | false | true | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T18:42:00Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab3d-9343-7c00-981b-1dbfa825136b | SPX | 2026-09-16 13:22 | strangle_swap | 4 | 1 | 12 | 135120.00 | unknown | — | 7609.5500 | 0.7000 | ["7580","7630"] | ["0.2132","0.2007"] | [] | ["XCBO"] | 7580.0000 | 7630.0000 | 1 | 2 | false | true | true | true | true | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T17:23:13Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab3d-77eb-7cd1-9c35-e47dc4634a03 | SPX | 2026-09-16 13:22 | strangle_swap | 4 | 1 | 4 | 45040.00 | unknown | — | 7609.7300 | 0.6000 | ["7580","7630"] | ["0.2130","0.2008"] | [] | ["XCBO"] | 7580.0000 | 7630.0000 | 1 | 2 | false | true | true | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T17:22:08Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a64e-4815-7593-9840-93abf18eaa93 | SPX | 2026-09-15 14:22 | strangle_swap | 4 | 1 | 11 | 170720.00 | unknown | — | 7586.6300 | 0.8000 | ["7605","7610"] | ["0.1813","0.1848"] | [] | ["XCBO"] | 7605.0000 | 7610.0000 | 1 | 3 | false | false | true | true | true | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T18:22:41Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0920d-b2f8-75a2-b581-1737436ee6b0 | SPX | 2026-09-11 15:59 | strangle_swap | 4 | 1 | 44 | 27060.00 | unknown | — | 7657.7200 | 0.4000 | ["7150","7460","7730","7800"] | ["0.2665","0.1417","0.0589","0.0925"] | [] | ["XCBO"] | 7150.0000 | 7800.0000 | 3 | 6 | false | true | true | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:59:31Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08c5f-4ec0-7e00-8afd-3d7500c90311 | SPX | 2026-09-10 13:30 | strangle_swap | 4 | 1 | 11 | 31130.00 | unknown | — | 7597.2600 | 0.4273 | ["7580","7690"] | ["0.1741","0.2387"] | [] | ["XCBO"] | 7580.0000 | 7690.0000 | 0 | 1 | false | true | true | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T17:30:53Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |