Multi-leg option trades
core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
312,778 rowsCSV — whole table, not this view
Sources in this table
uw_multileg312,778 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b0ca-f25b-7d32-8d3e-243a494ec4e0 | BE | 2026-09-17 15:14 | call_vertical_spread | 2 | 1 | 300 | 1028700.00 | short | bid | 279.9950 | 2.3500 | ["262.5","265"] | ["1.0212","0.9612"] | ["264.85"] | ["SPHR"] | 262.5000 | 265.0000 | 1 | 1 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:15:07Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0af9c-9fd3-7d11-8e88-980af04d69b6 | BE | 2026-09-17 09:44 | call_vertical_spread | 2 | 1 | 127 | 220599.00 | short | bid | 282.0850 | 1.4600 | ["280","330"] | ["0.8295","0.9005"] | ["292.53"] | ["AMXO"] | 280.0000 | 330.0000 | 8 | 8 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T13:44:38Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0a049-7f78-7ea0-b1ff-cee47163ca15 | BE | 2026-09-14 10:19 | call_vertical_spread | 2 | 1 | 500 | 838000.00 | unknown | — | 261.3000 | 0.8600 | ["290","370"] | ["0.7858","0.8303"] | [] | ["AMXO"] | 290.0000 | 370.0000 | 32 | 32 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T14:19:39Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a08271-f4d0-7063-ad89-f3ea4732ca5b | BE | 2026-09-08 15:14 | call_vertical_spread | 2 | 1 | 125 | 687250.00 | short | bid | 281.9950 | 1.3500 | ["250","280"] | ["0.8895","0.9215"] | ["268.50"] | ["SPHR"] | 250.0000 | 280.0000 | 10 | 10 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T19:15:09Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |