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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b605-3ba7-7973-9fe6-3725cea6726a | NOW | 2026-09-18 15:36 | other | 4 | 1 | 304 | 103056.00 | unknown | — | 136.4400 | 0.2000 | ["137","140","142","145"] | ["0.9284","0.4825","2.6370","0.5007"] | [] | ["XCBO"] | 137.0000 | 145.0000 | 0 | 7 | false | true | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:36:31Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b54d-8c37-7930-a0f0-b504c76eaa77 | NOW | 2026-09-18 12:15 | other | 3 | 1 | 500 | 157500.00 | unknown | ask | 136.6950 | 0.1200 | ["140","145","175"] | ["0.7582","1.3126","0.5777"] | [] | ["XPHO"] | 140.0000 | 175.0000 | 0 | 63 | false | true | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:16:26Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b004-a0d3-7560-afda-01d226c0a9ec | NOW | 2026-09-17 11:38 | other | 4 | 1 | 416 | 291616.00 | unknown | — | 139.3500 | 0.4000 | ["129","132","136","139"] | ["0.7535","0.6644","0.5283","0.5224"] | [] | ["XCBO"] | 129.0000 | 139.0000 | 1 | 8 | false | true | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T15:38:11Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a091ef-74c8-7f33-9695-aa1300e44a28 | NOW | 2026-09-11 15:26 | other | 2 | 1 | 123 | 147477.00 | unknown | — | 133.0290 | 0.4300 | ["125","130"] | ["0.4994","1.9998"] | [] | ["XMIO"] | 125.0000 | 130.0000 | 0 | 7 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:26:28Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a091cf-7d31-7571-948f-81d9f819592b | NOW | 2026-09-11 14:51 | other | 3 | 1 | 200 | 129700.00 | unknown | — | 132.8200 | 0.4400 | ["130","132","134"] | ["0.4979","0.4980","0.4975"] | [] | ["XMIO"] | 130.0000 | 134.0000 | 7 | 7 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T18:52:07Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08715-0b58-77a2-a454-f4424a84b971 | NOW | 2026-09-09 12:51 | other | 4 | 1 | 345 | 134205.00 | unknown | — | 131.2000 | 0.2200 | ["137","142","148"] | ["0.5549","0.6379","0.7914"] | [] | ["XCBO"] | 137.0000 | 148.0000 | 2 | 9 | false | true | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T16:51:58Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |