Simplify AnalyticsMulti-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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b0c6-5a93-7081-89d4-a3e6f6a5d395 | ORCL | 2026-09-17 15:09 | strangle | 2 | 1 | 25 | 62850.00 | unknown | — | 148.8150 | 0.6000 | ["140","165"] | ["0.7764","1.1019"] | [] | ["XMIO"] | 140.0000 | 165.0000 | 1 | 1 | false | false | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:10:21Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0a69f-793e-72f2-8058-a11b7d12cddf | ORCL | 2026-09-15 15:51 | strangle | 2 | 1 | 27 | 530901.00 | long | ask | 140.1650 | 1.9000 | ["180","310"] | ["0.5508","0.7669"] | ["113.37","376.63"] | ["EDGO"] | 180.0000 | 310.0000 | 493 | 493 | false | false | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:51:26Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a120-9dc8-7160-99ad-15e9a04cb797 | ORCL | 2026-09-14 14:14 | strangle | 2 | 1 | 4 | 25084.00 | long | ask | 144.2800 | 0.9000 | ["150","180"] | ["0.5680","0.5702"] | ["87.29","242.71"] | ["XMIO"] | 150.0000 | 180.0000 | 459 | 459 | false | false | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T18:14:55Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a08cc1-3928-7cd1-9646-7603655fb99d | ORCL | 2026-09-10 15:17 | strangle | 2 | 1 | 150 | 245100.00 | long | ask | 154.6800 | 0.3500 | ["150","180"] | ["0.6895","0.7134"] | ["133.66","196.34"] | ["XISX"] | 150.0000 | 180.0000 | 36 | 36 | false | true | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:17:47Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c48-0da0-7672-a9c2-bd0834e8521b | ORCL | 2026-09-10 13:05 | strangle | 2 | 1 | 10 | 26330.00 | short | bid | 156.6700 | 1.1000 | ["155","160"] | ["0.6766","0.6662"] | ["128.67","186.33"] | ["XMIO"] | 155.0000 | 160.0000 | 43 | 43 | false | true | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T17:05:28Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |