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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b5e8-ce4f-72a2-a2f3-20b6aae99854 | BA | 2026-09-18 15:05 | other | 3 | 1 | 200 | 2208400.00 | unknown | bid | 198.6000 | 9.6500 | ["235","240","270"] | ["0.3231","0.5076","0.5273"] | [] | ["XPHO"] | 235.0000 | 270.0000 | 28 | 63 | true | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:05:50Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b0a3-e643-74d3-bc57-d712a83b1180 | BA | 2026-09-17 14:32 | other | 5 | 1 | 752 | 5924022.00 | unknown | — | 198.5550 | 15.2000 | ["212.5","215","220","225","280"] | ["0.8668","0.9800","1.1952","1.7558","0.6219"] | [] | ["XBOX"] | 212.5000 | 280.0000 | 1 | 120 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:32:30Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0a3-74fa-7f43-a6a5-bf6426c31be7 | BA | 2026-09-17 14:31 | other | 4 | 1 | 2967 | 18236310.00 | unknown | — | 198.7050 | 6.8500 | ["215","220","235","250"] | ["1.0432","1.3041","2.0480","2.7707"] | [] | ["XBOX"] | 215.0000 | 250.0000 | 1 | 1 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:31:45Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0a3-59a3-7400-89d6-dd33339ac363 | BA | 2026-09-17 14:31 | other | 4 | 1 | 4065 | 25181800.00 | unknown | — | 198.7100 | 15.9500 | ["215","230","245","270"] | ["1.0462","1.8430","0.6562","0.5235"] | [] | ["XBOX"] | 215.0000 | 270.0000 | 1 | 92 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:31:45Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a08cc8-2699-7482-b50b-be648dd23941 | BA | 2026-09-10 15:25 | other | 3 | 1 | 1320 | 9581280.00 | unknown | — | 204.8400 | 8.3500 | ["235","240","250"] | ["0.6613","0.6038","0.8629"] | [] | ["XPHO"] | 235.0000 | 250.0000 | 8 | 8 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:25:25Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08ca0-4f60-7fe0-896e-b8ab5ae1dc57 | BA | 2026-09-10 14:41 | other | 3 | 1 | 460 | 3447900.00 | unknown | — | 205.6000 | 10.8500 | ["220","235","270"] | ["1.0035","0.3328","0.5256"] | [] | ["XBOX"] | 220.0000 | 270.0000 | 1 | 71 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:42:12Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08ca0-3409-7aa2-9b22-2532b5b5013a | BA | 2026-09-10 14:41 | other | 6 | 1 | 1440 | 8453400.00 | unknown | — | 205.5997 | 18.0500 | ["217.5","232.5","235","240","250","300"] | ["1.1036","0.7327","0.7287","0.8263","0.9199","0.6774"] | [] | ["XBOX"] | 217.5000 | 300.0000 | 1 | 71 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:42:12Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c9e-fb88-7862-be6c-b6f0819f07fa | BA | 2026-09-10 14:40 | other | 3 | 1 | 1940 | 12551000.00 | unknown | — | 205.6400 | 11.7000 | ["235","240","250"] | ["0.7345","0.8323","0.9275"] | [] | ["XBOX"] | 235.0000 | 250.0000 | 8 | 8 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:41:19Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |