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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c573-0546-7831-9ab7-5f7507c258b3 | SMH | 2026-09-21 15:30 | put_frontspread | 2 | 1 | 27 | 45684.00 | long | ask | 596.6200 | 0.9000 | ["552.5","587.5"] | ["0.3639","0.3414"] | ["496.3","580.6"] | ["XISX"] | 552.5000 | 587.5000 | 25 | 25 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T19:30:46Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c4fe-3306-79a2-8844-4a5e193bab73 | SMH | 2026-09-21 13:23 | put_frontspread | 2 | 2 | 60 | 97560.00 | long | ask | 592.5350 | 0.6000 | ["552.5","580"] | ["0.3573","0.3382"] | ["506.2","575.65"] | ["XISX","XPHO"] | 552.5000 | 580.0000 | 25 | 25 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T17:23:25Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c4cc-3627-73d1-8224-655824c08223 | SMH | 2026-09-21 12:28 | put_frontspread | 2 | 7 | 300 | 378660.00 | long | ask | 592.2700 | 0.8117 | ["575","590"] | ["0.3402","0.3302"] | ["558.90"] | ["ARCO","BATO","C2OX","EDGO","EMLD","SPHR","XPHO"] | 575.0000 | 590.0000 | 11 | 11 | true | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T16:28:36Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c497-957f-72d0-930c-336e1271172b | SMH | 2026-09-21 11:31 | put_frontspread | 2 | 4 | 268 | 53664.00 | long | ask | 591.4201 | 0.4600 | ["570","590"] | ["0.4226","0.3408"] | ["553.00","587.0"] | ["MCRY","XISX","XMIO","XPHO"] | 570.0000 | 590.0000 | 1 | 1 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T15:31:18Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c497-957f-72d0-930c-3357117395a0 | SMH | 2026-09-21 11:31 | put_frontspread | 2 | 10 | 718 | 145572.00 | long | ask | 591.4201 | 0.4600 | ["570","590"] | ["0.4267","0.3428"] | ["553","587.00"] | ["AMXO","ARCO","C2OX","EDGO","EMLD","XBOX","XCBO","XMIO","XPHO"] | 570.0000 | 590.0000 | 1 | 1 | true | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T15:31:18Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c492-abaf-7a00-becf-b109164da559 | SMH | 2026-09-21 11:25 | put_frontspread | 2 | 1 | 650 | 944642.00 | long | ask | 590.5700 | 0.6500 | ["550","580"] | ["0.3645","0.3432"] | ["521.78","578.22"] | ["XISX"] | 550.0000 | 580.0000 | 25 | 25 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T15:26:07Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b50c-780f-7c71-9855-d5360991635c | SMH | 2026-09-18 11:04 | put_frontspread | 2 | 1 | 32 | 119231.00 | long | ask | 564.6400 | 1.8000 | ["500","560"] | ["0.3731","0.3523"] | ["443.19","556.81"] | ["XCBO"] | 500.0000 | 560.0000 | 119 | 119 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:04:49Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b50c-5cb8-7550-9e34-4138f60b569c | SMH | 2026-09-18 11:04 | put_frontspread | 2 | 2 | 68 | 253572.00 | long | ask | 564.6400 | 1.8500 | ["500","560"] | ["0.3729","0.3530"] | ["443.30","556.70"] | ["XISX","XPHO"] | 500.0000 | 560.0000 | 119 | 119 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:04:49Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0a04c-a811-7f13-baad-425f0d4248f1 | SMH | 2026-09-14 10:22 | put_frontspread | 2 | 2 | 8 | 33346.00 | long | ask | 543.2300 | 2.4500 | ["540","560"] | ["0.3432","0.3302"] | ["491.25","556.25"] | ["XISX","XPHO"] | 540.0000 | 560.0000 | 32 | 32 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T14:23:16Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a026-24b0-7e91-925c-835aac75fcc0 | SMH | 2026-09-14 09:40 | put_frontspread | 2 | 2 | 36 | 69018.00 | unknown | — | 538.7300 | 1.7000 | ["535","550"] | ["0.4544","0.4302"] | [] | ["ARCO","XCBO"] | 535.0000 | 550.0000 | 4 | 4 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T13:40:57Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a026-24b0-7e91-925c-834288de1aae | SMH | 2026-09-14 09:40 | put_frontspread | 2 | 2 | 24 | 46080.00 | unknown | — | 538.6600 | 1.6500 | ["535","550"] | ["0.4536","0.4290"] | [] | ["ARCO","XCBO"] | 535.0000 | 550.0000 | 4 | 4 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T13:40:57Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a026-20c9-74c0-b59f-153d8a88964b | SMH | 2026-09-14 09:40 | put_frontspread | 2 | 3 | 192 | 370797.00 | long | ask | 538.6600 | 1.7000 | ["535","550"] | ["0.4562","0.4330"] | ["512.55","546.23"] | ["ARCO","EDGO"] | 535.0000 | 550.0000 | 4 | 4 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T13:40:57Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a026-20c9-74c0-b59f-152a568eb97c | SMH | 2026-09-14 09:40 | put_frontspread | 2 | 1 | 54 | 104292.00 | long | ask | 538.6600 | 1.8000 | ["535","550"] | ["0.4545","0.4358"] | ["512.78","546.11"] | ["XCBO"] | 535.0000 | 550.0000 | 4 | 4 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T13:40:57Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a026-20c9-74c0-b59f-151dd397431a | SMH | 2026-09-14 09:40 | put_frontspread | 2 | 2 | 27 | 51909.00 | long | ask | 538.6600 | 1.9000 | ["535","550"] | ["0.4552","0.4283"] | ["512.43","546.28"] | ["AMXO","XMIO"] | 535.0000 | 550.0000 | 4 | 4 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T13:40:57Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a026-20c9-74c0-b59f-14dc09293bda | SMH | 2026-09-14 09:40 | put_frontspread | 2 | 1 | 90 | 173910.00 | unknown | — | 538.6600 | 1.9500 | ["535","550"] | ["0.4574","0.4319"] | [] | ["XMIO"] | 535.0000 | 550.0000 | 4 | 4 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T13:40:57Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a024-f400-7173-be41-fcdce5469cff | SMH | 2026-09-14 09:39 | put_frontspread | 2 | 2 | 150 | 294944.00 | long | ask | 538.5400 | 1.7000 | ["535","550"] | ["0.4614","0.4425"] | ["512.60","546.20"] | ["EDGO","XPHO"] | 535.0000 | 550.0000 | 4 | 4 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T13:39:43Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a023-c739-7ca0-a708-97714c7bbb84 | SMH | 2026-09-14 09:38 | put_frontspread | 2 | 1 | 36 | 70476.00 | long | ask | 538.3300 | 1.3500 | ["535","550"] | ["0.4544","0.4341"] | ["512.73","546.14"] | ["XCBO"] | 535.0000 | 550.0000 | 4 | 4 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T13:38:20Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a06d78-310e-70b2-a7e0-3d9161d55521 | SMH | 2026-09-04 13:29 | put_frontspread | 2 | 2 | 22 | 87886.00 | long | ask | 564.4750 | 1.4500 | ["495","560"] | ["0.3769","0.3602"] | ["434.79","555.21"] | ["ARCO","XPHO"] | 495.0000 | 560.0000 | 133 | 133 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T17:29:48Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |