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% $61.56 $60.5 $60.5 $58.9 2.0  (-2%) 4
JAZZ Jazz Pharmaceuticals Plc 4.5% $177.23 $170.6 $170.6 $161.2 2.2  (-3%) 3
LLY Eli Lilly and Company 4.5% $86.35 $84.2 $84.2 $81.6 2.7  (20%) 4
AGN Allergan plc 4.3% $173.95 $158.9 $158.9 $158.1 1.9  (15%) 2
PFE Pfizer Inc. 4.3% $36.16 $36.1 $36.1 $36.0 2.6  (-3%) 1
ZTS Zoetis Inc. Class A 4.3% $88.15 $85.2 $85.2 $84.1 1.7  (1%) 4
JNJ Johnson & Johnson 4.2% $122.41 $122.3 $122.3 $125.2 3.0  (-3%) -1
PRGO Perrigo Co. Plc 4.1% $74.83 $74.5 $74.5 $77.3 3.2  (6%) -1
CORT Corcept Therapeutics Incorporated. 4.0% $19.33 $18.6 $18.6 $17.7 12.7  (2%) 4
MYL Mylan N.V. 3.9% $39.51 $39.9 $39.9 $39.4 3.4  (-1%) 1
PCRX Pacira Pharmaceuticals Inc. 3.6% $38.45 $35.8 $35.8 $34.8 7.2  (-1%) 4
MDCO Medicines Company 3.6% $36.69 $34.1 $34.1 $31.7 25.1  (-2%) 3
MNK Mallinckrodt Plc 3.6% $18.83 $17.3 $17.3 $15.3 6.7  (0%) 3
NKTR Nektar Therapeutics 3.6% $56.41 $69.7 $69.7 $81.0 4.8  (2%) -2
BMY Bristol-Myers Squibb Company 3.4% $53.63 $52.7 $52.7 $53.6 1.5  (6%) 1
CTLT Catalent Inc 3.2% $41.54 $39.7 $39.7 $40.2 3.6  (12%) 1
AKRX Akorn Inc. 3.0% $15.04 $14.2 $14.2 $15.0 2.3  (-17%) 1
ENDP Endo International Plc 3.0% $8.91 $6.9 $6.9 $6.2 6.0  (3%) 4
HZNP Horizon Pharma plc 2.4% $17.72 $16.3 $16.3 $14.9 4.3  (7%) 3
SUPN Supernus Pharmaceuticals Inc. 2.3% $53.75 $55.5 $55.5 $51.0 5.4  (25%) 3
ZGNX Zogenix Inc. 2.2% $44.80 $42.4 $42.4 $40.5 7.8  (6%) 4
PBH Prestige Brands Holdings Inc. 2.2% $35.43 $34.6 $34.6 $32.9 5.3  (-1%) 2
AERI Aerie Pharmaceuticals Inc. 1.8% $64.20 $56.1 $56.1 $53.7 15.4  (0%) 3
DERM Dermira Inc 1.7% $10.00 $9.5 $9.5 $9.2 4.8  (-4%) 1
MYOK MyoKardia Inc. 1.7% $48.95 $48.3 $48.3 $48.4 8.3  (-3%) -1
LCI Lannett Company Inc. 1.6% $16.55 $16.6 $16.6 $16.1 17.3  (2%) 3
OMER Omeros Corporation 1.4% $19.69 $19.7 $19.7 $17.3 6.7  (-2%) 3
TXMD TherapeuticsMD Inc. 1.3% $6.88 $6.5 $6.5 $6.0 20.0  (-4%) 4
INVA Innoviva Inc. 1.2% $14.52 $14.6 $14.6 $15.1 15.7  (4%) 0
COLL Collegium Pharmaceutical Inc. 1.1% $26.32 $25.0 $25.0 $24.3 3.9  (-3%) 1
XENT Intersect ENT Inc 0.9% $37.00 $40.1 $40.1 $39.8 0.5  (-15%) -0
DEPO Depomed Inc. 0.9% $6.97 $6.7 $6.7 $6.7 5.1  (1%) -1
RVNC Revance Therapeutics Inc. 0.9% $31.05 $30.0 $30.0 $30.1 9.8  (9%) -1
ANIP ANI Pharmaceuticals Inc. 0.8% $66.34 $64.2 $64.2 $61.6 8.7  (6%) 4
ACRS Aclaris Therapeutics Inc. 0.7% $19.78 $19.0 $19.0 $18.3 26.7  (-0%) 3
WVE Wave Life Sciences Ltd. 0.6% $48.95 $46.2 $46.2 $44.0 20.6  (-5%) 4
CBAY CymaBay Therapeutics Inc. 0.6% $13.10 $12.5 $12.5 $12.3 4.8  (-1%) 2
PRTK Paratek Pharmaceuticals Inc 0.6% $10.85 $10.7 $10.7 $11.4 7.0  (13%) -1
ITCI Intra-Cellular Therapies Inc. 0.5% $21.26 $22.4 $22.4 $20.7 9.9  (-5%) 3
TBPH Theravance Biopharma Inc 0.4% $24.29 $23.9 $23.9 $23.8 29.8  (4%) 1
PAHC Phibro Animal Health Corporation Class A 0.4% $46.90 $45.8 $45.8 $43.9 1.4  (-30%) 4
AMPH Amphastar Pharmaceuticals Inc 0.3% $16.96 $16.5 $16.5 $17.7 5.5  (2%) 1