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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c54a-f376-79b1-8cc1-2627904d9990 | MU | 2026-09-21 14:46 | strangle | 2 | 2 | 2 | 25650.00 | unknown | ask | 1044.0465 | 1.9000 | ["1040","1050"] | ["0.6714","0.6624"] | ["1045.82"] | ["XCBO"] | 1040.0000 | 1050.0000 | 18 | 18 | false | false | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T18:46:59Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b04f-bf4c-7953-a971-ce074bd1a850 | MU | 2026-09-17 13:00 | strangle | 2 | 3 | 2 | 25960.00 | long | ask | 975.4550 | 1.1250 | ["880","1250"] | ["0.5751","0.6000"] | ["750.20","1379.80"] | ["AMXO","XCBO"] | 880.0000 | 1250.0000 | 120 | 120 | false | true | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T17:00:22Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0875e-1691-7ec3-829b-9efa9fae4d7b | MU | 2026-09-09 14:11 | strangle | 2 | 2 | 18 | 30510.00 | short | bid | 1024.7750 | 0.2278 | ["900","1100"] | ["0.6190","0.5962"] | ["883.05","1116.95"] | ["XISX"] | 900.0000 | 1100.0000 | 9 | 9 | false | true | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T18:11:58Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08758-9850-7482-abfc-878c2a6aee31 | MU | 2026-09-09 14:05 | strangle | 2 | 1 | 15 | 25425.00 | short | bid | 1024.6160 | 0.1000 | ["900","1100"] | ["0.6205","0.5960"] | ["883.05","1116.95"] | ["XISX"] | 900.0000 | 1100.0000 | 9 | 9 | false | true | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T18:05:36Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a081fa-7ae0-7f43-91bd-3adee5b9c9d3 | MU | 2026-09-08 13:04 | strangle | 2 | 1 | 3 | 32700.00 | short | bid | 1019.0000 | 1.0000 | ["940","1100"] | ["0.6716","0.6847"] | ["831","1209.00"] | ["XCBO"] | 940.0000 | 1100.0000 | 38 | 38 | false | true | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T17:05:00Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a0819e-1688-7d43-ab4e-4d52b90df9c2 | MU | 2026-09-08 11:23 | strangle | 2 | 1 | 2 | 89300.00 | long | ask | 1022.2250 | 3.9500 | ["1140","1350"] | ["0.6783","0.6834"] | ["693.50","1796.50"] | ["XCBO"] | 1140.0000 | 1350.0000 | 282 | 282 | false | false | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T15:24:03Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a0819a-8c49-7dd2-8a32-0849bbd9aa87 | MU | 2026-09-08 11:19 | strangle | 2 | 1 | 45 | 36450.00 | long | ask | 1026.0550 | 0.4300 | ["650","1600"] | ["0.7694","0.7915"] | ["641.90","1608.10"] | ["XISX"] | 650.0000 | 1600.0000 | 38 | 38 | false | true | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T15:20:08Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |