Simplify AnalyticsMulti-leg option trades
core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
312,778 rowsCSV — whole table, not this view
Sources in this table
uw_multileg312,778 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a08273-7b71-7d53-8beb-9de182bdb9d1 | TTD | 2026-09-08 15:16 | other | 7 | 1 | 1608 | 8802800.00 | unknown | — | 14.0050 | 10.8500 | ["19.5","27.5","45","47.5","57.5","60","95"] | ["2.1633","2.7847","1.7789","1.3133","2.0365","1.8982","2.4322"] | [] | ["XBOX"] | 19.5000 | 95.0000 | 3 | 129 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T19:17:21Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08273-8b10-7a82-971c-679542ba28d5 | TTD | 2026-09-08 15:16 | other | 3 | 1 | 846 | 3124500.00 | unknown | — | 14.0050 | 3.3000 | ["27.5","32.5","42.5"] | ["2.7847","4.0482","1.6575"] | [] | ["XBOX"] | 27.5000 | 42.5000 | 10 | 129 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T19:17:21Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08c9b-fa00-71a0-87dc-871c8bac28c0 | TTD | 2026-09-10 14:37 | other | 6 | 1 | 2110 | 4864300.00 | unknown | — | 13.8050 | 3.8500 | ["20","22.5","25","27.5","30","32.5"] | ["1.4946","2.2183","2.5616","3.0068","2.7014","5.1029"] | [] | ["XBOX"] | 20.0000 | 32.5000 | 8 | 8 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:37:39Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08ca3-0a98-78c2-8aaf-22950a970d39 | TTD | 2026-09-10 14:44 | other | 6 | 1 | 1330 | 6847450.00 | unknown | — | 13.8100 | 8.6500 | ["18","27.5","37.5","42.5","57.5","60"] | ["6.2807","4.0058","1.6571","1.6963","1.8541","1.7014"] | [] | ["XBOX"] | 18.0000 | 60.0000 | 1 | 127 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:45:20Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a091e4-39c8-7d20-837f-498d3d97a192 | TTD | 2026-09-11 15:14 | other | 4 | 1 | 660 | 1435600.00 | unknown | — | 14.3450 | 1.6000 | ["20","22.5","27.5","32.5"] | ["1.4076","2.6807","2.8681","4.0222"] | [] | ["XBOX"] | 20.0000 | 32.5000 | 7 | 7 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:14:20Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a091ea-d531-72b0-bf38-1960bfc3cf7c | TTD | 2026-09-11 15:21 | other | 5 | 1 | 934 | 3401104.00 | unknown | — | 14.3650 | 3.2500 | ["22.5","27.5","32.5","45","57.5"] | ["2.7163","3.6927","4.0666","1.5549","1.9202"] | [] | ["XBOX"] | 22.5000 | 57.5000 | 7 | 126 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:21:54Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a091ea-eca0-7be1-928c-bc9fbae8b7cc | TTD | 2026-09-11 15:21 | other | 4 | 1 | 965 | 4908660.00 | unknown | — | 14.3650 | 3.2500 | ["27.5","42.5","47.5","95"] | ["3.6955","1.3885","1.6402","2.4811"] | [] | ["XBOX"] | 27.5000 | 95.0000 | 7 | 126 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:21:54Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a091eb-07f8-7c20-8035-3adcd5211c7f | TTD | 2026-09-11 15:21 | other | 3 | 1 | 1896 | 6108840.00 | unknown | — | 14.3700 | 1.5500 | ["20","27.5","60"] | ["1.5043","3.3053","1.9674"] | [] | ["XBOX"] | 20.0000 | 60.0000 | 7 | 126 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:21:54Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a0b610-4f97-78e3-8f5b-8ea05903c0ad | TTD | 2026-09-18 15:48 | put_diagonal_spread | 2 | 1 | 320 | 864000.00 | long | ask | 14.0850 | 2.8000 | ["22.5","32.5"] | ["1.1092","1.0763"] | [] | ["XPHO"] | 22.5000 | 32.5000 | 28 | 119 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:48:37Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |