select * from todays_data inner join vw_todays_etf_holdings on todays_data.ticker_symbol = vw_todays_etf_holdings.ticker_symbol where etf_ticker = 'XLV' order by weighting desc

XLV Conmponent Weighting

Ticker
Symbol
Company Name ETF Weight Close Price 10-Day 20-Day 50-Day Short Int Ratio Technical Score
JNJ Johnson & Johnson 10.5% $131.20 $129.4 $129.4 $125.4 2.0  (-11%) 3
UNH UnitedHealth Group Incorporated 7.2% $261.59 $255.6 $255.6 $252.3 2.2  (-7%) 2
PFE Pfizer Inc. 6.6% $41.00 $38.8 $38.8 $37.4 2.6  (-5%) 4
ABBV AbbVie Inc. 5.1% $95.47 $93.7 $93.7 $95.6 3.8  (1%) -1
MRK Merck & Co. Inc. 4.9% $66.00 $64.2 $64.2 $62.5 2.2  (4%) 4
AMGN Amgen Inc. 3.6% $193.97 $194.2 $194.2 $189.0 3.8  (-3%) 3
MDT Medtronic plc 3.4% $91.22 $89.3 $89.3 $87.6 2.3  (5%) 3
ABT Abbott Laboratories 3.2% $64.64 $64.3 $64.3 $63.0 2.1  (12%) 3
GILD Gilead Sciences Inc. 2.8% $78.04 $77.5 $77.5 $73.8 2.1  (-6%) 3
BMY Bristol-Myers Squibb Company 2.7% $59.53 $58.0 $58.0 $55.7 1.9  (2%) 3
TMO Thermo Fisher Scientific Inc. 2.7% $233.24 $224.6 $224.6 $216.4 1.9  (47%) 3
LLY Eli Lilly and Company 2.4% $102.19 $95.0 $95.0 $89.6 3.2  (27%) 4
CVS CVS Health Corporation 2.1% $68.57 $66.5 $66.5 $67.0 8.6  (8%) 1
CELG Celgene Corporation 2.1% $91.92 $87.8 $87.8 $82.6 2.5  (-3%) 3
BDX Becton Dickinson and Company 1.9% $251.50 $248.2 $248.2 $240.0 6.0  (-5%) 4
DHR Danaher Corporation 1.9% $101.71 $101.6 $101.6 $100.9 1.6  (19%) 3
ANTM Anthem Inc. 1.9% $261.13 $251.9 $251.9 $243.4 2.6  (-13%) 4
BIIB Biogen Inc. 1.8% $346.90 $351.8 $351.8 $323.4 1.6  (2%) 2
AET Aetna Inc. 1.8% $193.78 $189.7 $189.7 $186.6 2.1  (-5%) 4
SYK Stryker Corporation 1.7% $167.01 $170.2 $170.2 $171.2 2.7  (-9%) -1
ISRG Intuitive Surgical Inc. 1.6% $522.69 $521.4 $521.4 $500.3 1.8  (-1%) 4
AGN Allergan plc 1.6% $184.06 $179.2 $179.2 $172.2 1.9  (2%) 4
CI Cigna Corporation 1.3% $185.42 $179.8 $179.8 $176.0 3.0  (25%) 3
ESRX Express Scripts Holding Company 1.3% $81.82 $78.9 $78.9 $78.9 4.8  (16%) 3
BSX Boston Scientific Corporation 1.3% $33.85 $33.6 $33.6 $32.8 1.6  (-3%) 2
HUM Humana Inc. 1.3% $323.71 $318.4 $318.4 $308.0 2.8  (-3%) 3
ZTS Zoetis Inc. Class A 1.2% $92.40 $87.3 $87.3 $86.6 2.2  (10%) 4
VRTX Vertex Pharmaceuticals Incorporated 1.2% $175.05 $177.2 $177.2 $165.2 1.6  (-19%) 3
ILMN Illumina Inc. 1.1% $333.50 $315.7 $315.7 $295.8 1.8  (-6%) 4
BAX Baxter International Inc. 1.1% $72.07 $73.7 $73.7 $73.9 1.4  (0%) 0
MCK McKesson Corporation 1.0% $123.88 $129.8 $129.8 $137.6 3.7  (-0%) -2
EW Edwards Lifesciences Corporation 0.9% $139.15 $147.1 $147.1 $147.0 1.8  (2%) 0
HCA HCA Healthcare Inc 0.9% $128.20 $117.6 $117.6 $110.1 1.8  (-28%) 4
ALXN Alexion Pharmaceuticals Inc. 0.8% $120.14 $131.1 $131.1 $126.1 2.9  (13%) 1
ZBH Zimmer Biomet Holdings Inc. 0.8% $123.74 $119.0 $119.0 $115.3 2.6  (-2%) 4
REGN Regeneron Pharmaceuticals Inc. 0.7% $372.14 $374.1 $374.1 $347.3 3.7  (-0%) 3
CNC Centene Corporation 0.7% $138.47 $134.1 $134.1 $127.7 3.0  (-12%) 4
A Agilent Technologies Inc. 0.7% $66.69 $65.0 $65.0 $64.0 2.7  (3%) 2
CAH Cardinal Health Inc. 0.6% $49.37 $49.8 $49.8 $51.3 3.1  (27%) -1
MYL Mylan N.V. 0.6% $36.61 $36.7 $36.7 $37.8 3.0  (-16%) -1
CERN Cerner Corporation 0.6% $66.29 $62.5 $62.5 $61.4 6.5  (-4%) 4
ALGN Align Technology Inc. 0.6% $366.87 $366.4 $366.4 $356.0 2.0  (-3%) 3
LH Laboratory Corporation of America Holdings 0.6% $179.94 $181.4 $181.4 $183.2 2.2  (-5%) -2
IDXX IDEXX Laboratories Inc. 0.5% $244.63 $242.9 $242.9 $229.9 3.3  (-0%) 4
ABC AmerisourceBergen Corporation 0.5% $83.24 $83.9 $83.9 $86.6 2.9  (-21%) -1
WAT Waters Corporation 0.5% $191.95 $195.8 $195.8 $196.7 4.9  (-9%) -1
MTD Mettler-Toledo International Inc. 0.5% $575.60 $590.4 $590.4 $584.3 3.4  (-9%) 1
IQV IQVIA Holdings Inc 0.4% $121.70 $116.9 $116.9 $108.2 2.6  (-13%) 4
DGX Quest Diagnostics Incorporated 0.4% $108.40 $110.4 $110.4 $110.3 4.1  (10%) 1
NKTR Nektar Therapeutics 0.4% $59.37 $51.0 $51.0 $53.7 8.0  (1%) 2
RMD ResMed Inc. 0.4% $108.09 $108.1 $108.1 $106.6 4.5  (-4%) 3
HSIC Henry Schein Inc. 0.4% $78.53 $77.2 $77.2 $74.6 20.7  (-1%) 5
XRAY DENTSPLY SIRONA Inc. 0.4% $40.12 $45.4 $45.4 $44.8 4.3  (29%) -0
COO Cooper Companies Inc. 0.4% $256.84 $252.9 $252.9 $241.3 6.8  (0%) 5
HOLX Hologic Inc. 0.3% $41.03 $41.7 $41.7 $40.4 5.0  (6%) 3
INCY Incyte Corporation 0.3% $64.38 $67.6 $67.6 $69.0 3.5  (-8%) -2
VAR Varian Medical Systems Inc. 0.3% $111.38 $115.2 $115.2 $117.4 4.4  (-4%) -1
UHS Universal Health Services Inc. Class B 0.3% $123.67 $119.2 $119.2 $116.4 3.5  (-7%) 3
PRGO Perrigo Co. Plc 0.3% $70.03 $77.0 $77.0 $75.6 6.9  (-0%) 1
DVA DaVita Inc. 0.3% $72.65 $71.4 $71.4 $70.8 6.6  (-2%) 5
PKI PerkinElmer Inc. 0.3% $85.59 $80.2 $80.2 $77.4 4.6  (-11%) 4
EVHC Envision Healthcare Corp. 0.1% $44.68 $44.4 $44.4 $44.2 6.4  (-14%) 2