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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b4e1-f928-7a93-8734-a5b1a6856b34 | SMH | 2026-09-18 10:18 | other | 3 | 1 | 750 | 1692500.00 | unknown | ask | 566.1450 | 3.2000 | ["400","625","750"] | ["0.4428","0.3278","0.3294"] | ["637.95","974.10"] | ["SPHR"] | 400.0000 | 750.0000 | 119 | 119 | false | true | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:18:38Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0aba5-d2c3-7681-a15b-030a13421dd8 | SMH | 2026-09-16 15:16 | other | 4 | 1 | 1150 | 29726200.00 | unknown | — | 541.2800 | 13.4000 | ["630","650","665","675"] | ["1.3535","1.3424","1.7122","1.8082"] | [] | ["XBOX"] | 630.0000 | 675.0000 | 2 | 2 | true | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:16:17Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a5cc-17f5-7f42-a923-88f9f70dce53 | SMH | 2026-09-15 12:00 | other | 3 | 1 | 680 | 1211042.00 | unknown | — | 541.4200 | 2.8000 | ["420","555","640"] | ["0.4281","0.3329","0.3519"] | [] | ["XBOX"] | 420.0000 | 640.0000 | 31 | 66 | false | true | true | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T16:00:25Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a579-8356-7f10-94a7-2a902ed13bcf | SMH | 2026-09-15 10:29 | other | 3 | 1 | 750 | 600000.00 | unknown | — | 545.1100 | 1.6200 | ["500","515","525"] | ["0.3789","0.3707","0.4391"] | [] | ["SPHR"] | 500.0000 | 525.0000 | 3 | 17 | false | true | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:30:12Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a158-1500-7581-9015-09073979e73f | SMH | 2026-09-14 15:14 | other | 3 | 1 | 318 | 7868160.00 | unknown | — | 545.0500 | 9.7500 | ["665","675","700"] | ["1.1782","1.2761","1.3410"] | [] | ["XBOX"] | 665.0000 | 700.0000 | 4 | 4 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T19:15:23Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a153-8cd8-7452-af8c-62ddac5a8d61 | SMH | 2026-09-14 15:09 | other | 4 | 1 | 235 | 5880950.00 | unknown | — | 545.7403 | 13.0000 | ["660","665","675","680"] | ["1.1566","1.1248","1.2231","1.3507"] | [] | ["XBOX"] | 660.0000 | 680.0000 | 4 | 4 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T19:10:13Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a120-6330-7352-93f7-35c0aa2056c3 | SMH | 2026-09-14 14:14 | other | 4 | 3 | 200 | 3362000.00 | unknown | — | 545.4150 | 6.1500 | ["550","600"] | ["0.3561","0.3363"] | [] | ["AMXO"] | 550.0000 | 600.0000 | 95 | 186 | false | false | true | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T18:14:55Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a026-c0f1-7641-a2b9-21d4e654a820 | SMH | 2026-09-14 09:41 | other | 2 | 1 | 1462 | 2275890.00 | unknown | — | 539.0400 | 1.3500 | ["515","530"] | ["0.4169","0.3871"] | [] | ["XBOX"] | 515.0000 | 530.0000 | 11 | 11 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T13:41:28Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a091ea-2950-7f22-9bd7-5cb703b96931 | SMH | 2026-09-11 15:20 | other | 7 | 1 | 827 | 14349020.00 | unknown | — | 569.3900 | 18.2000 | ["640","645","650","660","665","675","700"] | ["0.5939","0.6019","0.6258","0.6863","0.7085","0.7669","0.8940"] | [] | ["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:20:43Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |