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% $69.02 $67.1 $67.1 $67.0 2.5  (-17%) 2
PX Praxair Inc. 6.9% $157.15 $163.7 $163.7 $160.9 4.1  (9%) 1
APD Air Products and Chemicals Inc. 5.6% $160.48 $158.4 $158.4 $159.8 1.2  (-7%) 1
LYB LyondellBasell Industries NV 5.4% $113.38 $109.6 $109.6 $111.0 4.1  (-8%) 3
ECL Ecolab Inc. 5.2% $147.84 $143.9 $143.9 $143.2 5.4  (-10%) 3
PPG PPG Industries Inc. 4.4% $109.21 $107.6 $107.6 $105.3 4.6  (-3%) 2
SHW Sherwin-Williams Company 4.3% $444.05 $433.6 $433.6 $413.4 2.7  (1%) 4
NEM Newmont Mining Corporation 3.4% $35.71 $36.7 $36.7 $37.5 1.5  (8%) -1
IP International Paper Company 3.4% $53.16 $52.8 $52.8 $54.0 3.1  (1%) 1
FCX Freeport-McMoRan Inc. 3.3% $15.31 $16.0 $16.0 $16.7 1.1  (-22%) -1
NUE Nucor Corporation 3.2% $63.41 $65.5 $65.5 $65.2 1.7  (-2%) 1
VMC Vulcan Materials Company 2.5% $112.91 $119.6 $119.6 $125.6 3.4  (-2%) -1
WRK WestRock Co. 2.4% $55.56 $56.9 $56.9 $58.1 1.4  (-22%) -2
EMN Eastman Chemical Company 2.4% $101.74 $100.8 $100.8 $102.6 3.9  (-15%) -1
BLL Ball Corporation 2.2% $41.25 $39.1 $39.1 $37.6 7.7  (7%) 4
MLM Martin Marietta Materials Inc. 2.0% $203.52 $215.1 $215.1 $221.8 3.4  (6%) -1
IFF International Flavors & Fragrances Inc. 1.8% $134.45 $130.7 $130.7 $127.2 5.2  (7%) 4
ALB Albemarle Corporation 1.8% $100.76 $94.1 $94.1 $94.1 9.5  (11%) 2
FMC FMC Corporation 1.8% $90.24 $87.8 $87.8 $88.4 3.5  (-31%) 1
PKG Packaging Corporation of America 1.7% $111.56 $113.3 $113.3 $115.6 1.8  (-4%) -1
MOS Mosaic Company 1.6% $32.06 $29.5 $29.5 $28.9 3.2  (-13%) 4
AVY Avery Dennison Corporation 1.5% $111.44 $109.1 $109.1 $105.9 1.7  (-7%) 2
CF CF Industries Holdings Inc. 1.5% $49.75 $45.1 $45.1 $44.1 5.4  (-8%) 5
SEE Sealed Air Corporation 1.2% $41.46 $42.6 $42.6 $43.2 5.7  (-15%) -0