core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
Simplify Analyticsuw_multileg473,794 rowsexportable| idtext | tickertext | executed_at ↓timestamp with time zone | strategytext | leg_countinteger | txnsinteger | sizebigint | total_premiumnumeric | directiontext | net_side |
|---|
| 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 |
|---|
| 01a09184-bc78-7a12-89e0-f7fd83b553cb | DAVE | 2026-09-11 13:29 | strangle | 2 | 1 | 10 | 153500.00 | short | bid | 356.5200 | 5.1000 | ["350","660"] | ["0.7227","0.6928"] | ["196.50","813.50"] | ["XCBO"] | 350.0000 | 660.0000 | 497 | 497 | false | true | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T17:30:02Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a09181-8058-72e1-b03e-02b257ea5e91 | DAVE | 2026-09-11 13:26 | strangle | 2 | 1 | 10 | 153800.00 | short | bid | 357.0100 | 9.7000 | ["350","660"] | ["0.7215","0.6955"] | ["196.20","813.80"] | ["XCBO"] | 350.0000 | 660.0000 | 497 | 497 | false | true | false | true | true | ||||||||
| 01a08cad-ad40-7202-a437-59cdfbba4808 | DAVE | 2026-09-10 14:56 | other | 3 | 1 | 5 | 116440.00 | unknown | — | 356.0800 | 8.7000 | ["350","660"] | ["0.7318","0.6928"] | [] | ["XCBO"] | 350.0000 | 660.0000 | 280 | 498 | false | true | true | true | true | mlat | |||||||
| 01a08c9f-d260-7a62-9811-65363f0cd7c4 | DAVE | 2026-09-10 14:41 | other | 3 | 1 | 5 | 116835.00 | unknown | — | 355.5600 | 15.9000 | ["350","660"] | ["0.7337","0.6944"] | [] | ["XCBO"] | 350.0000 | 660.0000 | 280 | 498 | false | true | true | true | true | mlat | |||||||
| 01a08c8d-6788-71b1-9c62-2194e8718731 | DAVE | 2026-09-10 14:21 | strangle | 2 | 1 | 9 | 138240.00 | short | bid | 357.5800 | 7.8000 | ["350","660"] | ["0.7343","0.6898"] | ["196.40","813.60"] | ["XPHO"] | 350.0000 | 660.0000 | 498 | 498 | false | true | false | true | true |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T17:26:56Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T18:56:25Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T18:41:19Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T18:21:45Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |