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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c4fe-f656-7961-a1ef-c48b61a45b76 | XLF | 2026-09-21 13:23 | strangle | 2 | 1 | 1750 | 794500.00 | unknown | — | 56.0250 | 0.0600 | ["55","60"] | ["0.1914","0.1591"] | [] | ["XCBO"] | 55.0000 | 60.0000 | 269 | 269 | false | true | false | true | true | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T17:23:59Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0abbf-e2a3-7a62-8b78-b4423912bd33 | XLF | 2026-09-16 15:44 | put_vertical_spread | 2 | 1 | 2000 | 960000.00 | unknown | — | 55.6750 | 0.8000 | ["40","52"] | ["0.2702","0.2325"] | [] | ["ARCO"] | 40.0000 | 52.0000 | 821 | 821 | false | true | false | true | false | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:44:59Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aac5-0fb3-7e61-90ac-030e9cfe5c65 | XLF | 2026-09-16 11:10 | put_vertical_spread | 2 | 1 | 5250 | 651000.00 | unknown | — | 56.6600 | 0.0500 | ["55","56"] | ["0.1867","0.1742"] | [] | ["AMXO"] | 55.0000 | 56.0000 | 30 | 30 | false | true | false | true | false | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T15:11:05Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aaa7-620a-7c33-ab2a-7c66a4c27ddd | XLF | 2026-09-16 10:38 | put_vertical_spread | 2 | 1 | 3000 | 240000.00 | unknown | — | 56.6300 | 0.1500 | ["56","57"] | ["0.2344","0.2674"] | [] | ["AMXO"] | 56.0000 | 57.0000 | 2 | 2 | false | false | false | true | false | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T14:38:31Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a651-70ae-7101-9e55-ca6e7e9eb83b | XLF | 2026-09-15 14:25 | other | 4 | 1 | 3000 | 354000.00 | unknown | — | 56.6400 | 0.0700 | ["55","56","58","59"] | ["0.1851","0.2000","0.1461","0.2516"] | [] | ["ARCO"] | 55.0000 | 59.0000 | 3 | 31 | false | true | true | true | true | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T18:26:47Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a156-4040-7260-b1b3-f040c3d06a74 | XLF | 2026-09-14 15:12 | strangle | 2 | 1 | 2000 | 2510000.00 | unknown | — | 56.9350 | 2.3000 | ["53","56"] | ["0.2082","0.1929"] | [] | ["ARCO"] | 53.0000 | 56.0000 | 823 | 823 | false | false | false | true | true | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T19:13:20Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a109-b680-7412-bc47-f6253b3364c6 | XLF | 2026-09-14 13:49 | strangle | 2 | 1 | 8600 | 430000.00 | unknown | — | 56.8499 | 0.0800 | ["57","60"] | ["0.1785","0.2447"] | [] | ["SPHR"] | 57.0000 | 60.0000 | 4 | 4 | false | false | false | true | true | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T17:50:01Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a09203-75e0-7701-9b9b-e2453f836893 | XLF | 2026-09-11 15:48 | strangle | 2 | 1 | 5000 | 135000.00 | unknown | — | 57.2499 | 0.0300 | ["56","58"] | ["0.1607","0.1367"] | [] | ["AMXO"] | 56.0000 | 58.0000 | 7 | 7 | false | true | false | true | true | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:48:33Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a091c5-1521-70b3-b9e5-ab285df168a7 | XLF | 2026-09-11 14:40 | other | 2 | 1 | 1000 | 130000.00 | unknown | — | 57.2150 | 0.0700 | ["57"] | ["0.1534"] | [] | ["ARCO"] | 57.0000 | 57.0000 | 7 | 35 | false | true | true | false | false | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T18:40:18Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a091b2-8ef1-7620-8530-af72cb42314a | XLF | 2026-09-11 14:19 | other | 3 | 1 | 49500 | 5709000.00 | unknown | — | 57.3050 | 0.1500 | ["56","58"] | ["0.1729","0.1491"] | [] | ["AMXO"] | 56.0000 | 58.0000 | 7 | 35 | false | false | true | true | false | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T18:20:10Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a091b2-5070-7c30-92d0-09c47ccf6bcc | XLF | 2026-09-11 14:19 | other | 3 | 1 | 135000 | 15570000.00 | unknown | — | 57.3050 | 0.1500 | ["56","58"] | ["0.1729","0.1491"] | [] | ["AMXO"] | 56.0000 | 58.0000 | 7 | 35 | false | false | true | true | false | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T18:19:45Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08c18-7608-78b0-a916-05b4896641fa | XLF | 2026-09-10 12:13 | strangle | 2 | 1 | 4000 | 448000.00 | unknown | — | 56.8450 | 0.1100 | ["54","61"] | ["0.1945","0.1611"] | [] | ["ARCO"] | 54.0000 | 61.0000 | 71 | 71 | false | true | false | true | true | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T16:13:49Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a087ca-2a88-7e81-9b13-ab8e43a2eb10 | XLF | 2026-09-09 16:09 | other | 4 | 1 | 5000 | 1805000.00 | unknown | — | 57.0813 | 1.3500 | ["57"] | ["0.1669"] | [] | ["ARCO"] | 57.0000 | 57.0000 | 9 | 37 | false | false | true | false | true | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T20:11:19Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0876a-d060-7751-ac6b-5c4950e9c61c | XLF | 2026-09-09 14:25 | put_vertical_spread | 2 | 1 | 2500 | 1365000.00 | unknown | — | 57.1850 | 0.4000 | ["40","55"] | ["0.2676","0.2157"] | [] | ["ARCO"] | 40.0000 | 55.0000 | 828 | 828 | false | true | false | true | false | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T18:26:12Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08751-e961-7003-a3cd-30d26788bffb | XLF | 2026-09-09 13:58 | other | 2 | 1 | 15000 | 1605000.00 | unknown | — | 57.1800 | 0.0700 | ["50"] | ["0.2218"] | [] | ["XBOX"] | 50.0000 | 50.0000 | 100 | 191 | false | true | true | false | false | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T17:58:35Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08733-41b8-78c2-8406-24b2534c5fb0 | XLF | 2026-09-09 13:24 | strangle | 2 | 1 | 15000 | 105000.00 | unknown | — | 57.2450 | 0.0350 | ["54","62"] | ["0.2478","0.2269"] | [] | ["AMXO"] | 54.0000 | 62.0000 | 9 | 9 | false | true | false | true | true | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T17:25:03Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |