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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0a17b-8b21-7202-a750-f494b3ff263b | CDE | 2026-09-14 15:53 | put_vertical_spread | 2 | 1 | 80 | 104000.00 | unknown | — | 19.9400 | 1.0000 | ["26","26.5"] | ["0.9476","0.9956"] | [] | ["XCBO"] | 26.0000 | 26.5000 | 18 | 18 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T19:54:05Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a177-7c11-73e3-94c0-7cb3eae80d48 | CDE | 2026-09-14 15:49 | put_vertical_spread | 2 | 1 | 88 | 112288.00 | long | ask | 19.9350 | 0.5000 | ["26","26.5"] | ["0.8044","0.8168"] | ["26.02"] | ["XCBO"] | 26.0000 | 26.5000 | 18 | 18 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T19:49:49Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a177-39a8-7db1-bbf3-309f9fce65f1 | CDE | 2026-09-14 15:48 | put_vertical_spread | 2 | 1 | 80 | 102160.00 | long | ask | 19.9350 | 0.5000 | ["26","26.5"] | ["0.8044","0.8330"] | ["26.01"] | ["XCBO"] | 26.0000 | 26.5000 | 18 | 18 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T19:49:12Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a176-dbe8-7b72-ac27-c760c6e34a70 | CDE | 2026-09-14 15:48 | put_vertical_spread | 2 | 1 | 88 | 113432.00 | long | ask | 19.9350 | 1.0000 | ["26","26.5"] | ["0.8848","0.9184"] | ["26.01"] | ["XMIO"] | 26.0000 | 26.5000 | 18 | 18 | true | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T19:48:40Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a15d-1641-7041-9804-28f65a9e2a47 | CDE | 2026-09-14 15:20 | put_vertical_spread | 2 | 1 | 230 | 218500.00 | unknown | — | 20.0050 | 0.4000 | ["24.5","25"] | ["0.9368","1.0164"] | [] | ["XCBO"] | 24.5000 | 25.0000 | 4 | 4 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T19:21:04Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a15a-7278-73d3-8335-8f9bf52284ea | CDE | 2026-09-14 15:17 | put_vertical_spread | 2 | 1 | 181 | 208150.00 | unknown | — | 20.0200 | 0.8000 | ["25.5","26"] | ["1.2096","1.2896"] | [] | ["XCBO"] | 25.5000 | 26.0000 | 4 | 4 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T19:18:09Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |