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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a087be-d430-7b32-8db9-b3add894e3b8 | SPCX | 2026-09-09 15:57 | risk_reversal | 2 | 1 | 200 | 323600.00 | short | bid | 147.9700 | 0.5500 | ["125","185"] | ["0.5570","0.5415"] | ["125","185"] | ["SPHR"] | 125.0000 | 185.0000 | 128 | 128 | false | true | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T19:57:24Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a087ba-ffb8-71e2-8ba2-9823e54bdaea | SPCX | 2026-09-09 15:52 | call_calendar | 2 | 1 | 60 | 71160.00 | short | bid | 147.5226 | 0.2000 | ["144"] | ["0.5858"] | [] | ["SPHR"] | 144.0000 | 144.0000 | 2 | 9 | false | false | true | false | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T19:53:09Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 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 |
| 01a08719-aaf0-78d2-89b8-f976837b196f | SPCX | 2026-09-09 12:56 | strangle | 2 | 1 | 600 | 2064000.00 | long | ask | 146.2550 | 1.4000 | ["115","200"] | ["0.5783","0.5648"] | ["80.60","234.40"] | ["SPHR"] | 115.0000 | 200.0000 | 373 | 373 | false | true | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T16:57:07Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08669-df08-7633-b1ef-5d5e820fb1df | SPCX | 2026-09-09 09:44 | put_vertical_spread | 2 | 1 | 900 | 10191600.00 | long | ask | 152.1300 | 3.1000 | ["110","245"] | ["0.5839","0.6311"] | ["156"] | ["XPHO"] | 110.0000 | 245.0000 | 373 | 373 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T13:44:41Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08275-b5c0-7603-a56c-0a2e809315ae | SPCX | 2026-09-08 15:19 | put_diagonal_spread | 2 | 1 | 34 | 477020.00 | unknown | — | 154.3950 | 6.1000 | ["200","250"] | ["2.2552","2.2415"] | [] | ["XBOX"] | 200.0000 | 250.0000 | 3 | 10 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T19:19:15Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 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 |
| 01a081f3-b480-78e2-a347-b573b02a1a88 | SPCX | 2026-09-08 12:57 | call_vertical_spread | 2 | 1 | 250 | 1337000.00 | unknown | — | 153.9442 | 1.6500 | ["150","155"] | ["0.5573","0.5578"] | [] | ["XBOX"] | 150.0000 | 155.0000 | 192 | 192 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T16:57:32Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a081c7-b6c9-7143-adf6-ba67c59bcd4b | SPCX | 2026-09-08 12:09 | call_diagonal_spread | 2 | 1 | 50 | 49500.00 | short | ask | 153.4850 | 0.5000 | ["155","175"] | ["0.5751","0.5414"] | [] | ["SPHR"] | 155.0000 | 175.0000 | 10 | 45 | false | true | true | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T16:09:31Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08142-bfb8-7311-8dd5-b153e11b3c6e | SPCX | 2026-09-08 09:43 | put_vertical_spread | 2 | 1 | 1500 | 17757000.00 | unknown | — | 145.5800 | 3.2500 | ["110","245"] | ["0.5868","0.6557"] | [] | ["XPHO"] | 110.0000 | 245.0000 | 374 | 374 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T13:43:53Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a06df3-73bd-7013-b02f-852d953b658e | SPCX | 2026-09-04 15:44 | put_vertical_spread | 2 | 1 | 33 | 602514.00 | unknown | — | 148.6100 | 4.8000 | ["230","250"] | ["1.0526","1.2365"] | [] | ["XPHO"] | 230.0000 | 250.0000 | 14 | 14 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:44:39Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d68-9cc5-7031-8357-6869c4e338eb | SPCX | 2026-09-04 13:12 | risk_reversal | 2 | 1 | 75 | 98775.00 | short | bid | 148.7580 | 0.4000 | ["120","195"] | ["0.5562","0.5378"] | ["195.17"] | ["XBOX"] | 120.0000 | 195.0000 | 133 | 133 | false | true | false | true | true | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T17:13:28Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |