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

XPH Conmponent Weighting

Ticker
Symbol
Company Name ETF Weight Close Price 10-Day 20-Day 50-Day Short Int Ratio Technical Score
MRK Merck & Co. Inc. 4.7% $66.00 $64.2 $64.2 $62.5 2.2  (4%) 4
JAZZ Jazz Pharmaceuticals Plc 4.5% $177.73 $175.9 $175.9 $175.9 7.0  (-18%) 2
LLY Eli Lilly and Company 4.5% $102.19 $95.0 $95.0 $89.6 3.2  (27%) 4
AGN Allergan plc 4.3% $184.06 $179.2 $179.2 $172.2 1.9  (2%) 4
PFE Pfizer Inc. 4.3% $41.00 $38.8 $38.8 $37.4 2.6  (-5%) 4
ZTS Zoetis Inc. Class A 4.3% $92.40 $87.3 $87.3 $86.6 2.2  (10%) 4
JNJ Johnson & Johnson 4.2% $131.20 $129.4 $129.4 $125.4 2.0  (-11%) 3
PRGO Perrigo Co. Plc 4.1% $70.03 $77.0 $77.0 $75.6 6.9  (-0%) 1
CORT Corcept Therapeutics Incorporated. 4.0% $13.98 $13.6 $13.6 $15.7 14.8  (8%) -1
MYL Mylan N.V. 3.9% $36.61 $36.7 $36.7 $37.8 3.0  (-16%) -1
PCRX Pacira Pharmaceuticals Inc. 3.6% $45.23 $40.0 $40.0 $37.1 5.9  (-17%) 4
MDCO Medicines Company 3.6% $38.94 $39.6 $39.6 $37.7 29.1  (-5%) 3
MNK Mallinckrodt Plc 3.6% $30.70 $23.6 $23.6 $20.8 13.0  (-16%) 4
NKTR Nektar Therapeutics 3.6% $59.37 $51.0 $51.0 $53.7 8.0  (1%) 2
BMY Bristol-Myers Squibb Company 3.4% $59.53 $58.0 $58.0 $55.7 1.9  (2%) 3
CTLT Catalent Inc 3.2% $40.22 $42.2 $42.2 $41.6 1.9  (-16%) 1
AKRX Akorn Inc. 3.0% $18.82 $18.0 $18.0 $16.6 6.0  (-1%) 5
ENDP Endo International Plc 3.0% $15.83 $12.1 $12.1 $10.2 10.5  (-6%) 5
HZNP Horizon Pharma plc 2.4% $20.91 $17.8 $17.8 $17.3 9.5  (-4%) 4
SUPN Supernus Pharmaceuticals Inc. 2.3% $48.10 $53.1 $53.1 $54.5 13.1  (-1%) 0
ZGNX Zogenix Inc. 2.2% $50.10 $57.1 $57.1 $49.4 9.2  (-7%) 5
PBH Prestige Brands Holdings Inc. 2.2% $37.67 $36.9 $36.9 $36.7 19.5  (9%) 4
AERI Aerie Pharmaceuticals Inc. 1.8% $64.35 $69.7 $69.7 $66.2 13.0  (-33%) 1
DERM Dermira Inc 1.7% $9.86 $10.2 $10.2 $9.9 5.3  (-11%) 0
MYOK MyoKardia Inc. 1.7% $58.35 $57.1 $57.1 $52.5 10.1  (-16%) 4
LCI Lannett Company Inc. 1.6% $13.65 $12.9 $12.9 $14.2 30.8  (5%) -1
OMER Omeros Corporation 1.4% $21.70 $21.0 $21.0 $19.9 18.2  (0%) 4
TXMD TherapeuticsMD Inc. 1.3% $5.19 $6.1 $6.1 $6.5 29.4  (-2%) 0
INVA Innoviva Inc. 1.2% $13.92 $14.1 $14.1 $14.3 15.4  (-5%) 0
COLL Collegium Pharmaceutical Inc. 1.1% $17.68 $19.3 $19.3 $22.5 6.3  (8%) -1
XENT Intersect ENT Inc 0.9% $26.15 $30.8 $30.8 $35.2 2.2  (57%) -2
DEPO Depomed Inc. 0.9% $7.56 $8.4 $8.4 $7.5 10.2  (3%) 3
RVNC Revance Therapeutics Inc. 0.9% $26.45 $28.5 $28.5 $29.1 16.8  (1%) -1
ANIP ANI Pharmaceuticals Inc. 0.8% $56.71 $67.3 $67.3 $67.1 13.9  (-3%) -1
ACRS Aclaris Therapeutics Inc. 0.7% $17.46 $19.0 $19.0 $19.3 23.0  (-5%) 1
WVE Wave Life Sciences Ltd. 0.6% $39.00 $39.0 $39.0 $41.0 18.6  (-7%) -1
CBAY CymaBay Therapeutics Inc. 0.6% $11.64 $12.0 $12.0 $12.9 11.1  (-9%) 1
PRTK Paratek Pharmaceuticals Inc 0.6% $10.45 $10.4 $10.4 $10.5 14.5  (10%) -2
ITCI Intra-Cellular Therapies Inc. 0.5% $21.40 $21.0 $21.0 $20.6 8.7  (-13%) 4
TBPH Theravance Biopharma Inc 0.4% $27.84 $26.0 $26.0 $24.9 38.3  (-3%) 5
PAHC Phibro Animal Health Corporation Class A 0.4% $49.15 $48.4 $48.4 $47.4 2.1  (5%) 4
AMPH Amphastar Pharmaceuticals Inc 0.3% $17.18 $17.1 $17.1 $16.6 11.7  (4%) 4