Multi-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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c57b-0fdf-7d23-8ea2-e5dd01d01844 | AMZN | 2026-09-21 15:39 | call_vertical_spread | 2 | 1 | 100 | 110100.00 | unknown | ask | 259.0905 | 0.5000 | ["280","285"] | ["0.3938","0.3921"] | ["288.00"] | ["SPHR"] | 280.0000 | 285.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:39:33Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c465-8130-79c1-b471-10561bf0a354 | AMZN | 2026-09-21 10:36 | call_vertical_spread | 2 | 1 | 100 | 77400.00 | short | bid | 255.7450 | 0.3800 | ["300","320"] | ["0.3517","0.3570"] | ["302.40"] | ["SPHR"] | 300.0000 | 320.0000 | 88 | 88 | false | true | false | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T14:36:33Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a09206-63e0-7651-88f7-75e7096478f6 | AMZN | 2026-09-11 15:51 | call_vertical_spread | 2 | 1 | 984 | 91512.00 | unknown | — | 257.0100 | 0.0700 | ["300","310"] | ["0.3068","0.3120"] | [] | ["XBOX"] | 300.0000 | 310.0000 | 35 | 35 | false | true | false | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:51:44Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a090d8-e060-7262-9b92-234ac0eac653 | AMZN | 2026-09-11 10:22 | call_vertical_spread | 2 | 2 | 200 | 499200.00 | unknown | — | 256.6100 | 0.6000 | ["280","320"] | ["0.3664","0.3644"] | [] | ["SPHR"] | 280.0000 | 320.0000 | 161 | 161 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T14:22:26Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a086d4-54f1-7402-8f58-ef7e20d7947f | AMZN | 2026-09-09 11:40 | call_vertical_spread | 2 | 1 | 124 | 35712.00 | short | bid | 251.3850 | 0.0600 | ["252.5","257.5"] | ["0.3599","0.3623"] | ["253.98"] | ["SPHR"] | 252.5000 | 257.5000 | 2 | 2 | false | true | false | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T15:41:34Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |