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

XHB Conmponent Weighting

Ticker
Symbol
Company Name ETF Weight Close Price 10-Day 20-Day 50-Day Short Int Ratio Technical Score
HD Home Depot Inc. 4.9% $198.08 $198.9 $198.9 $197.1 2.0  (-16%) 2
PHM PulteGroup Inc. 4.9% $29.33 $29.6 $29.6 $29.8 3.7  (-1%) -1
NVR NVR Inc. 4.9% $2,757.00 $2,879.7 $2,879.7 $2,990.1 2.5  (10%) -1
DHI D.R. Horton Inc. 4.8% $45.00 $43.0 $43.0 $42.3 1.9  (7%) 2
LOW Lowe's Companies Inc. 4.7% $99.94 $99.3 $99.3 $98.3 2.4  (-5%) 2
WHR Whirlpool Corporation 4.6% $130.80 $139.1 $139.1 $144.8 1.7  (22%) -2
TOL Toll Brothers Inc. 4.5% $36.28 $36.3 $36.3 $37.4 3.5  (-2%) -2
JCI Johnson Controls International plc 4.4% $37.33 $36.3 $36.3 $35.1 6.6  (11%) 4
LEN Lennar Corporation Class A 4.3% $53.45 $53.1 $53.1 $52.8 3.9  (-9%) 0
MAS Masco Corporation 4.3% $39.12 $38.9 $38.9 $38.4 2.2  (9%) 2
MHK Mohawk Industries Inc. 4.2% $184.29 $203.6 $203.6 $208.7 1.7  (7%) -2
WSM Williams-Sonoma Inc. 4.2% $59.50 $59.8 $59.8 $60.6 16.5  (3%) 2
FBHS Fortune Brands Home & Security Inc. 4.2% $55.96 $56.1 $56.1 $55.9 1.5  (-17%) 1
BBBY Bed Bath & Beyond Inc. 3.8% $18.44 $18.9 $18.9 $19.4 8.6  (4%) 2
OC Owens Corning 3.7% $60.36 $63.0 $63.0 $63.8 1.7  (-7%) -1
ALLE Allegion PLC 3.3% $82.56 $80.6 $80.6 $79.6 6.2  (-2%) 3
LII Lennox International Inc. 3.2% $216.97 $214.2 $214.2 $209.1 4.8  (-11%) 3
USG USG Corporation 3.0% $43.19 $43.2 $43.2 $42.9 2.6  (-1%) 2
AOS A. O. Smith Corporation 2.8% $58.13 $59.2 $59.2 $60.7 3.1  (9%) -2
LEG Leggett & Platt Incorporated 2.7% $43.93 $44.5 $44.5 $44.2 6.0  (8%) 2
TPX Tempur Sealy International Inc 2.6% $55.77 $51.6 $51.6 $50.5 9.2  (-10%) 3
TPH TRI Pointe Group Inc 2.0% $14.42 $15.6 $15.6 $16.4 7.3  (-7%) -1
TMHC Taylor Morrison Home Corp. Class A 2.0% $19.96 $20.4 $20.4 $20.9 1.3  (-10%) -2
LGIH LGI Homes Inc. 1.7% $58.66 $56.2 $56.2 $57.9 11.6  (-1%) 0
AAN Aaron's Inc. 1.7% $47.86 $45.5 $45.5 $44.1 3.6  (3%) 4
TREX Trex Company Inc. 1.4% $78.73 $70.8 $70.8 $83.7 4.9  (4%) 0
AWI Armstrong World Industries Inc. 1.4% $68.15 $68.1 $68.1 $65.4 1.2  (9%) 4
MDC M.D.C. Holdings Inc. 1.1% $31.33 $30.9 $30.9 $31.1 4.5  (4%) 1
BLD TopBuild Corp. 1.0% $78.08 $78.1 $78.1 $80.5 5.4  (-2%) 1
HELE Helen of Troy Limited 0.9% $112.35 $114.4 $114.4 $104.9 6.8  (-7%) 4
IBP Installed Building Products Inc. 0.8% $52.75 $54.6 $54.6 $57.7 8.0  (-3%) -1
WLH William Lyon Homes Class A 0.7% $21.61 $22.6 $22.6 $23.3 3.0  (23%) -2
CCS Century Communities Inc. 0.5% $31.10 $31.4 $31.4 $31.4 3.7  (-8%) 0
MHO M/I Homes Inc. 0.5% $26.38 $26.6 $26.6 $27.1 2.6  (-1%) -2
CVCO Cavco Industries Inc. 0.4% $228.20 $216.9 $216.9 $213.9 2.0  (-15%) 3