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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b530-e447-7863-90ef-df1e403fab41 | XLV | 2026-09-18 11:44 | call_diagonal_spread | 2 | 1 | 10 | 26790.00 | unknown | bid | 168.1800 | 2.2400 | ["150","170"] | ["0.1473","0.1273"] | [] | ["XCBO"] | 150.0000 | 170.0000 | 7 | 364 | false | false | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:45:08Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b011-e35a-72f1-aa09-3bd2fe3c000a | XLV | 2026-09-17 11:52 | call_diagonal_spread | 2 | 1 | 11 | 64284.00 | long | ask | 168.6400 | 4.8500 | ["150","160"] | ["0.1259","0.1352"] | [] | ["XCBO"] | 150.0000 | 160.0000 | 491 | 855 | false | false | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T15:53:05Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0aab0-d403-7350-84a4-4b7db3c8ba46 | XLV | 2026-09-16 10:48 | put_vertical_spread | 2 | 1 | 369 | 62730.00 | unknown | — | 168.1500 | 0.3500 | ["140","155"] | ["0.2175","0.1928"] | [] | ["XCBO"] | 140.0000 | 155.0000 | 93 | 93 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T14:48:31Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aa78-a533-7aa3-b025-4451c9920d1d | XLV | 2026-09-16 09:47 | call_vertical_spread | 2 | 1 | 500 | 248500.00 | long | ask | 168.3200 | 1.0000 | ["165","168"] | ["0.2635","0.2363"] | ["167.25"] | ["XCBO"] | 165.0000 | 168.0000 | 2 | 2 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T13:47:28Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aa72-a9f3-7961-be94-f36f1bd4992b | XLV | 2026-09-16 09:40 | call_vertical_spread | 2 | 1 | 10 | 58060.00 | unknown | — | 168.2350 | 3.5500 | ["120","200"] | ["0.3174","0.1500"] | [] | ["XCBO"] | 120.0000 | 200.0000 | 492 | 492 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T13:40:43Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a673-d946-7be2-8691-391ec4b87521 | XLV | 2026-09-15 15:03 | straddle | 2 | 1 | 310 | 201019.00 | short | bid | 167.5900 | 0.3000 | ["167"] | ["0.1653"] | ["160.52","173.48"] | ["XMIO"] | 167.0000 | 167.0000 | 31 | 31 | true | false | false | false | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:04:00Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a0b6-9d10-71c3-a3af-3a510a616172 | XLV | 2026-09-14 12:18 | call_ratio_spread | 2 | 1 | 1000 | 226500.00 | long | ask | 167.8900 | 0.3400 | ["165","170"] | ["0.2053","0.1932"] | ["167.21","172.79"] | ["EDGO"] | 165.0000 | 170.0000 | 4 | 4 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T16:19:00Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a08be0-52f0-7290-be31-4d08a82f9b4b | XLV | 2026-09-10 11:12 | call_vertical_spread | 2 | 1 | 44 | 58997.00 | short | bid | 165.7700 | 1.9000 | ["165","180"] | ["0.1587","0.1563"] | ["171.24"] | ["XCBO"] | 165.0000 | 180.0000 | 190 | 190 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T15:12:54Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08bdc-8648-76e2-a0e0-628df6a7ced9 | XLV | 2026-09-10 11:07 | call_vertical_spread | 2 | 1 | 5 | 88880.00 | long | ask | 165.6800 | 3.2000 | ["75","80"] | ["2.9281","2.7262"] | ["79.98"] | ["XCBO"] | 75.0000 | 80.0000 | 8 | 8 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T15:08:39Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08706-26d9-7500-954c-d4f628bc75d6 | XLV | 2026-09-09 12:35 | call_vertical_spread | 2 | 1 | 57 | 617424.00 | long | ask | 166.6000 | 1.0000 | ["110","115"] | ["0.8359","0.8480"] | ["114.98"] | ["XCBO"] | 110.0000 | 115.0000 | 16 | 16 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T16:35:31Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a086ef-33d8-7ce1-926d-bf07c6d8d380 | XLV | 2026-09-09 12:10 | call_vertical_spread | 2 | 1 | 41 | 652146.00 | long | ask | 166.5590 | 2.1000 | ["85","90"] | ["2.1883","2.0349"] | ["89.98"] | ["XCBO"] | 85.0000 | 90.0000 | 9 | 9 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T16:11:02Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a086e7-ae10-7031-851f-70b79082b797 | XLV | 2026-09-09 12:02 | call_vertical_spread | 2 | 1 | 55 | 875160.00 | long | ask | 166.8000 | 2.0000 | ["85","90"] | ["1.9439","1.8154"] | ["89.98"] | ["XCBO"] | 85.0000 | 90.0000 | 9 | 9 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T16:02:30Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a081dc-aa10-7d60-bdb9-731fc9f16fe7 | XLV | 2026-09-08 12:31 | call_vertical_spread | 2 | 1 | 37 | 669182.00 | long | ask | 167.8300 | 2.9000 | ["75","80"] | ["1.6329","1.6247"] | ["79.98"] | ["XCBO"] | 75.0000 | 80.0000 | 10 | 10 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T16:32:13Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a081d3-e010-73f1-b456-2a40bcba270d | XLV | 2026-09-08 12:22 | call_vertical_spread | 2 | 1 | 48 | 868128.00 | long | ask | 167.5200 | 2.9000 | ["75","80"] | ["2.3724","2.2139"] | ["79.98"] | ["XCBO"] | 75.0000 | 80.0000 | 10 | 10 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T16:22:41Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |