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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c4ac-bf77-7ed3-bd8f-ca65a2e1368e | SPX | 2026-09-21 11:54 | box_spread | 4 | 1 | 8 | 27240.00 | long | ask | 7738.3500 | 0.3500 | ["7725","7740"] | ["0.1186","0.1097"] | [] | ["XCBO"] | 7725.0000 | 7740.0000 | 0 | 0 | false | false | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T15:54:39Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b532-2497-7aa0-bfa9-b03e292f528f | SPX | 2026-09-18 11:45 | box_spread | 4 | 1 | 29 | 163705.00 | long | ask | 7622.1400 | 0.6500 | ["7645","7650"] | ["0.1327","0.1348"] | [] | ["XCBO"] | 7645.0000 | 7650.0000 | 0 | 0 | false | false | false | true | true | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:46:07Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0ab82-8b83-7f13-8b33-1114498b3b1e | SPX | 2026-09-16 14:37 | box_spread | 4 | 1 | 15 | 216840.00 | long | ask | 7576.1500 | 0.7967 | ["7575","7680"] | ["0.5316","0.4981"] | [] | ["XCBO"] | 7575.0000 | 7680.0000 | 0 | 0 | false | false | false | true | true | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T18:37:40Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a6ac-330e-7d72-b96b-67cb900a5e7e | SPX | 2026-09-15 16:04 | box_spread | 4 | 1 | 5 | 61950.00 | long | ask | 7585.7300 | 1.8000 | ["7575","7620"] | ["0.1972","0.1710"] | [] | ["XCBO"] | 7575.0000 | 7620.0000 | 1 | 1 | false | false | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T20:05:31Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a646-3d7e-7773-979a-f549dabc8861 | SPX | 2026-09-15 14:13 | box_spread | 4 | 1 | 10 | 75680.00 | long | ask | 7590.0800 | 0.4500 | ["7585","7655"] | ["0.1198","0.2457"] | [] | ["XCBO"] | 7585.0000 | 7655.0000 | 0 | 0 | false | false | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T18:13:37Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a087c4-0068-7181-b875-ae386f1586d6 | SPX | 2026-09-09 16:02 | box_spread | 4 | 3 | 12 | 226600.00 | long | ask | 7636.4900 | 5.5250 | ["7670","7735"] | ["0.1096","0.0973"] | [] | ["XCBO"] | 7670.0000 | 7735.0000 | 5 | 5 | false | false | false | true | true | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T20:04:35Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0828e-5e40-73f3-b4b1-ee86f4abd081 | SPX | 2026-09-08 15:46 | box_spread | 4 | 2 | 6 | 27750.00 | long | ask | 7680.4300 | 0.7500 | ["7640","7680"] | ["0.3767","0.1958"] | [] | ["XCBO"] | 7640.0000 | 7680.0000 | 0 | 0 | false | false | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T19:46:02Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |