Simplify AnalyticsMulti-leg option trades
core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
403,968 rowsCSV — whole table, not this view
Sources in this table
uw_multileg403,968 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c57e-28d7-7972-b7a0-cae37875bbb6 | HD | 2026-09-21 15:42 | other | 4 | 1 | 50 | 196000.00 | unknown | — | 299.0350 | 4.4500 | ["295","300","315"] | ["0.2556","0.2652","0.2171"] | [] | ["XPHO"] | 295.0000 | 315.0000 | 4 | 11 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T19:43:07Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0ab46-f59b-7960-a498-5680bf230d10 | HD | 2026-09-16 13:32 | other | 4 | 2 | 48 | 208098.00 | unknown | — | 307.4700 | 4.9900 | ["300","325","327.5"] | ["0.3194","0.4399","0.2907"] | [] | ["XISX"] | 300.0000 | 327.5000 | 2 | 16 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T17:33:09Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a090fb-1248-77f1-88cc-68ad8811767e | HD | 2026-09-11 10:59 | other | 2 | 1 | 9 | 108045.00 | unknown | — | 308.7875 | 4.9000 | ["200","300"] | ["1.8670","1.4056"] | [] | ["XBOX"] | 200.0000 | 300.0000 | 0 | 7 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T14:59:49Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08c79-3791-7cd2-add3-ef0e9f14199d | HD | 2026-09-10 13:59 | other | 4 | 1 | 49 | 599270.00 | unknown | — | 305.5400 | 5.9000 | ["300","305","350","360"] | ["0.2993","0.2557","0.3694","0.3250"] | [] | ["XISX"] | 300.0000 | 360.0000 | 22 | 99 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:00:01Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08748-e4c8-7460-9e82-a969de8da024 | HD | 2026-09-09 13:48 | other | 2 | 1 | 120 | 124860.00 | unknown | — | 311.1200 | 0.5000 | ["350","360"] | ["0.2597","0.2674"] | [] | ["XPHO"] | 350.0000 | 360.0000 | 100 | 128 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T17:48:57Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a06df0-df95-75c0-93c5-b1670724327e | HD | 2026-09-04 15:41 | other | 4 | 2 | 8 | 134556.00 | unknown | — | 321.5550 | 10.5500 | ["390","395","420","425"] | ["0.6169","0.6518","0.8143","0.8462"] | [] | ["AMXO","EMLD"] | 390.0000 | 425.0000 | 14 | 14 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:41:37Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d92-f885-7892-9121-95bf4abfc7d3 | HD | 2026-09-04 13:59 | other | 4 | 1 | 49 | 313110.00 | unknown | — | 320.7700 | 3.6600 | ["305","315","350"] | ["0.2486","0.2281","0.3496"] | [] | ["XMIO"] | 305.0000 | 350.0000 | 7 | 28 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T17:59:23Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |