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% $122.41 $122.3 $122.3 $125.2 3.0  (-3%) -1
PFE PFIZER INC 8.8% $36.16 $36.1 $36.1 $36.0 2.6  (-3%) 1
MRK MERCK & CO INC 8.3% $61.56 $60.5 $60.5 $58.9 2.0  (-2%) 4
LLY ELI LILLY 6.3% $86.35 $84.2 $84.2 $81.6 2.7  (20%) 4
BMY BRISTOL MYERS SQUIBB 5.5% $53.63 $52.7 $52.7 $53.6 1.5  (6%) 1
AGN ALLERGAN 5.2% $173.95 $158.9 $158.9 $158.1 1.9  (15%) 2
ZTS ZOETIS INC CLASS A 4.7% $88.15 $85.2 $85.2 $84.1 1.7  (1%) 4
MYL MYLAN NV 3.4% $39.51 $39.9 $39.9 $39.4 3.4  (-1%) 1
JAZZ JAZZ PHARMACEUTICALS PLC 2.9% $177.23 $170.6 $170.6 $161.2 2.2  (-3%) 3
PRGO PERRIGO PLC 2.8% $74.83 $74.5 $74.5 $77.3 3.2  (6%) -1
CTLT CATALENT INC 2.3% $41.54 $39.7 $39.7 $40.2 3.6  (12%) 1
IRWD IRONWOOD PHARMA INC CLASS A 2.1% $18.58 $17.7 $17.7 $17.6 11.1  (-12%) 4
FOLD AMICUS THERAPEUTICS INC 1.8% $16.41 $16.2 $16.2 $15.0 11.2  (1%) 3
HZNP HORIZON PHARMA PLC 1.6% $17.72 $16.3 $16.3 $14.9 4.3  (7%) 3
CORT CORCEPT THERAPEUTICS INC 1.6% $19.33 $18.6 $18.6 $17.7 12.7  (2%) 4
AERI AERIE PHARMACEUTICALS INC 1.5% $64.20 $56.1 $56.1 $53.7 15.4  (0%) 3
MDCO MEDICINES 1.5% $36.69 $34.1 $34.1 $31.7 25.1  (-2%) 3
PCRX PACIRA PHARMACEUTICALS INC 1.5% $38.45 $35.8 $35.8 $34.8 7.2  (-1%) 4
TXMD THERAPEUTICSMD INC 1.4% $6.88 $6.5 $6.5 $6.0 20.0  (-4%) 4
XENT INTERSECT ENT INC 1.4% $37.00 $40.1 $40.1 $39.8 0.5  (-15%) -0
TSRO TESARO INC 1.4% $41.43 $45.9 $45.9 $49.3 7.5  (1%) -1
SPPI SPECTRUM PHARMACEUTICALS INC 1.3% $20.00 $19.6 $19.6 $18.3 8.8  (-5%) 4
OMER OMEROS CORP 1.3% $19.69 $19.7 $19.7 $17.3 6.7  (-2%) 3
PBH PRESTIGE BRANDS HOLDINGS INC 1.3% $35.43 $34.6 $34.6 $32.9 5.3  (-1%) 2
PAHC PHIBRO ANIMAL HEALTH CORP CLASS A 1.2% $46.90 $45.8 $45.8 $43.9 1.4  (-30%) 4
MYOK MYOKARDIA INC 1.2% $48.95 $48.3 $48.3 $48.4 8.3  (-3%) -1
INVA INNOVIVA INC 1.2% $14.52 $14.6 $14.6 $15.1 15.7  (4%) 0
TBPH THERAVANCE BIOPHARMA INC 1.2% $24.29 $23.9 $23.9 $23.8 29.8  (4%) 1
MNK MALLINCKRODT 1.1% $18.83 $17.3 $17.3 $15.3 6.7  (0%) 3
ENDP ENDO INTERNATIONAL PLC 1.1% $8.91 $6.9 $6.9 $6.2 6.0  (3%) 4
AMAG AMAG PHARMACEUTICALS INC 1.1% $24.75 $24.3 $24.3 $22.4 8.9  (1%) 5
AMPH AMPHASTAR PHARMACEUTICALS INC 1.1% $16.96 $16.5 $16.5 $17.7 5.5  (2%) 1
RVNC REVANCE THERAPEUTICS INC 1.0% $31.05 $30.0 $30.0 $30.1 9.8  (9%) -1
AKRX AKORN INC 1.0% $15.04 $14.2 $14.2 $15.0 2.3  (-17%) 1
ITCI INTRA CELLULAR THERAPIES INC 1.0% $21.26 $22.4 $22.4 $20.7 9.9  (-5%) 3
WVE WAVE LIFE SCIENCES LTD 1.0% $48.95 $46.2 $46.2 $44.0 20.6  (-5%) 4
VNDA VANDA PHARMACEUTICALS INC 0.9% $18.30 $17.5 $17.5 $16.3 4.2  (-11%) 2
LCI LANNETT COMPANY INC 0.9% $16.55 $16.6 $16.6 $16.1 17.3  (2%) 3
DEPO DEPOMED INC 0.9% $6.97 $6.7 $6.7 $6.7 5.1  (1%) -1
ACRS ACLARIS THERAPEUTICS INC 0.9% $19.78 $19.0 $19.0 $18.3 26.7  (-0%) 3
DERM DERMIRA INC 0.8% $10.00 $9.5 $9.5 $9.2 4.8  (-4%) 1
SGYP SYNERGY PHARMACEUTICALS INC 0.7% $1.81 $1.7 $1.7 $1.7 13.8  (0%) 1