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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a08139-5978-76a2-97a5-771a7d3108bd | VRTX | 2026-09-08 09:33 | put_vertical_spread | 2 | 1 | 15 | 104025.00 | long | ask | 523.2050 | 16.5000 | ["550","565"] | ["0.4003","0.4717"] | ["550.43"] | ["XMIO"] | 550.0000 | 565.0000 | 3 | 3 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T13:33:47Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08244-f160-7500-88db-78aa4eb857b5 | VRTX | 2026-09-08 14:25 | call_vertical_spread | 2 | 1 | 10 | 379600.00 | long | ask | 529.4000 | 14.0000 | ["340","350"] | ["0.4769","0.4649"] | ["349.62"] | ["XMIO"] | 340.0000 | 350.0000 | 101 | 101 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T18:26:06Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a0ab70-5373-7e42-82d6-3389ba78310f | VRTX | 2026-09-16 14:17 | call_vertical_spread | 2 | 1 | 20 | 152300.00 | long | ask | 514.7500 | 12.3000 | ["500","520"] | ["0.3230","0.3113"] | ["511.43"] | ["XMIO"] | 500.0000 | 520.0000 | 93 | 93 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T18:18:10Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0b4f4-3908-70f2-a71b-844e2f6053c5 | VRTX | 2026-09-18 10:38 | call_vertical_spread | 2 | 1 | 2 | 126788.00 | short | bid | 508.1351 | 12.3000 | ["190","195"] | ["20.0356","19.5455"] | ["195"] | ["XCBO"] | 190.0000 | 195.0000 | 0 | 0 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:38:37Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |