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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c56f-e47f-7970-ae05-19ad5cca4ba0 | DRAM | 2026-09-21 15:27 | call_vertical_spread | 2 | 1 | 515 | 136990.00 | long | ask | 61.6700 | 0.1200 | ["70","80"] | ["0.5927","0.6031"] | ["71.40"] | ["SPHR"] | 70.0000 | 80.0000 | 39 | 39 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T19:27:47Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0866f-1ae0-79b1-b336-52f0ca3bf3c8 | DRAM | 2026-09-09 09:50 | call_vertical_spread | 2 | 1 | 2240 | 1012480.00 | long | ask | 61.6450 | 0.3500 | ["67","80"] | ["0.7005","0.7102"] | ["69.50"] | ["SPHR"] | 67.0000 | 80.0000 | 37 | 37 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T13:50:32Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08276-f9f9-7763-af5f-908881335399 | DRAM | 2026-09-08 15:20 | call_vertical_spread | 2 | 1 | 600 | 2539200.00 | unknown | — | 61.5399 | 2.2000 | ["55","62"] | ["0.6821","0.6719"] | [] | ["XBOX"] | 55.0000 | 62.0000 | 500 | 500 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T19:20:35Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a0813e-79f8-7f31-8b55-3ab0dfe38de0 | DRAM | 2026-09-08 09:39 | call_vertical_spread | 2 | 1 | 1980 | 696960.00 | unknown | — | 61.6100 | 0.0600 | ["61","62"] | ["0.7474","0.7648"] | [] | ["AMXO"] | 61.0000 | 62.0000 | 3 | 3 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T13:39:22Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a06dc5-5325-7010-80ab-0c57a759c62b | DRAM | 2026-09-04 14:54 | call_vertical_spread | 2 | 1 | 2500 | 1465000.00 | unknown | — | 59.1300 | 0.9100 | ["75","81"] | ["0.6427","0.6356"] | [] | ["SPHR"] | 75.0000 | 81.0000 | 105 | 105 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T18:54:05Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |