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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a091e4-5cf0-7700-9b02-cc825299233a | SMH | 2026-09-11 15:14 | other | 8 | 1 | 577 | 9900210.00 | unknown | — | 569.3700 | 24.7000 | ["640","645","650","660","665","675","690","700"] | ["0.5924","0.6091","0.6287","0.6845","0.7117","0.7752","0.8688","0.8919"] | [] | ["XBOX"] | 640.0000 | 700.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:14:20Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a091a3-e509-7f61-a174-733c68e8a332 | SMH | 2026-09-11 14:03 | call_vertical_spread | 2 | 1 | 330 | 171600.00 | unknown | — | 571.5500 | 0.4400 | ["585","605"] | ["0.2928","0.2964"] | [] | ["XBOX"] | 585.0000 | 605.0000 | 7 | 7 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T18:04:32Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a0919b-8c50-7331-8999-e6a5a3a1bf52 | SMH | 2026-09-11 13:54 | put_vertical_spread | 2 | 1 | 500 | 1017500.00 | long | ask | 572.1900 | 2.0000 | ["450","525"] | ["0.4253","0.3815"] | ["512.65"] | ["XBOX"] | 450.0000 | 525.0000 | 70 | 70 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T17:54:44Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a0910c-f468-7b82-a6c2-fdf9606a9758 | SMH | 2026-09-11 11:18 | strangle | 2 | 1 | 130 | 1904500.00 | short | bid | 570.9700 | 8.3500 | ["500","700"] | ["0.4075","0.3658"] | ["353.50","846.50"] | ["AMXO"] | 500.0000 | 700.0000 | 644 | 644 | false | true | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T15:19:16Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08cbe-7a08-7d81-8410-cd40b0dae145 | SMH | 2026-09-10 15:14 | call_diagonal_spread | 2 | 2 | 21 | 62916.00 | long | bid | 561.2400 | 4.9500 | ["547.5","550"] | ["0.5467","0.3176"] | [] | ["AMXO"] | 547.5000 | 550.0000 | 1 | 4 | false | false | true | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:15:20Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08ca1-9b69-7792-96c7-442abe0a05b1 | SMH | 2026-09-10 14:43 | other | 3 | 1 | 42 | 863310.00 | unknown | — | 561.7700 | 9.6500 | ["650","660","700"] | ["0.3997","0.7008","0.8955"] | [] | ["XBOX"] | 650.0000 | 700.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:43:48Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c9f-6cd0-7a61-a17e-3f76fa170dbb | SMH | 2026-09-10 14:40 | other | 7 | 1 | 1132 | 22194688.00 | unknown | — | 562.0600 | 24.1000 | ["640","645","650","665","675","695","705"] | ["0.6348","0.6630","0.6870","0.7633","0.8233","0.3534","0.3547"] | [] | ["XBOX"] | 640.0000 | 705.0000 | 8 | 36 | false | false | true | 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 |
| 01a08c99-4699-75c0-b9d2-2eb9382e33b8 | SMH | 2026-09-10 14:34 | other | 4 | 1 | 89 | 1902360.00 | unknown | — | 561.6800 | 13.2500 | ["650","680","690","700"] | ["0.6587","0.8072","0.8702","0.8864"] | [] | ["XBOX"] | 650.0000 | 700.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:34:10Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08bae-6998-7fb2-bed8-a89c59842f00 | SMH | 2026-09-10 10:17 | put_vertical_spread | 2 | 1 | 100 | 325500.00 | unknown | — | 558.9800 | 1.8000 | ["560","575"] | ["0.3503","0.3365"] | [] | ["XBOX"] | 560.0000 | 575.0000 | 8 | 8 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T14:17:42Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a087a4-4751-7a00-a652-df7c593b7f95 | SMH | 2026-09-09 15:28 | other | 3 | 3 | 1000 | 504000.00 | unknown | — | 573.5300 | 1.8800 | ["605","625","665"] | ["0.3281","0.3255","0.3730"] | [] | ["AMXO"] | 605.0000 | 665.0000 | 16 | 16 | true | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T19:28:32Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a086e5-6fd8-7711-b756-9ea748f925ba | SMH | 2026-09-09 11:59 | straddle | 2 | 1 | 335 | 6599500.00 | short | bid | 574.1900 | 8.9000 | ["580"] | ["0.3912"] | ["383","777.00"] | ["XBOX"] | 580.0000 | 580.0000 | 464 | 464 | false | false | false | false | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T16:00:05Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a086be-c181-7f93-a512-a042e0837d86 | SMH | 2026-09-09 11:17 | other | 4 | 1 | 6398 | 13013532.00 | unknown | — | 572.9900 | 1.6600 | ["475","485","540","545"] | ["0.4369","0.5328","0.3861","0.3950"] | [] | ["SPHR"] | 475.0000 | 545.0000 | 9 | 37 | false | true | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T15:17:44Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08698-3e20-7eb2-b59e-78d036fa2620 | SMH | 2026-09-09 10:35 | other | 2 | 1 | 249 | 71712.00 | unknown | — | 575.9850 | 0.4400 | ["545"] | ["0.3770"] | [] | ["XBOX"] | 545.0000 | 545.0000 | 5 | 6 | false | true | true | false | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:35:23Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0828e-b818-7461-9cfe-dab6d5f8192c | SMH | 2026-09-08 15:46 | other | 2 | 1 | 1400 | 887600.00 | unknown | — | 572.9550 | 0.5600 | ["530","560"] | ["0.4002","0.3686"] | [] | ["ARCO"] | 530.0000 | 560.0000 | 10 | 38 | false | true | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T19:46:27Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a0828a-5318-7230-85d5-542746851d80 | SMH | 2026-09-08 15:41 | straddle | 2 | 1 | 200 | 38400.00 | short | bid | 573.4700 | 1.7400 | ["572.5"] | ["0.6471"] | ["570.58","574.42"] | ["AMXO"] | 572.5000 | 572.5000 | 0 | 0 | false | false | false | false | true | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T19:42:16Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08275-c948-7b01-a79c-43db6ab6c427 | SMH | 2026-09-08 15:19 | put_vertical_spread | 2 | 1 | 21 | 480270.00 | unknown | — | 574.6100 | 5.7000 | ["675","700"] | ["0.6602","0.7725"] | [] | ["XBOX"] | 675.0000 | 700.0000 | 10 | 10 | false | false | false | 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 |
| 01a0826c-8a18-7912-9936-f356f765947b | SMH | 2026-09-08 15:09 | put_vertical_spread | 2 | 1 | 20 | 457400.00 | unknown | — | 574.3700 | 5.7500 | ["675","700"] | ["0.6439","0.7546"] | [] | ["XBOX"] | 675.0000 | 700.0000 | 10 | 10 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T19:09:34Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08262-54d1-7162-88ec-2056079a06aa | SMH | 2026-09-08 14:57 | other | 2 | 1 | 446 | 4136204.00 | unknown | — | 574.7500 | 3.7500 | ["565"] | ["0.3804"] | [] | ["XPHO"] | 565.0000 | 565.0000 | 10 | 192 | false | false | true | false | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T18:58:16Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a081a7-2ac1-73c0-a2a3-766855e8518c | SMH | 2026-09-08 11:33 | other | 4 | 4 | 45 | 374130.00 | unknown | — | 577.3684 | 4.2000 | ["570","580"] | ["0.3800","0.3612"] | [] | ["AMXO"] | 570.0000 | 580.0000 | 10 | 38 | false | false | true | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T15:33:34Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08183-b0b8-7b21-8b73-e53b50f640f9 | SMH | 2026-09-08 10:54 | other | 3 | 3 | 126 | 1198890.00 | unknown | — | 575.3300 | 3.7000 | ["570","585"] | ["0.3549","0.3656"] | [] | ["ARCO"] | 570.0000 | 585.0000 | 38 | 101 | false | false | true | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T14:54:58Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a06df3-0a46-7483-ad5c-b6ac9dd653e4 | SMH | 2026-09-04 15:43 | put_vertical_spread | 2 | 1 | 21 | 513996.00 | unknown | — | 565.4000 | 7.2500 | ["675","700"] | ["0.5358","0.6247"] | [] | ["XPHO"] | 675.0000 | 700.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:12Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06dd6-3375-7bc3-98c8-ac40ffb59fef | SMH | 2026-09-04 15:12 | put_vertical_spread | 2 | 1 | 21 | 525210.00 | unknown | — | 563.6800 | 6.5500 | ["675","700"] | ["0.6122","0.7068"] | [] | ["XBOX"] | 675.0000 | 700.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:12:56Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d96-4ffd-70b3-9363-ee28da162ace | SMH | 2026-09-04 14:02 | other | 3 | 1 | 1308 | 687286.00 | unknown | — | 563.9450 | 0.5800 | ["515","530"] | ["0.3498","0.3343"] | [] | ["XBOX"] | 515.0000 | 530.0000 | 7 | 14 | false | true | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T18:03:22Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |