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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c583-6c7f-7451-8c57-d05405fed872 | VLO | 2026-09-21 15:48 | put_vertical_spread | 2 | 3 | 43 | 142991.00 | unknown | ask | 394.3440 | 4.3349 | ["400","410"] | ["0.6243","0.6204"] | ["388.37"] | ["BATO","C2OX","XCBO"] | 400.0000 | 410.0000 | 4 | 4 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T19:48:54Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c571-01a7-7281-a69c-4c8151fe47a7 | VLO | 2026-09-21 15:28 | put_vertical_spread | 2 | 9 | 264 | 371546.00 | long | ask | 393.3850 | 1.7163 | ["375","395"] | ["0.6389","0.5956"] | ["387.99"] | ["AMXO","EDGO","XBOX","XCBO","XISX","XMIO","XPHO"] | 375.0000 | 395.0000 | 4 | 4 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T19:28:50Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0abbc-d17b-7b71-83e8-e4cfee2930a0 | VLO | 2026-09-16 15:41 | put_vertical_spread | 2 | 3 | 23 | 125797.00 | long | ask | 405.1200 | 5.2000 | ["400","405"] | ["0.5312","0.5301"] | ["402.51"] | ["ARCO","EMLD","SPHR"] | 400.0000 | 405.0000 | 44 | 44 | true | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:41:14Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a08212-0639-7250-95b0-c4a6844e439e | VLO | 2026-09-08 13:30 | put_vertical_spread | 2 | 1 | 100 | 105000.00 | unknown | — | 381.5750 | 1.1000 | ["360","370"] | ["0.4780","0.4706"] | [] | ["XISX"] | 360.0000 | 370.0000 | 10 | 10 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T17:30:59Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |