Multi-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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b0a2-1d3b-76d0-b874-6cb9676568b5 | SPCX | 2026-09-17 14:30 | other | 5 | 1 | 487 | 6917180.00 | unknown | — | 154.8700 | 12.1500 | ["185","190","215","230","350"] | ["2.7000","2.6506","4.4988","5.5318","0.8760"] | [] | ["XBOX"] | 185.0000 | 350.0000 | 1 | 273 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:30:18Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0a2-05cb-71b1-b870-70ba5c385e32 | SPCX | 2026-09-17 14:30 | other | 7 | 1 | 1956 | 22366180.00 | unknown | — | 154.8700 | 15.7000 | ["180","190","195","210","230","250","350"] | ["1.9980","2.6506","2.7104","3.8970","5.5318","5.9201","0.8760"] | [] | ["XBOX"] | 180.0000 | 350.0000 | 1 | 273 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:30:18Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0a159-2670-7140-aca4-a0e4d3128960 | SPCX | 2026-09-14 15:16 | other | 4 | 2 | 12000 | 12612000.00 | unknown | — | 150.1075 | 0.1900 | ["150","160","175","180"] | ["0.5786","0.5000","0.7009","0.5180"] | [] | ["AMXO"] | 150.0000 | 180.0000 | 4 | 32 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T19:16:44Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a091ea-3cd8-7ce2-957c-9b2e6cb8bfeb | SPCX | 2026-09-11 15:20 | other | 3 | 1 | 882 | 12935580.00 | unknown | — | 150.2000 | 9.1500 | ["210","215","230"] | ["1.9419","2.0957","2.3231"] | [] | ["XBOX"] | 210.0000 | 230.0000 | 7 | 7 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:20:43Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08ca7-8320-74e0-80d9-b79e089737c1 | SPCX | 2026-09-10 14:49 | other | 6 | 1 | 693 | 10122220.00 | unknown | — | 148.6350 | 17.8500 | ["195","200","215","230","250","300"] | ["1.2190","3.4551","1.5421","1.7558","1.9942","2.6438"] | [] | ["XBOX"] | 195.0000 | 300.0000 | 1 | 8 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:50:22Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08ca7-3118-7400-9fd8-4a3e9ac89a7a | SPCX | 2026-09-10 14:49 | other | 4 | 1 | 15000 | 164020320.00 | unknown | — | 148.7000 | 11.7000 | ["200","205","210","230"] | ["1.2403","1.5616","1.5179","1.7792"] | [] | ["XBOX"] | 200.0000 | 230.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:49:33Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c90-8080-7103-bf48-e5b535cee16f | SPCX | 2026-09-10 14:24 | other | 3 | 1 | 1300 | 18583200.00 | unknown | — | 148.5501 | 9.8500 | ["210","215","230"] | ["1.4728","1.5493","1.6165"] | [] | ["XPHO"] | 210.0000 | 230.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:25:14Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a087a9-6bb9-72c3-a447-5186bfc3a4bf | SPCX | 2026-09-09 15:33 | other | 4 | 1 | 7750 | 30600000.00 | unknown | — | 146.7550 | 1.9100 | ["120","130"] | ["0.6051","0.5513"] | [] | ["XBOX"] | 120.0000 | 130.0000 | 37 | 37 | false | false | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T19:34:03Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08769-caa8-7763-b814-cc61d3d0f332 | SPCX | 2026-09-09 14:24 | other | 4 | 1 | 930 | 13942080.00 | unknown | — | 148.2301 | 15.1500 | ["200","210","215","230"] | ["3.8449","1.7343","1.8645","2.0713"] | [] | ["XBOX"] | 200.0000 | 230.0000 | 2 | 9 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T18:24:20Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0824a-8328-7732-ba01-997e5547875e | SPCX | 2026-09-08 14:31 | other | 3 | 1 | 650 | 8844200.00 | unknown | — | 153.6800 | 7.5000 | ["210","215","230"] | ["1.2613","1.0794","1.4253"] | [] | ["XPHO"] | 210.0000 | 230.0000 | 10 | 10 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T18:32:13Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |