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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0a570-57ae-7ba2-8c84-798c1fa93f18 | XLK | 2026-09-15 10:19 | strangle | 2 | 8 | 44 | 75240.00 | unknown | — | 184.4600 | 0.4170 | ["180","210"] | ["0.2698","0.2417"] | [] | ["AMXO","ARCO","C2OX","EDGO","XCBO","XISX","XMIO","XPHO"] | 180.0000 | 210.0000 | 213 | 213 | false | true | false | true | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:20:05Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a56b-23a6-7311-a199-543a8a9af09c | XLK | 2026-09-15 10:14 | strangle | 2 | 3 | 34 | 58140.00 | long | ask | 184.3701 | 0.3500 | ["180","210"] | ["0.2710","0.2403"] | ["162.90","227.10"] | ["XCBO","XISX","XPHO"] | 180.0000 | 210.0000 | 213 | 213 | false | true | false | true | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:14:28Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a54b-1886-7af2-9bd8-5f4a4cd3897b | XLK | 2026-09-15 09:39 | strangle | 2 | 8 | 27 | 46440.00 | long | ask | 184.8800 | 0.9000 | ["180","210"] | ["0.2734","0.2402"] | ["162.80","227.20"] | ["AMXO","ARCO","C2OX","EDGO","XCBO","XISX","XMIO","XPHO"] | 180.0000 | 210.0000 | 213 | 213 | false | true | false | true | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T13:39:36Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a086c3-a768-7b70-9baa-b347bcd3106a | XLK | 2026-09-09 11:22 | strangle | 2 | 1 | 11 | 28644.00 | short | bid | 187.5350 | 2.1000 | ["167.5","220"] | ["0.2957","0.2685"] | ["141.46","246.04"] | ["ARCO"] | 167.5000 | 220.0000 | 464 | 464 | false | true | false | true | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T15:22:56Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a086c1-bb38-7f90-b368-348eef04256c | XLK | 2026-09-09 11:20 | strangle | 2 | 1 | 11 | 28655.00 | unknown | — | 187.7900 | 2.4000 | ["167.5","220"] | ["0.2956","0.2682"] | [] | ["ARCO"] | 167.5000 | 220.0000 | 464 | 464 | false | true | false | true | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T15:21:12Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |