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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b609-c7b7-7922-901c-e15b79d74457 | HOOD | 2026-09-18 15:41 | call_diagonal_spread | 2 | 1 | 40 | 190600.00 | short | bid | 119.4400 | 0.5000 | ["103","105"] | ["0.6172","0.6654"] | [] | ["C2OX"] | 103.0000 | 105.0000 | 35 | 154 | false | false | true | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:41:32Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4cc-1f67-7ac0-b495-644f7d4b22a4 | HOOD | 2026-09-18 09:54 | put_vertical_spread | 2 | 1 | 500 | 377500.00 | unknown | bid | 114.9700 | 0.3000 | ["108","109"] | ["0.6191","0.6172"] | ["104.72"] | ["XISX"] | 108.0000 | 109.0000 | 21 | 21 | true | true | false | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T13:54:30Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b088-7ea3-7273-bd51-1d2ff4f2c552 | HOOD | 2026-09-17 14:02 | other | 4 | 1 | 33 | 101244.00 | unknown | — | 107.3800 | 0.5100 | ["100","120"] | ["0.7088","0.8143"] | [] | ["XISX"] | 100.0000 | 120.0000 | 1 | 64 | false | false | true | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:02:43Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0abaf-8ef3-7e61-abee-7c4462fd8e23 | HOOD | 2026-09-16 15:26 | call_vertical_spread | 2 | 1 | 30 | 165900.00 | unknown | — | 101.7800 | 1.9000 | ["170","180"] | ["0.6781","0.6776"] | [] | ["XISX"] | 170.0000 | 180.0000 | 856 | 856 | false | true | false | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:26:54Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab06-5e73-78d3-b3f2-8e402cd4c9a0 | HOOD | 2026-09-16 12:21 | strangle_swap | 4 | 1 | 94 | 104528.00 | unknown | — | 105.1744 | 0.2800 | ["100","110"] | ["0.6353","0.6340"] | [] | ["ARCO"] | 100.0000 | 110.0000 | 9 | 16 | false | true | true | true | true | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T16:22:44Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a08a-4199-77c1-b0c5-b3e89ab3f7b2 | HOOD | 2026-09-14 11:30 | call_diagonal_spread | 2 | 1 | 30 | 149910.00 | long | bid | 113.9068 | 0.6600 | ["85","95"] | ["1.5897","0.6617"] | [] | ["XCBO"] | 85.0000 | 95.0000 | 4 | 32 | false | false | true | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T15:30:30Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a08c59-cc98-7b52-b30f-70f53b9efa3b | HOOD | 2026-09-10 13:24 | put_vertical_spread | 2 | 1 | 40 | 123000.00 | unknown | — | 114.6700 | 0.7000 | ["125","135"] | ["0.9169","1.3645"] | [] | ["XISX"] | 125.0000 | 135.0000 | 1 | 1 | false | false | false | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T17:24:55Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |