Simplify AnalyticsMulti-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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c51b-b99f-73d2-9077-57bc352564f1 | NOW | 2026-09-21 13:55 | put_vertical_spread | 2 | 1 | 50 | 312000.00 | unknown | — | 137.3950 | 1.0000 | ["160","162"] | ["0.5586","0.5605"] | [] | ["XCBO"] | 160.0000 | 162.0000 | 116 | 116 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T17:55:42Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a08cdf-63d0-7301-9b9b-41a0870d2fc2 | NOW | 2026-09-10 15:50 | put_vertical_spread | 2 | 1 | 417 | 951177.00 | unknown | — | 131.0900 | 0.7500 | ["141","144"] | ["0.6424","1.1422"] | [] | ["XCBO"] | 141.0000 | 144.0000 | 1 | 1 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:50:47Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08bbf-ab91-70c0-9a6e-9f18d7eee9cc | NOW | 2026-09-10 10:36 | put_vertical_spread | 2 | 1 | 417 | 267714.00 | unknown | — | 132.7350 | 0.2600 | ["129","132"] | ["0.5472","0.5438"] | [] | ["XCBO"] | 129.0000 | 132.0000 | 8 | 8 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T14:36:37Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08293-28d0-7170-a315-982fdeda0389 | NOW | 2026-09-08 15:51 | put_vertical_spread | 2 | 1 | 26 | 143546.00 | unknown | — | 134.1200 | 0.7500 | ["140","170"] | ["0.5754","0.5877"] | [] | ["XBOX"] | 140.0000 | 170.0000 | 73 | 73 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T19:51:21Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |