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

IHE 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.4% $131.20 $129.4 $129.4 $125.4 2.0  (-11%) 3
PFE PFIZER INC 8.8% $41.00 $38.8 $38.8 $37.4 2.6  (-5%) 4
MRK MERCK & CO INC 8.3% $66.00 $64.2 $64.2 $62.5 2.2  (4%) 4
LLY ELI LILLY 6.3% $102.19 $95.0 $95.0 $89.6 3.2  (27%) 4
BMY BRISTOL MYERS SQUIBB 5.5% $59.53 $58.0 $58.0 $55.7 1.9  (2%) 3
AGN ALLERGAN 5.2% $184.06 $179.2 $179.2 $172.2 1.9  (2%) 4
ZTS ZOETIS INC CLASS A 4.7% $92.40 $87.3 $87.3 $86.6 2.2  (10%) 4
MYL MYLAN NV 3.4% $36.61 $36.7 $36.7 $37.8 3.0  (-16%) -1
JAZZ JAZZ PHARMACEUTICALS PLC 2.9% $177.73 $175.9 $175.9 $175.9 7.0  (-18%) 2
PRGO PERRIGO PLC 2.8% $70.03 $77.0 $77.0 $75.6 6.9  (-0%) 1
CTLT CATALENT INC 2.3% $40.22 $42.2 $42.2 $41.6 1.9  (-16%) 1
IRWD IRONWOOD PHARMA INC CLASS A 2.1% $19.21 $19.6 $19.6 $19.0 15.0  (-8%) 4
FOLD AMICUS THERAPEUTICS INC 1.8% $15.11 $15.3 $15.3 $15.8 14.8  (-4%) 1
HZNP HORIZON PHARMA PLC 1.6% $20.91 $17.8 $17.8 $17.3 9.5  (-4%) 4
CORT CORCEPT THERAPEUTICS INC 1.6% $13.98 $13.6 $13.6 $15.7 14.8  (8%) -1
AERI AERIE PHARMACEUTICALS INC 1.5% $64.35 $69.7 $69.7 $66.2 13.0  (-33%) 1
MDCO MEDICINES 1.5% $38.94 $39.6 $39.6 $37.7 29.1  (-5%) 3
PCRX PACIRA PHARMACEUTICALS INC 1.5% $45.23 $40.0 $40.0 $37.1 5.9  (-17%) 4
TXMD THERAPEUTICSMD INC 1.4% $5.19 $6.1 $6.1 $6.5 29.4  (-2%) 0
XENT INTERSECT ENT INC 1.4% $26.15 $30.8 $30.8 $35.2 2.2  (57%) -2
TSRO TESARO INC 1.4% $27.19 $35.8 $35.8 $40.6 6.2  (1%) -1
SPPI SPECTRUM PHARMACEUTICALS INC 1.3% $20.06 $22.1 $22.1 $21.1 9.4  (-9%) 2
OMER OMEROS CORP 1.3% $21.70 $21.0 $21.0 $19.9 18.2  (0%) 4
PBH PRESTIGE BRANDS HOLDINGS INC 1.3% $37.67 $36.9 $36.9 $36.7 19.5  (9%) 4
PAHC PHIBRO ANIMAL HEALTH CORP CLASS A 1.2% $49.15 $48.4 $48.4 $47.4 2.1  (5%) 4
MYOK MYOKARDIA INC 1.2% $58.35 $57.1 $57.1 $52.5 10.1  (-16%) 4
INVA INNOVIVA INC 1.2% $13.92 $14.1 $14.1 $14.3 15.4  (-5%) 0
TBPH THERAVANCE BIOPHARMA INC 1.2% $27.84 $26.0 $26.0 $24.9 38.3  (-3%) 5
MNK MALLINCKRODT 1.1% $30.70 $23.6 $23.6 $20.8 13.0  (-16%) 4
ENDP ENDO INTERNATIONAL PLC 1.1% $15.83 $12.1 $12.1 $10.2 10.5  (-6%) 5
AMAG AMAG PHARMACEUTICALS INC 1.1% $25.40 $22.7 $22.7 $22.5 20.7  (5%) 4
AMPH AMPHASTAR PHARMACEUTICALS INC 1.1% $17.18 $17.1 $17.1 $16.6 11.7  (4%) 4
RVNC REVANCE THERAPEUTICS INC 1.0% $26.45 $28.5 $28.5 $29.1 16.8  (1%) -1
AKRX AKORN INC 1.0% $18.82 $18.0 $18.0 $16.6 6.0  (-1%) 5
ITCI INTRA CELLULAR THERAPIES INC 1.0% $21.40 $21.0 $21.0 $20.6 8.7  (-13%) 4
WVE WAVE LIFE SCIENCES LTD 1.0% $39.00 $39.0 $39.0 $41.0 18.6  (-7%) -1
VNDA VANDA PHARMACEUTICALS INC 0.9% $21.55 $20.8 $20.8 $19.5 6.3  (-2%) 4
LCI LANNETT COMPANY INC 0.9% $13.65 $12.9 $12.9 $14.2 30.8  (5%) -1
DEPO DEPOMED INC 0.9% $7.56 $8.4 $8.4 $7.5 10.2  (3%) 3
ACRS ACLARIS THERAPEUTICS INC 0.9% $17.46 $19.0 $19.0 $19.3 23.0  (-5%) 1
DERM DERMIRA INC 0.8% $9.86 $10.2 $10.2 $9.9 5.3  (-11%) 0
SGYP SYNERGY PHARMACEUTICALS INC 0.7% $1.80 $1.8 $1.8 $1.8 26.7  (2%) 1