Multi-leg option trades
core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
403,968 rowsCSV — whole table, not this view
Sources in this table
uw_multileg403,968 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
| 01a081d3-ff51-7cf0-b0c0-3f61ba1bea93 | XLV | 2026-09-08 12:22 | call_vertical_spread | 2 | 1 | 2 | 36168.00 | long | ask | 167.5550 | 2.9000 | ["75","80"] | ["2.3198","2.1663"] | ["79.98"] | ["XPHO"] | 75.0000 | 80.0000 | 10 | 10 | false | false | false | true | false | mlet | tracked | 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 |
| 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 |
| 01a081df-6160-7f73-91f9-18d06de56f32 | XLV | 2026-09-08 12:34 | call_vertical_spread | 2 | 1 | 11 | 198924.00 | long | ask | 167.8000 | 2.9000 | ["75","80"] | ["1.7880","1.7198"] | ["79.98"] | ["XPHO"] | 75.0000 | 80.0000 | 10 | 10 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T16:34:56Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a081e2-a169-7f81-8a41-5cca6432067a | XLV | 2026-09-08 12:38 | call_vertical_spread | 2 | 1 | 12 | 132840.00 | long | ask | 167.7200 | 3.2000 | ["110","115"] | ["2.0091","1.8657"] | ["114.98"] | ["XISX"] | 110.0000 | 115.0000 | 3 | 3 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T16:38:28Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 01a08bff-1dc0-7c73-9bf9-02df894ee67f | XLV | 2026-09-10 11:45 | call_vertical_spread | 2 | 1 | 52 | 456664.00 | unknown | — | 165.9100 | 1.6000 | ["120","125"] | ["0.8637","0.7759"] | [] | ["XBOX"] | 120.0000 | 125.0000 | 15 | 15 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T15:46:14Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a0a043-7c69-7653-a328-90ba0cc88243 | XLV | 2026-09-14 10:12 | call_vertical_spread | 2 | 1 | 2 | 32012.00 | long | ask | 167.1000 | 2.2500 | ["85","90"] | ["3.2958","3.0688"] | ["89.98"] | ["XMIO"] | 85.0000 | 90.0000 | 4 | 4 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T14:13:06Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a04f-e819-7753-b7ee-f7c9797953ae | XLV | 2026-09-14 10:26 | call_vertical_spread | 2 | 1 | 2 | 26062.00 | short | bid | 167.0700 | 2.5000 | ["100","105"] | ["1.6065","1.4871"] | ["104.97"] | ["XPHO"] | 100.0000 | 105.0000 | 11 | 11 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T14:26:31Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a5db-5266-7e90-af60-bceecbb3112b | XLV | 2026-09-15 12:16 | call_vertical_spread | 2 | 1 | 10 | 39570.00 | short | bid | 167.4700 | 2.6500 | ["145","150"] | ["1.0852","0.7118"] | ["149.17"] | ["XCBO"] | 145.0000 | 150.0000 | 3 | 3 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T16:17:18Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 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 |
| 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 |
| 01a0b612-4780-7b61-a54a-0bc357ae1129 | XLV | 2026-09-18 15:50 | call_vertical_spread | 2 | 1 | 35 | 243950.00 | long | ask | 168.5800 | 2.1500 | ["110","157.5"] | ["1.7000","0.4197"] | ["157.5"] | ["XPHO"] | 110.0000 | 157.5000 | 7 | 7 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:50:46Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b612-7277-7261-929f-a8b8702423f9 | XLV | 2026-09-18 15:50 | call_vertical_spread | 2 | 1 | 30 | 255000.00 | unknown | ask | 168.5850 | 3.1000 | ["100","152.5"] | ["1.6029","0.3465"] | ["168.75"] | ["XPHO"] | 100.0000 | 152.5000 | 7 | 7 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:51:04Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b612-85ff-7aa0-97da-881864bf12aa | XLV | 2026-09-18 15:50 | call_vertical_spread | 2 | 1 | 40 | 368960.00 | unknown | ask | 168.5600 | 2.1500 | ["110","135"] | ["1.7134","1.0055"] | ["168.62"] | ["XPHO"] | 110.0000 | 135.0000 | 7 | 7 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:51:04Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b612-8dd0-7fa1-81fc-7d4f363c4e77 | XLV | 2026-09-18 15:51 | call_vertical_spread | 2 | 1 | 15 | 107010.00 | unknown | ask | 168.5600 | 2.7000 | ["115","151"] | ["1.0323","0.6037"] | ["168.67"] | ["XPHO"] | 115.0000 | 151.0000 | 7 | 7 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:51:04Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b612-c868-7633-a6f3-c1a97d5fd962 | XLV | 2026-09-18 15:51 | call_vertical_spread | 2 | 1 | 60 | 582960.00 | short | bid | 168.6150 | 2.0500 | ["115","125"] | ["1.5861","1.2009"] | ["125"] | ["XPHO"] | 115.0000 | 125.0000 | 7 | 7 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:51:20Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b613-0acf-7de1-a653-d697bfc61bfe | XLV | 2026-09-18 15:51 | call_vertical_spread | 2 | 1 | 90 | 537660.00 | unknown | bid | 168.5600 | 1.9000 | ["120","157.5"] | ["1.3764","0.4237"] | ["168.62"] | ["XPHO"] | 120.0000 | 157.5000 | 7 | 7 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:51:37Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0c46b-12f7-7981-829b-7ed87f9ab579 | XLV | 2026-09-21 10:42 | call_vertical_spread | 2 | 1 | 19 | 116356.00 | long | ask | 168.8800 | 4.2500 | ["135","140"] | ["0.6210","0.5628"] | ["139.98"] | ["XCBO"] | 135.0000 | 140.0000 | 11 | 11 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T14:42:39Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c4d4-9e7f-7e41-bf83-da23a98f241f | XLV | 2026-09-21 12:37 | call_vertical_spread | 2 | 1 | 2 | 26426.00 | long | ask | 168.6200 | 3.5500 | ["100","105"] | ["1.3333","1.2597"] | ["104.97"] | ["XMIO"] | 100.0000 | 105.0000 | 18 | 18 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T16:37:54Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c9f9-25bf-7f61-95fe-dcfb5b9cf7a1 | XLV | 2026-09-22 12:35 | call_vertical_spread | 2 | 1 | 50 | 323100.00 | long | ask | 170.1000 | 2.8000 | ["135","140"] | ["0.7379","0.6847"] | ["139.98"] | ["XCBO"] | 135.0000 | 140.0000 | 10 | 10 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T16:36:04Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0c9fe-59c7-73c2-841d-c93e073bda6b | XLV | 2026-09-22 12:41 | call_vertical_spread | 2 | 1 | 50 | 323000.00 | long | ask | 170.0950 | 2.8000 | ["135","140"] | ["0.7409","0.6868"] | ["139.98"] | ["XPHO"] | 135.0000 | 140.0000 | 10 | 10 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T16:41:54Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0ca00-d67f-7092-8d51-75966afebf21 | XLV | 2026-09-22 12:44 | call_vertical_spread | 2 | 1 | 3 | 34419.00 | short | bid | 170.1100 | 3.9500 | ["110","115"] | ["1.1336","1.0685"] | ["114.99"] | ["XMIO"] | 110.0000 | 115.0000 | 17 | 17 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T16:44:16Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |