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% $122.41 $122.3 $122.3 $125.2 3.0  (-3%) -1
UNH UnitedHealth Group Incorporated 7.2% $255.33 $246.9 $246.9 $238.6 2.7  (-1%) 3
PFE Pfizer Inc. 6.6% $36.16 $36.1 $36.1 $36.0 2.6  (-3%) 1
ABBV AbbVie Inc. 5.1% $98.75 $101.3 $101.3 $98.6 3.3  (28%) 1
MRK Merck & Co. Inc. 4.9% $61.56 $60.5 $60.5 $58.9 2.0  (-2%) 4
AMGN Amgen Inc. 3.6% $185.79 $181.0 $181.0 $175.6 2.6  (-2%) 2
MDT Medtronic plc 3.4% $86.57 $86.2 $86.2 $83.2 2.2  (-8%) 2
ABT Abbott Laboratories 3.2% $62.96 $62.4 $62.4 $60.5 2.3  (-9%) 3
GILD Gilead Sciences Inc. 2.8% $71.15 $69.3 $69.3 $70.5 1.5  (1%) 1
BMY Bristol-Myers Squibb Company 2.7% $53.63 $52.7 $52.7 $53.6 1.5  (6%) 1
TMO Thermo Fisher Scientific Inc. 2.7% $216.55 $214.8 $214.8 $213.4 3.1  (-11%) 3
LLY Eli Lilly and Company 2.4% $86.35 $84.2 $84.2 $81.6 2.7  (20%) 4
CVS CVS Health Corporation 2.1% $69.12 $65.6 $65.6 $65.3 3.9  (3%) 2
CELG Celgene Corporation 2.1% $78.39 $78.2 $78.2 $83.8 1.8  (-11%) -2
BDX Becton Dickinson and Company 1.9% $232.82 $227.5 $227.5 $227.1 3.7  (-13%) 3
DHR Danaher Corporation 1.9% $102.64 $101.9 $101.9 $100.9 2.6  (6%) 2
ANTM Anthem Inc. 1.9% $241.74 $230.6 $230.6 $229.6 2.6  (-44%) 3
BIIB Biogen Inc. 1.8% $305.68 $294.0 $294.0 $279.4 2.1  (12%) 3
AET Aetna Inc. 1.8% $188.09 $178.9 $178.9 $176.4 2.5  (37%) 3
SYK Stryker Corporation 1.7% $168.75 $173.5 $173.5 $168.3 4.8  (-4%) 2
ISRG Intuitive Surgical Inc. 1.6% $495.52 $473.3 $473.3 $453.9 2.4  (-10%) 4
AGN Allergan plc 1.6% $173.95 $158.9 $158.9 $158.1 1.9  (15%) 2
CI Cigna Corporation 1.3% $175.33 $175.5 $175.5 $173.4 2.5  (21%) 1
ESRX Express Scripts Holding Company 1.3% $82.24 $77.4 $77.4 $74.4 2.9  (24%) 3
BSX Boston Scientific Corporation 1.3% $32.51 $31.1 $31.1 $29.8 2.6  (3%) 3
HUM Humana Inc. 1.3% $304.43 $295.8 $295.8 $291.7 2.7  (0%) 4
ZTS Zoetis Inc. Class A 1.2% $88.15 $85.2 $85.2 $84.1 1.7  (1%) 4
VRTX Vertex Pharmaceuticals Incorporated 1.2% $154.99 $153.0 $153.0 $154.8 2.3  (21%) -1
ILMN Illumina Inc. 1.1% $290.16 $276.7 $276.7 $258.8 3.4  (16%) 4
BAX Baxter International Inc. 1.1% $75.41 $73.1 $73.1 $70.1 2.7  (19%) 4
MCK McKesson Corporation 1.0% $150.00 $145.6 $145.6 $146.9 5.2  (5%) 1
EW Edwards Lifesciences Corporation 0.9% $151.56 $141.0 $141.0 $137.9 4.4  (62%) 4
HCA HCA Healthcare Inc 0.9% $106.01 $104.4 $104.4 $100.5 3.5  (-4%) 4
ALXN Alexion Pharmaceuticals Inc. 0.8% $120.16 $118.5 $118.5 $116.0 2.7  (8%) 1
ZBH Zimmer Biomet Holdings Inc. 0.8% $114.88 $113.1 $113.1 $112.4 2.9  (20%) 1
REGN Regeneron Pharmaceuticals Inc. 0.7% $315.67 $304.5 $304.5 $308.1 2.4  (6%) 2
CNC Centene Corporation 0.7% $123.50 $118.6 $118.6 $113.9 1.2  (-9%) 4
A Agilent Technologies Inc. 0.7% $66.31 $64.4 $64.4 $65.8 1.3  (-14%) -0
CAH Cardinal Health Inc. 0.6% $54.62 $53.1 $53.1 $57.2 1.8  (-34%) -2
MYL Mylan N.V. 0.6% $39.51 $39.9 $39.9 $39.4 3.4  (-1%) 1
CERN Cerner Corporation 0.6% $61.08 $60.3 $60.3 $59.0 2.6  (-6%) 1
ALGN Align Technology Inc. 0.6% $366.27 $330.6 $330.6 $289.1 2.2  (8%) 3
LH Laboratory Corporation of America Holdings 0.6% $187.88 $182.0 $182.0 $174.4 3.9  (-10%) 4
IDXX IDEXX Laboratories Inc. 0.5% $226.08 $211.6 $211.6 $203.7 3.0  (-3%) 4
ABC AmerisourceBergen Corporation 0.5% $93.35 $85.7 $85.7 $87.3 3.2  (1%) 2
WAT Waters Corporation 0.5% $200.27 $197.7 $197.7 $197.3 4.3  (13%) 1
MTD Mettler-Toledo International Inc. 0.5% $592.70 $574.5 $574.5 $569.0 2.4  (21%) 1
IQV IQVIA Holdings Inc 0.4% $103.16 $101.9 $101.9 $99.6 5.6  (3%) 3
DGX Quest Diagnostics Incorporated 0.4% $110.94 $106.5 $106.5 $103.0 5.5  (5%) 5
NKTR Nektar Therapeutics 0.4% $56.41 $69.7 $69.7 $81.0 4.8  (2%) -2
RMD ResMed Inc. 0.4% $106.76 $104.2 $104.2 $100.4 4.6  (8%) 4
HSIC Henry Schein Inc. 0.4% $72.88 $71.2 $71.2 $71.8 9.6  (-6%) 3
XRAY DENTSPLY SIRONA Inc. 0.4% $44.89 $45.0 $45.0 $47.4 1.6  (-17%) -1
COO Cooper Companies Inc. 0.4% $235.15 $229.1 $229.1 $227.5 6.9  (2%) 1
HOLX Hologic Inc. 0.3% $40.23 $38.6 $38.6 $38.2 3.0  (-4%) 3
INCY Incyte Corporation 0.3% $73.64 $68.4 $68.4 $67.4 2.5  (-6%) 2
VAR Varian Medical Systems Inc. 0.3% $123.31 $120.2 $120.2 $119.9 4.1  (24%) 1
UHS Universal Health Services Inc. Class B 0.3% $114.59 $116.3 $116.3 $117.7 3.1  (-7%) -2
PRGO Perrigo Co. Plc 0.3% $74.83 $74.5 $74.5 $77.3 3.2  (6%) -1
DVA DaVita Inc. 0.3% $71.04 $68.7 $68.7 $65.9 3.9  (-4%) 3
PKI PerkinElmer Inc. 0.3% $78.34 $76.5 $76.5 $75.1 4.5  (18%) 3
EVHC Envision Healthcare Corp. 0.1% $44.78 $43.5 $43.5 $40.5 7.3  (-7%) 4