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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a091b1-db40-7411-9646-e23f1f1726eb | SOXX | 2026-09-11 14:19 | put_frontspread | 2 | 1 | 72 | 52164.00 | unknown | — | 529.7650 | 0.9500 | ["440","490"] | ["0.4452","0.3950"] | [] | ["EDGO"] | 440.0000 | 490.0000 | 35 | 35 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T18:19:45Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a091b1-bfe8-7551-829f-16dde0893f75 | SOXX | 2026-09-11 14:18 | put_frontspread | 2 | 1 | 100 | 72450.00 | unknown | — | 529.7650 | 0.9500 | ["440","490"] | ["0.4452","0.3950"] | [] | ["EDGO"] | 440.0000 | 490.0000 | 35 | 35 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T18:19:00Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a091b1-b048-75e3-8488-a5113fa734be | SOXX | 2026-09-11 14:18 | put_frontspread | 2 | 1 | 100 | 72500.00 | long | ask | 529.8100 | 0.9500 | ["440","490"] | ["0.4453","0.3955"] | ["394.22","485.78"] | ["EDGO"] | 440.0000 | 490.0000 | 35 | 35 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T18:19:00Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a091b1-a0a8-7cb3-b826-5d66f8f18264 | SOXX | 2026-09-11 14:18 | put_frontspread | 2 | 1 | 100 | 72450.00 | unknown | — | 529.7800 | 0.9500 | ["440","490"] | ["0.4452","0.3951"] | [] | ["EDGO"] | 440.0000 | 490.0000 | 35 | 35 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T18:19:00Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a091b1-94f0-7731-a23d-3b2deff83b05 | SOXX | 2026-09-11 14:18 | put_frontspread | 2 | 1 | 100 | 72450.00 | unknown | — | 529.7800 | 0.9500 | ["440","490"] | ["0.4452","0.3951"] | [] | ["EDGO"] | 440.0000 | 490.0000 | 35 | 35 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T18:19:00Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a091b1-8938-70d2-b4ad-5abbc0789418 | SOXX | 2026-09-11 14:18 | put_frontspread | 2 | 1 | 100 | 72500.00 | long | ask | 529.7800 | 0.9500 | ["440","490"] | ["0.4452","0.3953"] | ["394.22","485.78"] | ["EDGO"] | 440.0000 | 490.0000 | 35 | 35 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T18:19:00Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a091b1-7d80-7b42-af16-f6e5ef2b1034 | SOXX | 2026-09-11 14:18 | put_frontspread | 2 | 1 | 100 | 72550.00 | long | ask | 529.7800 | 0.9500 | ["440","490"] | ["0.4452","0.3955"] | ["394.23","485.77"] | ["EDGO"] | 440.0000 | 490.0000 | 35 | 35 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T18:19:00Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a091b1-71c8-7c51-a4a8-fbb63916ff43 | SOXX | 2026-09-11 14:18 | put_frontspread | 2 | 1 | 100 | 72550.00 | long | ask | 529.7500 | 0.9500 | ["440","490"] | ["0.4451","0.3954"] | ["394.23","485.77"] | ["EDGO"] | 440.0000 | 490.0000 | 35 | 35 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T18:19:00Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a091b1-6610-7b43-95bb-9f78e8ee2c1e | SOXX | 2026-09-11 14:18 | put_frontspread | 2 | 1 | 100 | 72600.00 | long | ask | 529.7500 | 0.9500 | ["440","490"] | ["0.4451","0.3956"] | ["394.24","485.76"] | ["EDGO"] | 440.0000 | 490.0000 | 35 | 35 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T18:19:00Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a091b1-5671-7db1-b6f2-68bd9879ec2b | SOXX | 2026-09-11 14:18 | put_frontspread | 2 | 1 | 100 | 72650.00 | long | ask | 529.7215 | 0.9500 | ["440","490"] | ["0.4450","0.3956"] | ["394.25","485.75"] | ["EDGO"] | 440.0000 | 490.0000 | 35 | 35 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T18:19:00Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a091b1-4ab9-7341-8261-348815a8c5bc | SOXX | 2026-09-11 14:18 | put_frontspread | 2 | 1 | 100 | 72550.00 | long | ask | 529.7400 | 0.9500 | ["440","490"] | ["0.4446","0.3957"] | ["394.27","485.73"] | ["EDGO"] | 440.0000 | 490.0000 | 35 | 35 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T18:19:00Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a091b1-2790-7a71-a75e-cf0c17314429 | SOXX | 2026-09-11 14:18 | put_frontspread | 2 | 1 | 100 | 72650.00 | long | ask | 529.8150 | 0.9500 | ["440","490"] | ["0.4453","0.3961"] | ["394.25","485.75"] | ["EDGO"] | 440.0000 | 490.0000 | 35 | 35 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T18:19:00Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a091b1-1408-71c1-8115-26db29997962 | SOXX | 2026-09-11 14:18 | put_frontspread | 2 | 1 | 100 | 72650.00 | long | ask | 529.8150 | 0.9500 | ["440","490"] | ["0.4453","0.3961"] | ["394.25","485.75"] | ["EDGO"] | 440.0000 | 490.0000 | 35 | 35 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T18:18:16Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a091b1-0c38-7eb3-b824-7273da729443 | SOXX | 2026-09-11 14:18 | put_frontspread | 2 | 1 | 100 | 72700.00 | long | ask | 529.8400 | 0.9500 | ["440","490"] | ["0.4454","0.3964"] | ["394.26","485.74"] | ["EDGO"] | 440.0000 | 490.0000 | 35 | 35 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T18:18:16Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a091b0-f4c8-7531-8657-4f4f0aeba5be | SOXX | 2026-09-11 14:18 | put_frontspread | 2 | 1 | 100 | 72600.00 | long | ask | 529.7500 | 0.9500 | ["440","490"] | ["0.4451","0.3956"] | ["394.24","485.76"] | ["EDGO"] | 440.0000 | 490.0000 | 35 | 35 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T18:18:16Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a091b0-ecf8-7b30-b1e3-d2bf83e7f8de | SOXX | 2026-09-11 14:18 | put_frontspread | 2 | 1 | 100 | 72500.00 | long | ask | 529.7850 | 0.9500 | ["440","490"] | ["0.4452","0.3953"] | ["394.22","485.78"] | ["EDGO"] | 440.0000 | 490.0000 | 35 | 35 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T18:18:16Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |