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% $199.67 $191.4 $191.4 $185.1 2.0  (-1%) 3
PHM PulteGroup Inc. 4.9% $30.80 $30.7 $30.7 $30.4 5.1  (16%) 5
NVR NVR Inc. 4.9% $3,114.64 $3,060.5 $3,060.5 $3,070.5 2.3  (-19%) 3
DHI D.R. Horton Inc. 4.8% $43.08 $42.5 $42.5 $43.6 2.1  (-20%) -1
LOW Lowe's Companies Inc. 4.7% $99.16 $95.5 $95.5 $89.3 2.5  (3%) 2
WHR Whirlpool Corporation 4.6% $155.47 $153.1 $153.1 $153.3 3.2  (26%) -2
TOL Toll Brothers Inc. 4.5% $39.05 $40.3 $40.3 $41.7 3.4  (-12%) -2
JCI Johnson Controls International plc 4.4% $34.89 $34.8 $34.8 $34.9 6.2  (22%) -1
LEN Lennar Corporation Class A 4.3% $53.07 $52.4 $52.4 $54.5 3.3  (-9%) -0
MAS Masco Corporation 4.3% $38.42 $38.0 $38.0 $38.6 2.2  (14%) -1
MHK Mohawk Industries Inc. 4.2% $214.11 $210.6 $210.6 $219.8 1.4  (12%) -2
WSM Williams-Sonoma Inc. 4.2% $60.85 $55.8 $55.8 $51.8 15.2  (-4%) 4
FBHS Fortune Brands Home & Security Inc. 4.2% $56.80 $57.3 $57.3 $57.1 3.1  (14%) 0
BBBY Bed Bath & Beyond Inc. 3.8% $19.82 $18.6 $18.6 $18.3 7.2  (1%) 4
OC Owens Corning 3.7% $65.20 $64.3 $64.3 $69.3 1.6  (28%) -1
ALLE Allegion PLC 3.3% $81.79 $79.3 $79.3 $80.2 5.0  (17%) 1
LII Lennox International Inc. 3.2% $211.52 $207.2 $207.2 $202.9 9.1  (4%) 4
USG USG Corporation 3.0% $43.19 $41.8 $41.8 $41.3 5.0  (21%) 4
AOS A. O. Smith Corporation 2.8% $63.97 $63.9 $63.9 $63.6 3.6  (-5%) -1
LEG Leggett & Platt Incorporated 2.7% $44.25 $42.5 $42.5 $42.7 8.0  (5%) 2
TPX Tempur Sealy International Inc 2.6% $50.20 $49.2 $49.2 $46.6 8.0  (26%) 3
TPH TRI Pointe Group Inc 2.0% $17.11 $17.4 $17.4 $17.2 15.5  (9%) 3
TMHC Taylor Morrison Home Corp. Class A 2.0% $21.42 $21.8 $21.8 $22.6 2.6  (-12%) -2
LGIH LGI Homes Inc. 1.7% $59.64 $60.6 $60.6 $65.9 4.9  (-6%) -1
AAN Aaron's Inc. 1.7% $44.00 $41.2 $41.2 $42.7 4.4  (-10%) 1
TREX Trex Company Inc. 1.4% $123.45 $120.6 $120.6 $113.8 2.7  (1%) 4
AWI Armstrong World Industries Inc. 1.4% $63.50 $62.1 $62.1 $59.0 4.6  (-4%) 3
MDC M.D.C. Holdings Inc. 1.1% $31.79 $31.6 $31.6 $30.5 2.5  (38%) 4
BLD TopBuild Corp. 1.0% $83.49 $84.2 $84.2 $80.7 2.4  (-0%) 4
HELE Helen of Troy Limited 0.9% $98.80 $93.4 $93.4 $90.2 5.9  (32%) 5
IBP Installed Building Products Inc. 0.8% $62.00 $62.1 $62.1 $59.5 4.7  (-9%) 3
WLH William Lyon Homes Class A 0.7% $24.90 $24.5 $24.5 $26.3 3.0  (-0%) -2
CCS Century Communities Inc. 0.5% $33.70 $30.7 $30.7 $30.5 2.9  (1%) 2
MHO M/I Homes Inc. 0.5% $28.03 $28.3 $28.3 $30.3 4.8  (-0%) -2
CVCO Cavco Industries Inc. 0.4% $212.25 $200.5 $200.5 $184.8 3.0  (5%) 3