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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a06dba-896d-7b30-884a-ab16fb78c0b8 | SMH | 2026-09-04 14:42 | call_ratio_spread | 2 | 1 | 54 | 158724.00 | long | ask | 564.8000 | 1.9500 | ["560","610"] | ["0.3342","0.3255"] | ["574.29","681.42"] | ["AMXO"] | 560.0000 | 610.0000 | 42 | 42 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T18:42:17Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06df1-54c5-75d3-8ed1-08a990dd248e | SMH | 2026-09-04 15:42 | call_ratio_spread | 2 | 1 | 60 | 186020.00 | long | ask | 565.3500 | 2.6000 | ["550","600"] | ["0.3413","0.3326"] | ["559.14","640.86"] | ["XMIO"] | 550.0000 | 600.0000 | 42 | 42 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:42:09Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a081bd-e710-7f63-81c5-57e9af4104df | SMH | 2026-09-08 11:58 | call_ratio_spread | 2 | 1 | 38 | 84816.00 | long | ask | 577.8500 | 2.1500 | ["805","860"] | ["0.3598","0.3589"] | ["921.84"] | ["AMXO"] | 805.0000 | 860.0000 | 282 | 282 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T15:58:58Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a0a55e-8916-7333-9c33-77c53b5dbcc2 | SMH | 2026-09-15 10:00 | call_ratio_spread | 2 | 2 | 68 | 48144.00 | long | ask | 546.7400 | 0.4750 | ["580","610"] | ["0.3087","0.3058"] | ["582.40","637.60"] | ["XISX","XPHO"] | 580.0000 | 610.0000 | 31 | 31 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:00:33Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a59d-999e-7d52-b89b-c3c7032c9351 | SMH | 2026-09-15 11:09 | call_ratio_spread | 2 | 1 | 1500 | 15412000.00 | unknown | — | 542.8200 | 7.8000 | ["560","760"] | ["0.3654","0.3483"] | [] | ["ARCO"] | 560.0000 | 760.0000 | 493 | 493 | true | true | false | true | false | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T15:09:44Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a624-368e-7d10-b432-30faedb5c179 | SMH | 2026-09-15 13:36 | call_ratio_spread | 2 | 1 | 4 | 59394.00 | unknown | — | 540.9850 | 3.9500 | ["430","540"] | ["0.3919","0.3489"] | [] | ["AMXO"] | 430.0000 | 540.0000 | 122 | 122 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:36:52Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a681-71bd-7163-bba4-3d163497c8ae | SMH | 2026-09-15 15:18 | call_ratio_spread | 2 | 1 | 6 | 50184.00 | long | ask | 541.5700 | 7.1000 | ["800","850"] | ["0.3577","0.3562"] | ["943.40"] | ["XCBO"] | 800.0000 | 850.0000 | 822 | 822 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:18:41Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0afe2-a59a-7991-897c-3e03d14e833f | SMH | 2026-09-17 11:00 | call_ratio_spread | 2 | 1 | 39 | 38688.00 | unknown | — | 559.1000 | 0.4000 | ["595","620"] | ["0.3148","0.3123"] | [] | ["EDGO"] | 595.0000 | 620.0000 | 29 | 29 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T15:01:29Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afe2-a59a-7991-897c-3dfabeaa62d2 | SMH | 2026-09-17 11:00 | call_ratio_spread | 2 | 1 | 36 | 35784.00 | unknown | — | 559.1000 | 0.3500 | ["595","620"] | ["0.3150","0.3127"] | [] | ["EDGO"] | 595.0000 | 620.0000 | 29 | 29 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T15:01:29Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b054-ef6b-7cf2-a940-da3e0fc75ba1 | SMH | 2026-09-17 13:05 | call_ratio_spread | 2 | 1 | 12 | 25710.00 | unknown | — | 561.0900 | 1.3000 | ["560","585"] | ["0.3146","0.3098"] | [] | ["EMLD"] | 560.0000 | 585.0000 | 29 | 29 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T17:06:11Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b4d8-f877-7142-8090-b633bd8db0f2 | SMH | 2026-09-18 10:08 | call_ratio_spread | 2 | 2 | 1000 | 1653500.00 | unknown | bid | 564.4400 | 1.9500 | ["565","600"] | ["0.3048","0.2968"] | ["598.07"] | ["AMXO"] | 565.0000 | 600.0000 | 28 | 28 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:08:42Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b619-8adf-7530-ae33-1e6c078ab346 | SMH | 2026-09-18 15:58 | call_ratio_spread | 2 | 2 | 200 | 43940.00 | unknown | ask | 572.4150 | 0.3900 | ["575","582.5"] | ["0.1842","0.1892"] | ["579.39"] | ["EDGO","XBOX"] | 575.0000 | 582.5000 | 3 | 3 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:58:52Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |