Multi-leg option trades
core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
312,778 rowsCSV — whole table, not this view
Sources in this table
uw_multileg312,778 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b616-1bf7-7b41-bb2d-ba1653eeabfa | SPCX | 2026-09-18 15:54 | put_ratio_spread | 2 | 1 | 120 | 47520.00 | unknown | — | 152.5500 | 0.2800 | ["115","145"] | ["0.5612","0.5018"] | [] | ["XPHO"] | 115.0000 | 145.0000 | 42 | 42 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:55:01Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b60e-a9b7-7601-b465-e1f8e0b0eb7f | SPCX | 2026-09-18 15:46 | put_ratio_spread | 2 | 1 | 46 | 26588.00 | unknown | bid | 152.7350 | 0.1900 | ["110","145"] | ["0.5792","0.5373"] | ["133.44"] | ["AMXO"] | 110.0000 | 145.0000 | 63 | 63 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:46:48Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b59d-7d0f-7101-8460-b31b8b5c7dc2 | SPCX | 2026-09-18 13:43 | put_ratio_spread | 2 | 1 | 100 | 70900.00 | unknown | bid | 152.1500 | 0.2000 | ["110","150"] | ["0.5842","0.5327"] | ["135.82"] | ["EDGO"] | 110.0000 | 150.0000 | 63 | 63 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:43:46Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4c6-e778-74f0-be40-87b2abf4130f | SPCX | 2026-09-18 09:48 | put_ratio_spread | 2 | 1 | 200 | 75100.00 | unknown | — | 153.6400 | 0.3500 | ["115","145"] | ["0.5680","0.5014"] | [] | ["EDGO"] | 115.0000 | 145.0000 | 42 | 42 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T13:48:59Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |