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% $81.40 $80.3 $80.3 $78.2 2.8  (4%) 3
KO Coca-Cola Company 10.5% $46.35 $45.7 $45.7 $44.5 2.8  (9%) 4
PEP PepsiCo Inc. 9.0% $113.70 $114.5 $114.5 $109.4 1.9  (62%) 3
WMT Walmart Inc. 8.2% $89.01 $88.4 $88.4 $86.2 5.3  (-1%) 4
PM Philip Morris International Inc. 8.1% $84.40 $84.1 $84.1 $81.8 1.4  (3%) 1
COST Costco Wholesale Corporation 5.4% $218.24 $219.0 $219.0 $211.2 3.3  (-9%) 4
MO Altria Group Inc 4.4% $59.22 $58.2 $58.2 $57.5 3.2  (26%) 2
MDLZ Mondelez International Inc. Class A 3.9% $42.16 $42.6 $42.6 $41.4 1.3  (-11%) 3
CL Colgate-Palmolive Company 3.8% $65.93 $66.2 $66.2 $64.9 2.7  (-6%) 2
WBA Walgreens Boots Alliance Inc 3.8% $66.17 $66.3 $66.3 $64.9 4.1  (15%) 3
STZ Constellation Brands Inc. Class A 2.7% $214.78 $213.9 $213.9 $220.8 2.7  (-6%) -2
KMB Kimberly-Clark Corporation 2.5% $111.21 $108.8 $108.8 $105.4 6.1  (-0%) 4
KHC Kraft Heinz Company 2.2% $60.00 $61.2 $61.2 $61.3 6.1  (-10%) 1
SYY Sysco Corporation 2.1% $70.03 $70.0 $70.0 $68.4 6.0  (3%) 4
EL Estee Lauder Companies Inc. Class A 2.1% $132.17 $138.0 $138.0 $144.6 5.4  (12%) -1
ADM Archer-Daniels-Midland Company 1.7% $50.24 $48.2 $48.2 $46.7 2.7  (6%) 4
GIS General Mills Inc. 1.7% $45.27 $44.7 $44.7 $44.4 6.4  (1%) 4
MNST Monster Beverage Corporation 1.5% $60.98 $60.6 $60.6 $57.7 3.3  (-16%) 3
KR Kroger Co. 1.5% $29.82 $28.9 $28.9 $27.7 5.8  (-1%) 5
TSN Tyson Foods Inc. Class A 1.4% $59.70 $62.2 $62.2 $66.4 2.4  (5%) -2
CLX Clorox Company 1.0% $140.21 $135.2 $135.2 $131.2 7.2  (19%) 5
CAG Conagra Brands Inc. 1.0% $36.78 $36.5 $36.5 $36.9 5.3  (20%) 2
K Kellogg Company 1.0% $71.30 $70.7 $70.7 $68.6 10.8  (-5%) 4
BF.B Brown-Forman Corporation Class B 1.0% $53.63 $52.9 $52.9 $52.2   2
SJM J. M. Smucker Company 0.9% $110.70 $110.6 $110.6 $108.4 11.6  (1%) 3
HSY Hershey Company 0.9% $97.34 $95.3 $95.3 $93.7 4.8  (11%) 3
MKC McCormick & Company Incorporated 0.9% $120.82 $118.9 $118.9 $112.4 14.9  (0%) 4
TAP Molson Coors Brewing Company Class B 0.8% $66.54 $66.4 $66.4 $66.4 1.2  (-7%) 1
CHD Church & Dwight Co. Inc. 0.8% $55.57 $55.4 $55.4 $52.6 9.1  (-4%) 4
HRL Hormel Foods Corporation 0.7% $37.12 $36.9 $36.9 $36.6 16.8  (9%) 3
CPB Campbell Soup Company 0.5% $42.28 $41.2 $41.2 $39.1 11.7  (-12%) 3
COTY Coty Inc. Class A 0.5% $12.41 $13.7 $13.7 $13.9 16.2  (9%) 0