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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b61a-f23f-7a93-a7f0-f4ac12c4c0e6 | SMH | 2026-09-18 16:00 | call_diagonal_spread | 2 | 1 | 65 | 85410.00 | short | ask | 573.0000 | 6.7000 | ["565","575"] | ["15.7244","0.2295"] | [] | ["XCBO"] | 565.0000 | 575.0000 | 0 | 7 | false | false | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T20:00:17Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5d4-5bef-71f0-95e9-d824bca3130e | SMH | 2026-09-18 14:43 | call_diagonal_spread | 2 | 1 | 4 | 43640.00 | unknown | bid | 564.3300 | 3.2500 | ["600","630"] | ["0.3333","0.3585"] | [] | ["XBOX"] | 600.0000 | 630.0000 | 119 | 455 | false | true | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:43:20Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4e3-7bdf-7792-9a1e-af873c717434 | SMH | 2026-09-18 10:19 | call_diagonal_spread | 2 | 1 | 47 | 71863.00 | long | ask | 565.9300 | 0.9500 | ["560","565"] | ["0.3263","0.2697"] | [] | ["XCBO"] | 560.0000 | 565.0000 | 0 | 7 | false | false | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:20:10Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4da-05ff-7960-9b9e-f677a45e054f | SMH | 2026-09-18 10:09 | call_diagonal_spread | 2 | 1 | 20 | 459671.00 | long | bid | 564.9800 | 4.6000 | ["390","550"] | ["7.4276","0.3426"] | [] | ["XCBO"] | 390.0000 | 550.0000 | 0 | 119 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:09:54Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4d9-4697-7c62-a3cb-d9820c4c7631 | SMH | 2026-09-18 10:08 | call_diagonal_spread | 2 | 1 | 5 | 114820.00 | short | ask | 564.4850 | 5.7500 | ["390","550"] | ["7.5907","0.3440"] | [] | ["XCBO"] | 390.0000 | 550.0000 | 0 | 119 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:08:58Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b0d6-44cb-7973-8b7d-f75e728375da | SMH | 2026-09-17 15:27 | call_diagonal_spread | 2 | 1 | 122 | 292072.00 | long | ask | 560.7700 | 0.5500 | ["565","570"] | ["0.2822","0.3123"] | [] | ["XISX"] | 565.0000 | 570.0000 | 8 | 29 | false | true | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:27:15Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b047-feeb-72f3-9257-baa9acf2dd23 | SMH | 2026-09-17 12:51 | call_diagonal_spread | 2 | 1 | 3 | 90357.00 | long | ask | 560.4610 | 4.1000 | ["410","415"] | ["2.2340","0.4601"] | [] | ["XPHO"] | 410.0000 | 415.0000 | 1 | 64 | false | false | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T16:51:42Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afc8-91d3-77a1-a874-9569fa1b5872 | SMH | 2026-09-17 10:32 | call_diagonal_spread | 2 | 1 | 200 | 481200.00 | unknown | — | 559.6875 | 1.1000 | ["565","570"] | ["0.3022","0.3192"] | [] | ["XISX"] | 565.0000 | 570.0000 | 8 | 29 | false | true | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:32:34Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afa6-11cb-7522-b66f-9f7f425ba880 | SMH | 2026-09-17 09:54 | call_diagonal_spread | 2 | 1 | 4 | 53140.00 | unknown | — | 561.1100 | 5.9500 | ["430","505"] | ["0.5106","0.3799"] | [] | ["XCBO"] | 430.0000 | 505.0000 | 29 | 43 | false | false | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T13:54:58Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0af99-aa03-79e0-be79-6b44257d556e | SMH | 2026-09-17 09:41 | call_diagonal_spread | 2 | 1 | 6 | 34386.00 | short | ask | 558.2882 | 5.9000 | ["525","535"] | ["1.1403","0.5617"] | [] | ["XCBO"] | 525.0000 | 535.0000 | 0 | 1 | false | false | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T13:41:26Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0a6a3-97ee-7ea3-bdcd-958f0d091f95 | SMH | 2026-09-15 15:55 | call_diagonal_spread | 2 | 1 | 5 | 165060.00 | long | ask | 541.7100 | 3.2500 | ["380","385"] | ["0.4712","0.4896"] | [] | ["XMIO"] | 380.0000 | 385.0000 | 66 | 94 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:55:41Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a059-0808-7671-81a2-5b460bb4c84f | SMH | 2026-09-14 10:36 | call_diagonal_spread | 2 | 1 | 10 | 52940.00 | short | bid | 542.1650 | 3.4000 | ["550","575"] | ["0.3481","0.3490"] | [] | ["XCBO"] | 550.0000 | 575.0000 | 32 | 123 | false | true | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T14:36:31Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a087be-4790-7cb2-a448-77e8e0cafa98 | SMH | 2026-09-09 15:56 | call_diagonal_spread | 2 | 1 | 10 | 109330.00 | long | ask | 573.2900 | 2.3700 | ["470","610"] | ["0.4415","0.3278"] | [] | ["EDGO"] | 470.0000 | 610.0000 | 9 | 37 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T19:56:35Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08164-3a08-7481-8a56-3db501ce8d3f | SMH | 2026-09-08 10:20 | call_diagonal_spread | 2 | 1 | 10 | 48280.00 | long | bid | 573.5850 | 4.1500 | ["555","585"] | ["0.3894","0.3564"] | [] | ["XCBO"] | 555.0000 | 585.0000 | 10 | 38 | false | false | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T14:20:41Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |