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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b5e7-c0c7-7c13-b26f-78718e8df039 | SMH | 2026-09-18 15:04 | call_calendar | 2 | 1 | 11 | 29975.00 | long | ask | 565.6700 | 0.2000 | ["600"] | ["0.3226"] | [] | ["C2OX"] | 600.0000 | 600.0000 | 28 | 63 | false | true | true | false | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:04:25Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4e0-d430-7482-9217-060df3c7b56e | SMH | 2026-09-18 10:17 | call_diagonal_spread | 2 | 2 | 30 | 97800.00 | long | ask | 565.4300 | 2.1500 | ["550","552.5"] | ["0.4471","0.2874"] | [] | ["XCBO"] | 550.0000 | 552.5000 | 0 | 7 | false | false | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:17:17Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b0ac-cb9b-7f42-8a1a-1933d8d30c32 | SMH | 2026-09-17 14:41 | strangle | 2 | 3 | 26 | 96200.00 | long | ask | 560.9100 | 0.2500 | ["560","565"] | ["0.3133","0.3124"] | ["523","602.00"] | ["ARCO","XCBO"] | 560.0000 | 565.0000 | 29 | 29 | false | true | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:41:47Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0ac-bfe3-7822-811f-4eee03b8b9e5 | SMH | 2026-09-17 14:41 | strangle | 2 | 4 | 23 | 85100.00 | long | ask | 560.9100 | 0.3000 | ["560","565"] | ["0.3133","0.3124"] | ["523","602.00"] | ["ARCO","C2OX","XCBO"] | 560.0000 | 565.0000 | 29 | 29 | false | true | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:41:47Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afba-bec3-78b2-af79-651ea2a588c3 | SMH | 2026-09-17 10:17 | straddle | 2 | 1 | 30 | 423750.00 | long | ask | 561.3600 | 1.1000 | ["580"] | ["0.3677"] | ["438.75","721.25"] | ["C2OX"] | 580.0000 | 580.0000 | 273 | 273 | false | false | false | false | true | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:17:29Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afb5-dcc3-78a3-8235-43244f99826f | SMH | 2026-09-17 10:12 | straddle | 2 | 1 | 17 | 239870.00 | long | ask | 559.8700 | 2.3500 | ["580"] | ["0.3678"] | ["438.90","721.10"] | ["C2OX"] | 580.0000 | 580.0000 | 273 | 273 | false | false | false | false | true | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:12:24Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0aafe-0d8b-7752-b180-2dd0dfd67e98 | SMH | 2026-09-16 12:12 | put_vertical_spread | 2 | 2 | 6 | 31320.00 | long | ask | 551.1250 | 0.4500 | ["530","550"] | ["0.3638","0.3550"] | ["541.70"] | ["C2OX"] | 530.0000 | 550.0000 | 65 | 65 | false | true | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T16:13:23Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a657-6fd6-7493-9736-4f5773772c5e | SMH | 2026-09-15 14:32 | call_vertical_spread | 2 | 2 | 10 | 31800.00 | long | ask | 541.7950 | 0.7000 | ["600","620"] | ["0.3389","0.3369"] | ["604.90"] | ["C2OX"] | 600.0000 | 620.0000 | 94 | 94 | false | true | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T18:32:49Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a5ca-0c85-7de1-8aaf-807d6dd4f542 | SMH | 2026-09-15 11:57 | risk_reversal | 2 | 1 | 10 | 27650.00 | short | ask | 542.2600 | 0.1000 | ["500","600"] | ["0.3748","0.3390"] | ["497.75"] | ["XBOX"] | 500.0000 | 600.0000 | 66 | 66 | false | true | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T15:58:09Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a115-9d60-7550-adcb-a98379b5e036 | SMH | 2026-09-14 14:02 | strangle | 2 | 6 | 18 | 36900.00 | long | ask | 545.1800 | 0.2500 | ["520","575"] | ["0.3455","0.3139"] | ["499.50","595.50"] | ["BATO","XISX","XPHO"] | 520.0000 | 575.0000 | 32 | 32 | false | true | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T18:03:02Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a115-9d60-7550-adcb-a9783101685c | SMH | 2026-09-14 14:02 | strangle | 2 | 11 | 48 | 98402.00 | long | ask | 545.1800 | 0.0938 | ["520","575"] | ["0.3455","0.3139"] | ["499.50","595.50"] | ["AMXO","ARCO","BATO","EDGO","EMLD","XBOX","XCBO","XISX","XPHO"] | 520.0000 | 575.0000 | 32 | 32 | false | true | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T18:03:02Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a110-abc1-7fb0-b0ab-e34339d5425c | SMH | 2026-09-14 13:56 | strangle | 2 | 4 | 45 | 91350.00 | long | ask | 545.5200 | 0.1000 | ["520","575"] | ["0.3437","0.3121"] | ["499.70","595.30"] | ["ARCO","C2OX","EDGO"] | 520.0000 | 575.0000 | 32 | 32 | false | true | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T17:57:21Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a110-abc1-7fb0-b0ab-e2fa4f0bba7c | SMH | 2026-09-14 13:56 | strangle | 2 | 5 | 65 | 131950.00 | long | ask | 545.5200 | 0.3000 | ["520","575"] | ["0.3437","0.3121"] | ["499.70","595.30"] | ["AMXO","EMLD","XCBO","XISX","XPHO"] | 520.0000 | 575.0000 | 32 | 32 | false | true | false | true | true | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T17:57:21Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0c9-abf9-79d2-8489-cddfbd687cb7 | SMH | 2026-09-14 12:39 | synthetic | 2 | 1 | 3 | 26640.00 | long | ask | 543.6600 | 0.8000 | ["550"] | ["0.3536"] | ["550.30"] | ["XPHO"] | 550.0000 | 550.0000 | 123 | 123 | false | false | false | false | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T16:40:05Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0c9-a810-7fb3-bd68-fb109aebfe99 | SMH | 2026-09-14 12:39 | synthetic | 2 | 1 | 5 | 44350.00 | long | ask | 543.6600 | 1.0000 | ["550"] | ["0.3532"] | ["550.40"] | ["MCRY"] | 550.0000 | 550.0000 | 123 | 123 | false | false | false | false | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T16:40:05Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a090fd-b228-7af3-ae87-e41df0604491 | SMH | 2026-09-11 11:02 | synthetic | 2 | 1 | 6 | 27750.00 | long | ask | 569.2200 | 0.7000 | ["570"] | ["0.3293"] | ["571.45"] | ["XMIO"] | 570.0000 | 570.0000 | 35 | 35 | false | false | false | false | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T15:02:45Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08bdc-3058-7f61-b971-319f7cc02a18 | SMH | 2026-09-10 11:07 | ratio_risk_reversal | 2 | 1 | 6 | 36585.00 | long | ask | 564.5400 | 1.1000 | ["485","630"] | ["0.3967","0.3696"] | ["478.88"] | ["ARCO"] | 485.0000 | 630.0000 | 280 | 280 | false | true | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T15:07:55Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08bb2-ce98-7473-babe-7482a9630b04 | SMH | 2026-09-10 10:22 | risk_reversal | 2 | 1 | 22 | 135190.00 | short | ask | 560.3062 | 1.2000 | ["520","675"] | ["0.3867","0.3549"] | ["507.35"] | ["XBOX"] | 520.0000 | 675.0000 | 190 | 190 | false | true | false | true | true | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T14:22:28Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08bb2-ce98-7473-babe-7475cbf0b96c | SMH | 2026-09-10 10:22 | risk_reversal | 2 | 1 | 6 | 36870.00 | short | ask | 560.2500 | 0.7000 | ["520","675"] | ["0.3867","0.3551"] | ["507.35"] | ["XBOX"] | 520.0000 | 675.0000 | 190 | 190 | false | true | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T14:22:28Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08714-1159-7fb0-b89a-8ec40d08db1e | SMH | 2026-09-09 12:50 | synthetic | 2 | 1 | 23 | 366965.00 | short | ask | 575.1400 | 0.3000 | ["630"] | ["0.3804"] | ["592.25"] | ["MCRY"] | 630.0000 | 630.0000 | 281 | 281 | false | false | false | false | true | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T16:50:46Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08714-0988-7842-9d01-de2f48466a43 | SMH | 2026-09-09 12:50 | synthetic | 2 | 1 | 2 | 31910.00 | short | ask | 575.1650 | 0.8000 | ["630"] | ["0.3804"] | ["592.25"] | ["XBOX"] | 630.0000 | 630.0000 | 281 | 281 | false | false | false | false | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T16:50:46Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0870d-d798-7990-8629-235415095d4d | SMH | 2026-09-09 12:43 | straddle | 2 | 1 | 8 | 127640.00 | long | ask | 574.5300 | 0.3500 | ["630"] | ["0.3803"] | ["470.45","789.55"] | ["C2OX"] | 630.0000 | 630.0000 | 281 | 281 | false | false | false | false | true | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T16:44:02Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0870d-d798-7990-8629-2345e739a452 | SMH | 2026-09-09 12:43 | straddle | 2 | 1 | 3 | 47865.00 | long | ask | 574.5300 | 0.7000 | ["630"] | ["0.3804"] | ["470.45","789.55"] | ["C2OX"] | 630.0000 | 630.0000 | 281 | 281 | false | false | false | false | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T16:44:02Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08150-5830-7802-a46d-74e70c58546e | SMH | 2026-09-08 09:58 | put_vertical_spread | 2 | 3 | 48 | 25488.00 | long | ask | 574.6550 | 0.2100 | ["400","500"] | ["0.5575","0.4002"] | ["496.01"] | ["C2OX","EDGO"] | 400.0000 | 500.0000 | 38 | 38 | false | true | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T13:58:56Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |