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

XLP Conmponent Weighting

Ticker
Symbol
Company Name ETF Weight Close Price 10-Day 20-Day 50-Day Short Int Ratio Technical Score
PG Procter & Gamble Company 11.7% $75.99 $74.8 $74.8 $74.8 3.5  (-6%) 2
KO Coca-Cola Company 10.5% $43.58 $43.1 $43.1 $43.1 3.3  (-2%) 2
PEP PepsiCo Inc. 9.0% $105.13 $101.1 $101.1 $102.2 1.3  (-14%) 1
WMT Walmart Inc. 8.2% $83.79 $83.8 $83.8 $85.3 3.6  (0%) -1
PM Philip Morris International Inc. 8.1% $80.85 $79.7 $79.7 $85.3 2.0  (7%) -2
COST Costco Wholesale Corporation 5.4% $205.12 $200.2 $200.2 $195.7 4.3  (-0%) 4
MO Altria Group Inc 4.4% $56.70 $56.3 $56.3 $57.7 2.8  (5%) 1
MDLZ Mondelez International Inc. Class A 3.9% $40.40 $39.7 $39.7 $40.0 1.6  (25%) 1
CL Colgate-Palmolive Company 3.8% $63.31 $63.0 $63.0 $65.4 2.5  (-10%) -1
WBA Walgreens Boots Alliance Inc 3.8% $64.87 $63.7 $63.7 $64.2 2.7  (-24%) -0
STZ Constellation Brands Inc. Class A 2.7% $232.18 $223.1 $223.1 $224.9 2.6  (11%) 3
KMB Kimberly-Clark Corporation 2.5% $102.04 $103.2 $103.2 $104.1 9.8  (-2%) 0
KHC Kraft Heinz Company 2.2% $60.67 $58.1 $58.1 $58.6 4.4  (7%) 1
SYY Sysco Corporation 2.1% $66.48 $65.2 $65.2 $63.3 4.9  (12%) 4
EL Estee Lauder Companies Inc. Class A 2.1% $156.37 $150.6 $150.6 $147.5 2.7  (24%) 3
ADM Archer-Daniels-Midland Company 1.7% $45.24 $44.7 $44.7 $44.7 1.5  (-23%) 2
GIS General Mills Inc. 1.7% $44.51 $42.9 $42.9 $43.4 5.8  (4%) 2
MNST Monster Beverage Corporation 1.5% $56.05 $52.0 $52.0 $53.4 1.6  (-10%) 1
KR Kroger Co. 1.5% $26.16 $25.0 $25.0 $24.6 7.3  (-18%) 4
DPS Dr Pepper Snapple Group Inc. 1.5% $120.63 $120.2 $120.2 $119.9 10.1  (5%) 4
TSN Tyson Foods Inc. Class A 1.4% $70.99 $69.4 $69.4 $69.4 3.1  (-11%) 0
CLX Clorox Company 1.0% $127.89 $122.7 $122.7 $122.0 6.3  (9%) 3
CAG Conagra Brands Inc. 1.0% $38.20 $37.4 $37.4 $37.2 3.7  (15%) 2
K Kellogg Company 1.0% $66.60 $63.7 $63.7 $62.4 7.0  (5%) 3
BF.B Brown-Forman Corporation Class B 1.0% $52.94 $55.7 $55.7 $55.7   -2
SJM J. M. Smucker Company 0.9% $103.75 $107.0 $107.0 $113.1 10.2  (13%) 0
HSY Hershey Company 0.9% $92.14 $91.6 $91.6 $93.1 4.1  (2%) -1
MKC McCormick & Company Incorporated 0.9% $105.86 $103.0 $103.0 $104.5 13.5  (-1%) 0
TAP Molson Coors Brewing Company Class B 0.8% $66.72 $62.4 $62.4 $66.0 1.3  (14%) 1
CHD Church & Dwight Co. Inc. 0.8% $49.80 $47.6 $47.6 $47.8 5.0  (25%) 2
HRL Hormel Foods Corporation 0.7% $36.11 $36.1 $36.1 $35.9 17.5  (-1%) 3
CPB Campbell Soup Company 0.5% $36.51 $34.5 $34.5 $38.7 9.9  (14%) 0
COTY Coty Inc. Class A 0.5% $14.26 $13.7 $13.7 $15.5 7.5  (16%) 0