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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b60e-76f0-7150-a376-2c2286b63a3f | COST | 2026-09-18 15:46 | call_diagonal_spread | 2 | 1 | 4 | 156684.00 | short | ask | 896.7700 | 9.7000 | ["700","740"] | ["21.6879","0.2544"] | [] | ["XPHO"] | 700.0000 | 740.0000 | 0 | 272 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:46:48Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b574-84c7-7a91-8b19-704d88548456 | COST | 2026-09-18 12:58 | call_diagonal_spread | 2 | 1 | 2 | 101746.00 | short | bid | 897.7500 | 15.2000 | ["520","860"] | ["0.2310","0.2283"] | [] | ["XCBO"] | 520.0000 | 860.0000 | 119 | 854 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:58:35Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0aad1-ae2b-71b1-929e-ed22122adb36 | COST | 2026-09-16 11:24 | call_diagonal_spread | 2 | 1 | 100 | 195148.00 | long | bid | 900.6293 | 1.9500 | ["920","930"] | ["0.3079","0.2706"] | [] | ["XCBO"] | 920.0000 | 930.0000 | 9 | 16 | false | true | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T15:25:02Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a59b-ccae-7512-a436-97c19e5062fb | COST | 2026-09-15 11:07 | call_diagonal_spread | 2 | 1 | 3 | 250656.00 | unknown | — | 908.3530 | 17.0000 | ["520","560"] | ["0.2901","0.2685"] | [] | ["XCBO"] | 520.0000 | 560.0000 | 493 | 822 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T15:07:32Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a59b-43f6-7c61-80e9-7458e7c7ce78 | COST | 2026-09-15 11:06 | call_diagonal_spread | 2 | 1 | 6 | 501306.00 | unknown | — | 908.5000 | 17.0000 | ["520","560"] | ["0.2873","0.2675"] | [] | ["XCBO"] | 520.0000 | 560.0000 | 493 | 822 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T15:06:52Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a080-1bf0-7213-80bb-5d5011f80a92 | COST | 2026-09-14 11:19 | call_diagonal_spread | 2 | 1 | 34 | 109480.00 | short | bid | 917.9000 | 4.5000 | ["910","925"] | ["0.2247","0.2624"] | [] | ["XPHO"] | 910.0000 | 925.0000 | 4 | 18 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T15:19:03Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0869f-8d38-7781-a905-b64309bc685b | COST | 2026-09-09 10:43 | call_diagonal_spread | 2 | 1 | 23 | 1386348.00 | short | ask | 904.2450 | 14.1000 | ["600","620"] | ["0.9229","0.2283"] | [] | ["ARCO"] | 600.0000 | 620.0000 | 9 | 191 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:43:47Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0868f-4158-7bc2-8dbb-2e0307d0826a | COST | 2026-09-09 10:25 | call_diagonal_spread | 2 | 2 | 6 | 189954.00 | long | ask | 903.5000 | 13.6000 | ["760","820"] | ["0.2847","0.2530"] | [] | ["AMXO"] | 760.0000 | 820.0000 | 100 | 373 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:25:36Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |