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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b5f0-f827-75b0-ac38-0d92f0180585 | SMH | 2026-09-18 15:14 | other | 4 | 2 | 5 | 87841.00 | unknown | ask | 565.4300 | 6.2200 | ["140","145","470","520"] | ["71.8845","70.9813","0.4187","0.3492"] | [] | ["XCBO"] | 140.0000 | 520.0000 | 0 | 28 | false | false | true | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:14:50Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b564-40b7-7f20-871a-85f527bb76ca | SMH | 2026-09-18 12:40 | other | 4 | 1 | 5 | 169560.00 | unknown | bid | 564.0250 | 10.7000 | ["420","540","545"] | ["0.6633","1.7335","0.3120"] | [] | ["XMIO"] | 420.0000 | 545.0000 | 0 | 28 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:40:58Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b500-ac87-7983-9d8d-5eb5aca8cf58 | SMH | 2026-09-18 10:51 | other | 4 | 1 | 35 | 32725.00 | unknown | bid | 565.2900 | 0.4200 | ["535","545"] | ["0.5790","0.4668"] | [] | ["XCBO"] | 535.0000 | 545.0000 | 0 | 14 | false | true | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:52:06Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4fe-bc70-7fb0-84e8-7c5171903a49 | SMH | 2026-09-18 10:49 | other | 4 | 1 | 104 | 99942.00 | unknown | — | 564.9250 | 0.8300 | ["535","545"] | ["0.5741","0.4770"] | [] | ["EDGO"] | 535.0000 | 545.0000 | 0 | 14 | false | true | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:50:09Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b0c3-e1c3-7a30-8eab-d60409c76c1a | SMH | 2026-09-17 15:07 | other | 4 | 1 | 2 | 32246.00 | unknown | — | 561.3100 | 11.9500 | ["515","520","525","530"] | ["1.2045","0.6452","0.3420","0.3339"] | [] | ["XCBO"] | 515.0000 | 530.0000 | 1 | 11 | false | false | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:07:02Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0a141-83a8-77c1-9509-78475a230b69 | SMH | 2026-09-14 14:50 | other | 4 | 1 | 5 | 31720.00 | unknown | — | 546.0200 | 3.4500 | ["545","550"] | ["0.3417","0.3381"] | [] | ["XCBO"] | 545.0000 | 550.0000 | 4 | 39 | false | false | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T18:50:58Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a125-f4f8-70a3-8cc5-a028cfd58492 | SMH | 2026-09-14 14:20 | other | 4 | 1 | 6 | 39315.00 | unknown | — | 545.7100 | 8.2000 | ["525","550","585"] | ["0.3400","0.3480","0.4444"] | [] | ["MCRY"] | 525.0000 | 585.0000 | 4 | 32 | false | false | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T18:21:00Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0a3-4008-7193-9391-79a3f710783a | SMH | 2026-09-14 11:57 | other | 2 | 1 | 5 | 32866.00 | unknown | — | 544.1550 | 2.4500 | ["600"] | ["0.3432"] | [] | ["XCBO"] | 600.0000 | 600.0000 | 123 | 276 | false | true | true | false | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T15:57:58Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a05b-bf59-7c83-9806-40af88a9fbd7 | SMH | 2026-09-14 10:39 | other | 4 | 1 | 100 | 90525.00 | unknown | — | 541.3100 | 2.5800 | ["570","575","580","585"] | ["0.3463","0.3436","0.3496","0.3606"] | [] | ["XPHO"] | 570.0000 | 585.0000 | 11 | 11 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T14:39:35Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a03d-5e01-7433-b4ab-7754ac8023cf | SMH | 2026-09-14 10:06 | other | 4 | 1 | 475 | 1229287.00 | unknown | — | 543.3350 | 2.5100 | ["480","530"] | ["0.5091","0.4088"] | [] | ["EDGO"] | 480.0000 | 530.0000 | 4 | 32 | false | true | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T14:06:12Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a037-9970-73a0-aefe-abf200b264b6 | SMH | 2026-09-14 09:59 | other | 4 | 1 | 2 | 32841.00 | unknown | — | 542.2200 | 10.5200 | ["420","465","680"] | ["0.5863","0.4605","0.3983"] | [] | ["XCBO"] | 420.0000 | 680.0000 | 18 | 494 | false | false | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T13:59:53Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0915d-3f19-7940-ac2a-ab938332779f | SMH | 2026-09-11 12:46 | other | 2 | 1 | 108 | 34128.00 | unknown | — | 570.3600 | 1.3400 | ["545"] | ["0.3391"] | [] | ["XCBO"] | 545.0000 | 545.0000 | 5 | 6 | false | true | true | false | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T16:47:00Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a090f7-5540-7093-a192-edf644a0a394 | SMH | 2026-09-11 10:55 | other | 4 | 1 | 5 | 38305.00 | unknown | — | 567.8200 | 9.3000 | ["550","555","557.5","562.5"] | ["0.9617","0.6740","0.3308","0.3233"] | [] | ["XCBO"] | 550.0000 | 562.5000 | 0 | 21 | false | false | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T14:55:45Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a0876d-9368-7f70-a34d-8e736ce84a56 | SMH | 2026-09-09 14:28 | other | 2 | 1 | 10 | 27960.00 | unknown | — | 574.1250 | 0.9000 | ["575","625"] | ["0.3611","0.3488"] | [] | ["XBOX"] | 575.0000 | 625.0000 | 23 | 30 | false | true | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T18:28:38Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a086f8-8a78-7e41-9317-0730f7c7395b | SMH | 2026-09-09 12:20 | other | 4 | 1 | 2 | 30251.00 | unknown | — | 572.7300 | 8.4500 | ["470","525","620","660"] | ["0.4150","0.3918","0.3760","0.3812"] | [] | ["MCRY"] | 470.0000 | 660.0000 | 100 | 128 | false | false | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T16:21:11Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a086bb-23b8-71d3-aebc-5d8558844424 | SMH | 2026-09-09 11:13 | other | 3 | 3 | 474 | 70837.00 | unknown | — | 572.1000 | 0.6400 | ["585","605","630"] | ["0.4084","0.4248","0.5201"] | [] | ["XBOX","XCBO","XISX"] | 585.0000 | 630.0000 | 2 | 2 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T15:13:44Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a086b3-ccd0-7693-b96f-3b0aac45c0f6 | SMH | 2026-09-09 11:05 | other | 3 | 3 | 500 | 103508.00 | unknown | — | 575.5900 | 0.7100 | ["585","605","630"] | ["0.4064","0.4147","0.4907"] | [] | ["XBOX","XCBO","XISX"] | 585.0000 | 630.0000 | 2 | 2 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T15:05:27Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0868a-6ef8-75c2-972d-eb61f522b555 | SMH | 2026-09-09 10:20 | other | 3 | 1 | 8 | 31584.00 | unknown | — | 575.2900 | 4.1500 | ["450","550","600"] | ["0.4738","0.3815","0.3607"] | [] | ["XCBO"] | 450.0000 | 600.0000 | 37 | 37 | false | false | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:20:20Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0828e-bfe8-7c32-82a5-bd13eb0c2321 | SMH | 2026-09-08 15:46 | other | 3 | 1 | 90 | 205560.00 | unknown | — | 572.9150 | 0.6600 | ["490","510","560"] | ["0.4293","0.4369","0.3706"] | [] | ["XMIO"] | 490.0000 | 560.0000 | 10 | 38 | false | true | true | true | false | mlat | 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 |
| 01a0828e-6228-7841-94be-4cf329bbcbff | SMH | 2026-09-08 15:46 | other | 3 | 1 | 35 | 79905.00 | unknown | — | 572.8700 | 0.5400 | ["490","510","560"] | ["0.4307","0.4378","0.3697"] | [] | ["XMIO"] | 490.0000 | 560.0000 | 10 | 38 | false | true | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T19:46:02Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a0828e-5e40-73f3-b4b1-efeee14f4e14 | SMH | 2026-09-08 15:46 | other | 3 | 1 | 43 | 98169.00 | unknown | — | 572.8700 | 0.5400 | ["490","510","560"] | ["0.4307","0.4378","0.3697"] | [] | ["XMIO"] | 490.0000 | 560.0000 | 10 | 38 | false | true | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T19:46:02Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a0828e-5670-7320-88f0-6eeb3cb5b360 | SMH | 2026-09-08 15:45 | other | 3 | 1 | 33 | 75207.00 | unknown | — | 572.8950 | 0.5000 | ["490","510","560"] | ["0.4308","0.4379","0.3693"] | [] | ["XMIO"] | 490.0000 | 560.0000 | 10 | 38 | false | true | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T19:46:02Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a0828d-fc98-72e3-8f25-82522e6f2aab | SMH | 2026-09-08 15:45 | other | 3 | 1 | 42 | 95088.00 | unknown | — | 573.1600 | 0.5700 | ["490","510","560"] | ["0.4327","0.4392","0.3683"] | [] | ["XMIO"] | 490.0000 | 560.0000 | 10 | 38 | false | true | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T19:45:37Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08251-0720-7471-b9b8-11189ee4028d | SMH | 2026-09-08 14:39 | other | 2 | 1 | 48 | 126936.00 | unknown | — | 576.1100 | 0.9500 | ["475","550"] | ["0.4163","0.3895"] | [] | ["XBOX"] | 475.0000 | 550.0000 | 101 | 101 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T18:39:34Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a0824f-4200-7f70-9583-c365ff58466d | SMH | 2026-09-08 14:37 | other | 2 | 1 | 50 | 132950.00 | unknown | — | 575.5500 | 0.8500 | ["475","550"] | ["0.4157","0.3896"] | [] | ["XBOX"] | 475.0000 | 550.0000 | 101 | 101 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T18:37:52Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a0822a-d1e0-7a31-8bb9-9ea08672cd28 | SMH | 2026-09-08 13:57 | other | 4 | 1 | 15 | 148200.00 | unknown | — | 574.9900 | 6.0500 | ["560","570","580"] | ["0.3897","0.3779","0.3728"] | [] | ["XMIO"] | 560.0000 | 580.0000 | 10 | 38 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T17:57:36Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08163-f3b8-7072-a34e-dd43d48d40b8 | SMH | 2026-09-08 10:20 | other | 2 | 1 | 50 | 36250.00 | unknown | — | 573.3600 | 0.5800 | ["550"] | ["0.4169"] | [] | ["XMIO"] | 550.0000 | 550.0000 | 3 | 10 | false | true | true | false | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T14:20:14Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a06e01-c3cd-7582-bc07-9a8aa93271bf | SMH | 2026-09-04 16:00 | other | 3 | 1 | 20 | 67220.00 | unknown | — | 567.0100 | 4.2000 | ["565","585","605"] | ["0.3267","0.3265","0.3291"] | [] | ["AMXO"] | 565.0000 | 605.0000 | 35 | 35 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T20:00:34Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06dfd-2435-7a03-b343-7ea898ad10d6 | SMH | 2026-09-04 15:54 | other | 2 | 1 | 15 | 237545.00 | unknown | — | 566.8000 | 3.3500 | ["470","490"] | ["0.3939","0.3887"] | [] | ["XCBO"] | 470.0000 | 490.0000 | 42 | 77 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:55:02Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06dd0-7e85-78f2-b593-a6822569c89a | SMH | 2026-09-04 15:06 | other | 4 | 1 | 2 | 123148.00 | unknown | — | 564.2700 | 13.1500 | ["410","415"] | ["0.6215","0.6025"] | [] | ["XCBO"] | 410.0000 | 415.0000 | 14 | 49 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:06:36Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |