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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0ab61-6723-7e81-b681-cbf37e4fdeca | BNY | 2026-09-16 14:01 | call_diagonal_spread | 2 | 1 | 473 | 1489950.00 | short | ask | 155.7100 | 5.1000 | ["140","145"] | ["1.1123","0.2508"] | [] | ["XMIO"] | 140.0000 | 145.0000 | 2 | 93 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T18:01:24Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a632-4c06-7b33-a5c8-e2c69326d051 | BNY | 2026-09-15 13:51 | call_diagonal_spread | 2 | 1 | 17 | 257618.00 | unknown | — | 154.9300 | 6.5000 | ["80","90"] | ["0.4361","0.2453"] | [] | ["XISX"] | 80.0000 | 90.0000 | 493 | 857 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:52:13Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0813a-e018-7dd2-a9f3-35d50758b6f2 | BNY | 2026-09-08 09:35 | call_diagonal_spread | 2 | 1 | 57 | 524115.00 | unknown | — | 164.4250 | 4.3000 | ["115","125"] | ["0.4807","0.2771"] | [] | ["XISX"] | 115.0000 | 125.0000 | 101 | 129 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T13:35:22Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |