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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0a119-db50-7da2-b61c-51e7931c8d2a | MU | 2026-09-14 14:06 | time_butterfly | 3 | 1 | 8 | 54040.00 | unknown | — | 930.4100 | 5.2700 | ["830","860","940"] | ["0.6742","0.5931","0.5951"] | [] | ["XCBO"] | 830.0000 | 940.0000 | 4 | 32 | false | false | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T18:07:14Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a09205-0838-7900-9c43-588a2381ec1e | AMZN | 2026-09-11 15:49 | time_butterfly | 3 | 1 | 34 | 37264.00 | unknown | — | 257.3150 | 0.2500 | ["260","280","300"] | ["0.3675","0.2957","0.3059"] | [] | ["XCBO"] | 260.0000 | 300.0000 | 35 | 70 | false | true | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:50:00Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a09205-0450-7040-a45f-2ba75e7d3f19 | AMZN | 2026-09-11 15:49 | time_butterfly | 3 | 1 | 116 | 127136.00 | unknown | — | 257.3500 | 0.3000 | ["260","280","300"] | ["0.3671","0.2954","0.3057"] | [] | ["XCBO"] | 260.0000 | 300.0000 | 35 | 70 | false | true | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:50:00Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a091a6-3ab1-7701-8ae1-1b23f8ffcdc8 | SPX | 2026-09-11 14:06 | time_butterfly | 3 | 1 | 2 | 84476.00 | unknown | — | 7671.1400 | 3.3000 | ["7850","8550","9200"] | ["0.1515","0.1376","0.1226"] | [] | ["XCBO"] | 7850.0000 | 9200.0000 | 252 | 343 | false | true | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T18:06:38Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a091a5-63d8-7f10-9d99-5de6733b9788 | SPX | 2026-09-11 14:05 | time_butterfly | 3 | 1 | 2 | 71781.00 | unknown | — | 7671.2800 | 2.3000 | ["7725","8475","9200"] | ["0.1489","0.1329","0.1189"] | [] | ["XCBO"] | 7725.0000 | 9200.0000 | 189 | 279 | false | true | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T18:05:59Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08c85-87e8-7241-927f-41b0fb1d55fe | SPX | 2026-09-10 14:12 | time_butterfly | 3 | 1 | 20 | 176750.00 | unknown | — | 7589.1800 | 1.0000 | ["7510","7515","7520"] | ["0.1590","0.1641","0.1572"] | [] | ["XCBO"] | 7510.0000 | 7520.0000 | 6 | 14 | false | true | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:12:39Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08178-2f69-7cf3-9320-d2f06916e59b | SPY | 2026-09-08 10:42 | time_butterfly | 3 | 1 | 110 | 99935.00 | unknown | — | 767.1300 | 0.0900 | ["766","771","776"] | ["0.1254","0.1368","0.2425"] | [] | ["XCBO"] | 766.0000 | 776.0000 | 0 | 1 | false | false | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T14:42:14Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |