Multi-leg option trades
core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
403,968 rowsCSV — whole table, not this view
Sources in this table
uw_multileg403,968 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a06e01-b42d-7d10-bb33-81d4e8dff476 | SMH | 2026-09-04 15:59 | call_diagonal_spread_bearish | 2 | 1 | 48 | 52752.00 | long | ask | 567.0500 | 1.1000 | ["570","585"] | ["0.2037","0.3190"] | [] | ["XISX"] | 570.0000 | 585.0000 | 4 | 14 | false | true | true | true | false | mlet | 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-204f-7c70-8893-782103355deb | SMH | 2026-09-04 15:54 | call_diagonal_spread_bearish | 2 | 1 | 15 | 118950.00 | short | bid | 566.8000 | 2.3000 | ["550","570"] | ["0.3396","0.3613"] | [] | ["ARCO"] | 550.0000 | 570.0000 | 35 | 105 | false | false | true | true | false | mlet | 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 |
| 01a06dfc-c675-70e1-93d8-095064fb978b | SMH | 2026-09-04 15:54 | call_diagonal_spread_bearish | 2 | 1 | 30 | 229350.00 | short | bid | 566.9250 | 3.1000 | ["550","575"] | ["0.3354","0.3578"] | [] | ["ARCO"] | 550.0000 | 575.0000 | 35 | 105 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:54:48Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06dfc-bea5-7b82-bb87-1ee5010e6b25 | SMH | 2026-09-04 15:54 | call_diagonal_spread_bearish | 2 | 1 | 30 | 229350.00 | long | ask | 566.9100 | 3.1000 | ["550","575"] | ["0.3350","0.3582"] | [] | ["ARCO"] | 550.0000 | 575.0000 | 35 | 105 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:54:48Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06dfc-7086-73d2-afa5-f45c58b49054 | SMH | 2026-09-04 15:54 | call_diagonal_spread_bearish | 2 | 1 | 20 | 156120.00 | short | bid | 566.9800 | 3.0500 | ["547.5","575"] | ["0.3365","0.3573"] | [] | ["XPHO"] | 547.5000 | 575.0000 | 35 | 105 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:54:29Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06dfc-7086-73d2-afa5-f4403da53ff2 | SMH | 2026-09-04 15:54 | call_diagonal_spread_bearish | 2 | 1 | 20 | 156020.00 | long | ask | 566.9800 | 3.2000 | ["547.5","575"] | ["0.3351","0.3576"] | [] | ["ARCO"] | 547.5000 | 575.0000 | 35 | 105 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:54:29Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06dfc-60e5-7ee0-a8db-e8e745628cec | SMH | 2026-09-04 15:54 | call_diagonal_spread_bearish | 2 | 1 | 5 | 42420.00 | short | bid | 566.8300 | 3.7000 | ["545","565"] | ["0.3405","0.3610"] | [] | ["XPHO"] | 545.0000 | 565.0000 | 35 | 105 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:54:29Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06de9-80dd-7272-a87f-e45a60c548df | SMH | 2026-09-04 15:33 | call_diagonal_spread_bearish | 2 | 4 | 6 | 29498.00 | short | ask | 564.5100 | 3.7583 | ["530","550"] | ["6.2367","0.1913"] | [] | ["ARCO","EMLD","SPHR","XBOX"] | 530.0000 | 550.0000 | 0 | 4 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:33:45Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06de5-6615-7d50-a9a5-d1caadbad907 | SMH | 2026-09-04 15:29 | call_diagonal_spread_bearish | 2 | 1 | 38 | 96178.00 | short | ask | 563.7350 | 0.9500 | ["555","575"] | ["0.2760","0.3124"] | [] | ["C2OX"] | 555.0000 | 575.0000 | 11 | 14 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:29:07Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06de4-8f3e-7cc1-b21f-20bc8a1e12d6 | SMH | 2026-09-04 15:28 | call_diagonal_spread_bearish | 2 | 1 | 5 | 40745.00 | long | ask | 563.7400 | 2.5000 | ["540","575"] | ["0.3425","0.3564"] | [] | ["AMXO"] | 540.0000 | 575.0000 | 42 | 105 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:28:31Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06de4-8f3e-7cc1-b21f-209b065e7bfc | SMH | 2026-09-04 15:28 | call_diagonal_spread_bearish | 2 | 1 | 10 | 81480.00 | short | bid | 563.7400 | 2.7000 | ["540","575"] | ["0.3432","0.3559"] | [] | ["ARCO"] | 540.0000 | 575.0000 | 42 | 105 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:28:31Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06de4-682e-71d1-903e-d82d8ee53000 | SMH | 2026-09-04 15:27 | call_diagonal_spread_bearish | 2 | 1 | 5 | 39163.00 | long | ask | 563.8600 | 2.2500 | ["545","575"] | ["0.3397","0.3563"] | [] | ["AMXO"] | 545.0000 | 575.0000 | 42 | 105 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:28:02Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06de4-682e-71d1-903e-d80e62c3da64 | SMH | 2026-09-04 15:27 | call_diagonal_spread_bearish | 2 | 1 | 4 | 31344.00 | short | bid | 563.8600 | 2.7500 | ["545","575"] | ["0.3409","0.3559"] | [] | ["ARCO"] | 545.0000 | 575.0000 | 42 | 105 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:28:02Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06de3-bc4e-70f0-bb4c-08ff49652427 | SMH | 2026-09-04 15:27 | call_diagonal_spread_bearish | 2 | 1 | 38 | 95608.00 | short | ask | 563.6200 | 1.8000 | ["555","575"] | ["0.2758","0.3118"] | [] | ["C2OX"] | 555.0000 | 575.0000 | 11 | 14 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:27:33Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06de3-bc4e-70f0-bb4c-08ebb3f9bd77 | SMH | 2026-09-04 15:27 | call_diagonal_spread_bearish | 2 | 1 | 13 | 32760.00 | short | ask | 563.6200 | 1.9000 | ["555","575"] | ["0.2764","0.3122"] | [] | ["C2OX"] | 555.0000 | 575.0000 | 11 | 14 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:27:33Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06dcb-90cd-7f20-9ff1-e223e6dd0817 | SMH | 2026-09-04 15:00 | call_diagonal_spread_bearish | 2 | 1 | 5 | 28455.00 | short | bid | 564.8600 | 1.8500 | ["562.5","590"] | ["0.3249","0.3524"] | [] | ["AMXO"] | 562.5000 | 590.0000 | 28 | 105 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:01:26Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06dcb-7575-7753-9a04-c283a029f7e4 | SMH | 2026-09-04 15:00 | call_diagonal_spread_bearish | 2 | 1 | 5 | 28000.00 | long | ask | 564.8500 | 1.5000 | ["565","590"] | ["0.3275","0.3540"] | [] | ["AMXO"] | 565.0000 | 590.0000 | 28 | 105 | false | true | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:00:48Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d8e-c64d-7223-8bed-49a585f2eacc | SMH | 2026-09-04 13:54 | call_diagonal_spread_bearish | 2 | 1 | 4 | 32244.00 | long | ask | 564.1100 | 4.7000 | ["525","530"] | ["0.3291","0.3471"] | [] | ["EDGO"] | 525.0000 | 530.0000 | 5 | 21 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T17:54:42Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d6b-d8e6-72d1-9f9d-128df0d0d0ff | SMH | 2026-09-04 13:16 | call_diagonal_spread_bearish | 2 | 2 | 2 | 42762.00 | long | ask | 565.7300 | 5.7500 | ["460","470"] | ["0.5399","0.4050"] | [] | ["C2OX","EMLD"] | 460.0000 | 470.0000 | 14 | 77 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T17:16:28Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |