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 |
| 01a0b5d4-9e57-74d0-a5a6-9f6bdf29c194 | XLF | 2026-09-18 14:43 | strangle | 2 | 1 | 5000 | 945000.00 | long | ask | 55.8899 | 0.0400 | ["54","58"] | ["0.1757","0.1418"] | ["52.11","59.89"] | ["ARCO"] | 54.0000 | 58.0000 | 91 | 91 | false | true | false | true | true | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:43:51Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 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 |
| 01a0910d-5229-7ea2-805b-0607eb27c4b8 | XLF | 2026-09-11 11:19 | strangle | 2 | 1 | 27 | 25245.00 | unknown | — | 57.1444 | 0.2000 | ["52","61"] | ["0.1321","0.2255"] | [] | ["C2OX"] | 52.0000 | 61.0000 | 35 | 35 | false | false | false | true | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T15:19:52Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08c4f-4d18-7ed0-830e-d2feeb819a49 | XLF | 2026-09-10 13:13 | strangle | 2 | 1 | 700 | 120400.00 | short | bid | 56.8400 | 0.0900 | ["53","61"] | ["0.1979","0.1521"] | ["51.28","62.72"] | ["XPHO"] | 53.0000 | 61.0000 | 127 | 127 | false | true | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T17:13:39Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 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 |
| 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 |
| 01a06d48-7265-71e2-baca-f2db0e1ac6f0 | XLF | 2026-09-04 12:37 | strangle | 2 | 1 | 2000 | 302000.00 | long | ask | 58.1801 | 0.1000 | ["57","59"] | ["0.1649","0.1359"] | ["55.49","60.51"] | ["AMXO"] | 57.0000 | 59.0000 | 42 | 42 | false | true | false | true | true | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T16:37:38Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |