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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c589-40af-7bd3-8865-716229765218 | AMD | 2026-09-21 15:54 | risk_reversal | 3 | 1 | 140 | 928200.00 | short | ask | 615.7600 | 2.3000 | ["500","615","720"] | ["0.5753","0.5760","0.5831"] | ["592.60"] | ["SPHR"] | 500.0000 | 720.0000 | 39 | 39 | false | true | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T19:55:03Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c46f-31a7-7273-aa29-8557f96d44f7 | AMD | 2026-09-21 10:46 | risk_reversal | 2 | 1 | 100 | 2372500.00 | short | ask | 612.0000 | 6.0500 | ["670","720"] | ["0.5991","0.5793"] | ["613.45"] | ["XBOX"] | 670.0000 | 720.0000 | 269 | 269 | false | false | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T14:47:04Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b00c-5d4b-76d1-9639-d5c8a1126604 | AMD | 2026-09-17 11:46 | risk_reversal | 2 | 1 | 400 | 2755200.00 | short | bid | 545.8384 | 3.6500 | ["420","650"] | ["0.5616","0.5585"] | ["674.92"] | ["XBOX"] | 420.0000 | 650.0000 | 155 | 155 | false | true | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T15:46:47Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0a699-956d-7ac1-addf-2152b2402638 | AMD | 2026-09-15 15:44 | risk_reversal | 2 | 2 | 100 | 601400.00 | short | ask | 504.5100 | 1.6000 | ["400","900"] | ["0.5454","0.5717"] | ["384.10"] | ["ARCO"] | 400.0000 | 900.0000 | 275 | 275 | false | true | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:45:02Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a08c88-4320-7f32-b6cc-9ef1b61d91da | AMD | 2026-09-10 14:15 | risk_reversal | 2 | 1 | 71 | 27051.00 | unknown | — | 506.6400 | 0.3900 | ["440","590"] | ["0.5213","0.5068"] | [] | ["XBOX"] | 440.0000 | 590.0000 | 15 | 15 | false | true | false | true | true | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:16:10Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |