Multi-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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
| 01a0b0a8-9962-7a81-9042-24a81fb0feef | BA | 2026-09-17 14:37 | put_vertical_spread | 2 | 1 | 1040 | 7862400.00 | unknown | — | 198.5050 | 4.5000 | ["235","240"] | ["2.0907","2.7531"] | [] | ["XBOX"] | 235.0000 | 240.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:37:26Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0a3-f9cb-73a0-a33a-89af01eb4cb4 | BA | 2026-09-17 14:32 | put_vertical_spread | 2 | 1 | 304 | 1182560.00 | unknown | — | 198.5500 | 3.5500 | ["217.5","220"] | ["1.6201","1.1911"] | [] | ["XBOX"] | 217.5000 | 220.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:32:30Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 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 |
| 01a0abb4-2e8b-7db2-9f99-0ac032f054d1 | BA | 2026-09-16 15:31 | put_butterfly_spread | 3 | 1 | 400 | 3487000.00 | unknown | — | 197.9400 | 14.4000 | ["235","240","250"] | ["1.9184","2.1618","2.4177"] | [] | ["XPHO"] | 235.0000 | 250.0000 | 2 | 2 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:31:46Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aba7-22b3-78d3-b658-b0fc346340ed | BA | 2026-09-16 15:17 | put_vertical_spread | 2 | 1 | 300 | 2928000.00 | unknown | — | 198.1300 | 9.7000 | ["240","250"] | ["2.1666","2.4763"] | [] | ["XBOX"] | 240.0000 | 250.0000 | 2 | 2 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:17:35Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a68a-4f46-7911-8a3a-1bbd5cfa3df9 | BA | 2026-09-15 15:27 | put_vertical_spread | 2 | 1 | 250 | 1715500.00 | unknown | — | 209.2600 | 8.4500 | ["240","250"] | ["1.0015","1.2461"] | [] | ["XPHO"] | 240.0000 | 250.0000 | 3 | 3 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:28:35Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 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 |