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

XLB Conmponent Weighting

Ticker
Symbol
Company Name ETF Weight Close Price 10-Day 20-Day 50-Day Short Int Ratio Technical Score
DWDP DowDuPont Inc. 21.7% $68.38 $67.5 $67.5 $66.2 2.6  (16%) 1
PX Praxair Inc. 6.9% $161.55 $159.0 $159.0 $154.6 5.1  (-3%) 4
APD Air Products and Chemicals Inc. 5.6% $165.72 $166.0 $166.0 $164.9 1.9  (2%) 2
LYB LyondellBasell Industries NV 5.4% $114.15 $115.6 $115.6 $109.9 4.0  (3%) 2
ECL Ecolab Inc. 5.2% $145.40 $145.3 $145.3 $145.1 6.2  (-3%) 3
PPG PPG Industries Inc. 4.4% $103.96 $103.1 $103.1 $105.9 2.9  (-14%) -2
SHW Sherwin-Williams Company 4.3% $401.20 $390.0 $390.0 $385.6 3.2  (13%) 1
NEM Newmont Mining Corporation 3.4% $39.16 $39.0 $39.0 $39.7 1.9  (4%) 1
IP International Paper Company 3.4% $56.84 $56.2 $56.2 $54.1 3.3  (6%) 3
FCX Freeport-McMoRan Inc. 3.3% $17.58 $17.4 $17.4 $17.0 1.7  (-22%) 1
NUE Nucor Corporation 3.2% $68.53 $65.7 $65.7 $63.8 2.2  (-10%) 3
VMC Vulcan Materials Company 2.5% $131.86 $129.2 $129.2 $122.4 3.8  (15%) 3
WRK WestRock Co. 2.4% $60.50 $60.7 $60.7 $61.9 2.0  (0%) -1
EMN Eastman Chemical Company 2.4% $107.93 $107.5 $107.5 $106.3 4.3  (35%) 2
BLL Ball Corporation 2.2% $36.88 $37.6 $37.6 $38.8 4.3  (3%) -2
MLM Martin Marietta Materials Inc. 2.0% $230.20 $223.6 $223.6 $211.5 3.6  (1%) 3
IFF International Flavors & Fragrances Inc. 1.8% $124.51 $124.9 $124.9 $131.7 1.5  (5%) -1
ALB Albemarle Corporation 1.8% $93.66 $96.8 $96.8 $96.9 7.3  (20%) -1
FMC FMC Corporation 1.8% $90.30 $89.4 $89.4 $85.5 2.0  (6%) 3
PKG Packaging Corporation of America 1.7% $120.78 $121.2 $121.2 $117.4 2.2  (-19%) 2
MOS Mosaic Company 1.6% $29.48 $28.4 $28.4 $27.0 2.7  (10%) 4
AVY Avery Dennison Corporation 1.5% $106.27 $107.5 $107.5 $106.6 2.1  (14%) -1
CF CF Industries Holdings Inc. 1.5% $44.92 $42.1 $42.1 $40.1 5.4  (15%) 4
SEE Sealed Air Corporation 1.2% $44.07 $44.3 $44.3 $44.1 8.2  (5%) 1