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

ITB Conmponent Weighting

Ticker
Symbol
Company Name ETF Weight Close Price 10-Day 20-Day 50-Day Short Int Ratio Technical Score
DHI D R HORTON INC 12.1% $43.08 $42.5 $42.5 $43.6 2.1  (-20%) -1
LEN LENNAR A CORP 11.7% $53.07 $52.4 $52.4 $54.5 3.3  (-9%) -0
NVR NVR INC 8.9% $3,114.64 $3,060.5 $3,060.5 $3,070.5 2.3  (-19%) 3
PHM PULTEGROUP INC 6.9% $30.80 $30.7 $30.7 $30.4 5.1  (16%) 5
TOL TOLL BROTHERS INC 5.3% $39.05 $40.3 $40.3 $41.7 3.4  (-12%) -2
HD HOME DEPOT INC 4.8% $199.67 $191.4 $191.4 $185.1 2.0  (-1%) 3
LOW LOWES COMPANIES INC 3.1% $99.16 $95.5 $95.5 $89.3 2.5  (3%) 2
BLD TOPBUILD CORP 2.5% $83.49 $84.2 $84.2 $80.7 2.4  (-0%) 4
TPH TRI POINTE GROUP INC 2.4% $17.11 $17.4 $17.4 $17.2 15.5  (9%) 3
TMHC TAYLOR MORRISON HOME CORP CLASS A 2.4% $21.42 $21.8 $21.8 $22.6 2.6  (-12%) -2
SHW SHERWIN WILLIAMS 2.2% $401.20 $390.0 $390.0 $385.6 3.2  (13%) 1
KBH KB HOME 2.2% $26.21 $26.7 $26.7 $27.1 4.5  (14%) 1
MTH MERITAGE CORP 1.7% $46.00 $45.9 $45.9 $45.3 3.3  (3%) 3
MHK MOHAWK INDUSTRIES INC 1.6% $214.11 $210.6 $210.6 $219.8 1.4  (12%) -2
MAS MASCO CORP 1.6% $38.42 $38.0 $38.0 $38.6 2.2  (14%) -1
CVCO CAVCO INDUSTRIES INC 1.5% $212.25 $200.5 $200.5 $184.8 3.0  (5%) 3
FBHS FORTUNE BRANDS HOME AND SECURITY I 1.4% $56.80 $57.3 $57.3 $57.1 3.1  (14%) 0
LII LENNOX INTERNATIONAL INC 1.4% $211.52 $207.2 $207.2 $202.9 9.1  (4%) 4
MDC MDC HOLDINGS INC 1.3% $31.79 $31.6 $31.6 $30.5 2.5  (38%) 4
LGIH LGI HOMES INC 1.3% $59.64 $60.6 $60.6 $65.9 4.9  (-6%) -1
USG USG CORP 1.3% $43.19 $41.8 $41.8 $41.3 5.0  (21%) 4
WSO WATSCO INC 1.3% $188.41 $185.5 $185.5 $181.8 5.7  (-10%) 5
OC OWENS CORNING 1.2% $65.20 $64.3 $64.3 $69.3 1.6  (28%) -1
EXP EAGLE MATERIALS INC 1.2% $112.25 $109.4 $109.4 $104.9 3.7  (2%) 3
IBP INSTALLED BUILDING PRODUCTS INC 1.2% $62.00 $62.1 $62.1 $59.5 4.7  (-9%) 3
LEG LEGGETT & PLATT INC 1.2% $44.25 $42.5 $42.5 $42.7 8.0  (5%) 2
LPX LOUISIANA PACIFIC CORP 1.2% $28.23 $29.3 $29.3 $29.1 2.6  (9%) 1
TREX TREX INC 1.0% $123.45 $120.6 $120.6 $113.8 2.7  (1%) 4
BECN BEACON ROOFING SUPPLY INC 1.0% $43.90 $42.0 $42.0 $46.1 1.7  (34%) -0
SSD SIMPSON MANUFACTURING INC 1.0% $66.37 $64.4 $64.4 $60.5 8.2  (-0%) 5
FND FLOOR DECOR HOLDINGS INC CLASS A 0.9% $54.99 $49.7 $49.7 $51.2 3.5  (-6%) 3
UFPI UNIVERSAL FOREST PRODUCTS INC 0.9% $37.65 $37.2 $37.2 $34.7 3.0  (41%) 3
MHO M I HOMES INC 0.9% $28.03 $28.3 $28.3 $30.3 4.8  (-0%) -2
JELD JELD WEN HOLDING INC 0.9% $29.10 $28.4 $28.4 $29.0 3.1  (1%) 1
BLDR BUILDERS FIRSTSOURCE INC 0.8% $19.05 $19.6 $19.6 $19.2 1.9  (-16%) -2
DOOR MASONITE INTERNATIONAL CORP 0.8% $72.15 $67.4 $67.4 $64.5 3.1  (-23%) 2
WLH WILLIAM LYON HOMES CLASS A 0.8% $24.90 $24.5 $24.5 $26.3 3.0  (-0%) -2
CCS CENTURY COMMUNITIES INC 0.8% $33.70 $30.7 $30.7 $30.5 2.9  (1%) 2
PGTI PGT INNOVATIONS INC 0.7% $20.55 $20.7 $20.7 $19.3 1.8  (39%) 4
NX QUANEX BUILDING PRODUCTS CORP 0.6% $19.00 $18.1 $18.1 $17.8 10.1  (-9%) 3
AMWD AMERICAN WOODMARK CORP 0.6% $96.50 $96.8 $96.8 $91.8 4.0  (24%) 2
ETH ETHAN ALLEN INC 0.6% $24.40 $24.2 $24.2 $23.5 8.9  (0%) 3
BZH BEAZER HOMES INC 0.6% $15.18 $15.3 $15.3 $15.6 2.1  (2%) 1
LL LUMBER LIQUIDATORS HOLDINGS INC 0.5% $24.58 $22.3 $22.3 $22.4 3.5  (-6%) 1
TTS TILE SHOP HOLDINGS INC 0.5% $7.70 $7.4 $7.4 $6.8 5.6  (13%) 4
HOV HOVNANIAN ENTERPRISES INC CLASS A 0.3% $1.92 $1.9 $1.9 $1.9 9.0  (-3%) 2