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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0a5aa-248e-70e0-bbfd-af060b6b7b91 | DELL | 2026-09-15 11:23 | put_frontspread | 2 | 1 | 16 | 39872.00 | long | ask | 553.4400 | 2.5000 | ["400","500"] | ["0.6715","0.6530"] | ["317.68","482.32"] | ["EDGO"] | 400.0000 | 500.0000 | 66 | 66 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T15:23:35Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a09164-24b8-7580-89ef-488423cc73a8 | DELL | 2026-09-11 12:54 | put_frontspread | 2 | 1 | 2 | 46029.00 | unknown | — | 558.7550 | 5.7500 | ["400","720"] | ["0.7094","0.7325"] | [] | ["XPHO"] | 400.0000 | 720.0000 | 644 | 644 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T16:54:13Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a09163-fda9-7b53-bfd3-540b2c832e66 | DELL | 2026-09-11 12:54 | put_frontspread | 2 | 1 | 2 | 46086.00 | long | ask | 558.1900 | 5.6000 | ["400","720"] | ["0.7091","0.7334"] | ["189","611"] | ["ARCO"] | 400.0000 | 720.0000 | 644 | 644 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T16:54:13Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a090dd-1680-7d62-b12a-92a354e7677a | DELL | 2026-09-11 10:26 | put_frontspread | 2 | 1 | 200 | 39300.00 | long | ask | 564.2150 | 0.3900 | ["470","505"] | ["0.7099","0.6666"] | ["436.49","503.51"] | ["AMXO"] | 470.0000 | 505.0000 | 7 | 7 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T14:26:49Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08c2d-f208-78b3-bc44-ed98063531eb | DELL | 2026-09-10 12:36 | put_frontspread | 2 | 1 | 2 | 31901.00 | long | ask | 514.3400 | 5.5500 | ["390","670"] | ["0.6891","0.7061"] | ["227.05","552.95"] | ["AMXO"] | 390.0000 | 670.0000 | 280 | 280 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T16:37:26Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a06d96-964d-7950-891a-cfb4d9cb53b1 | DELL | 2026-09-04 14:02 | put_frontspread | 2 | 8 | 40 | 64650.00 | long | ask | 526.4525 | 0.5775 | ["505","525"] | ["0.5880","0.5905"] | ["485.15","524.85"] | ["ARCO","BATO","C2OX","EDGO","EMLD","SPHR","XBOX","XPHO"] | 505.0000 | 525.0000 | 7 | 7 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T18:03:22Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |