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

XRT Conmponent Weighting

Ticker
Symbol
Company Name ETF Weight Close Price 10-Day 20-Day 50-Day Short Int Ratio Technical Score
GES Guess? Inc. 1.9% $22.97 $22.5 $22.5 $22.2 9.4  (-10%) 3
TLRD Tailored Brands Inc. 1.6% $21.75 $21.6 $21.6 $25.8 7.5  (43%) 0
HIBB Hibbett Sports Inc. 1.5% $23.75 $23.6 $23.6 $23.9 19.4  (-2%) 1
ULTA Ulta Beauty Inc 1.5% $236.15 $247.1 $247.1 $246.9 3.0  (-15%) 0
DSW DSW Inc. Class A 1.5% $27.60 $27.4 $27.4 $26.4 8.6  (5%) 4
ANF Abercrombie & Fitch Co. Class A 1.4% $26.08 $25.2 $25.2 $25.4 7.6  (11%) 1
SVU SUPERVALU INC. 1.4% $32.24 $26.6 $26.6 $22.9 2.4  (-2%) 4
URBN Urban Outfitters Inc. 1.4% $47.54 $45.5 $45.5 $45.6 10.3  (1%) 4
RCII Rent-A-Center Inc 1.4% $14.72 $14.8 $14.8 $13.7 8.0  (0%) 4
DG Dollar General Corporation 1.4% $102.98 $99.1 $99.1 $97.7 3.6  (20%) 3
SFLY Shutterfly Inc. 1.4% $77.65 $85.9 $85.9 $90.4 9.0  (-9%) 1
BKE Buckle Inc. 1.3% $25.25 $24.0 $24.0 $25.7 28.1  (-5%) 2
M Macy's Inc 1.3% $40.56 $38.7 $38.7 $38.2 6.4  (-10%) 5
BURL Burlington Stores Inc. 1.3% $159.29 $153.7 $153.7 $152.5 3.5  (-2%) 3
OLLI Ollie's Bargain Outlet Holdings Inc 1.3% $71.80 $72.2 $72.2 $73.1 8.8  (-0%) -1
CHS Chico's FAS Inc. 1.3% $9.51 $8.8 $8.8 $8.6 5.4  (10%) 4
GCO Genesco Inc. 1.3% $41.50 $40.6 $40.6 $40.9 9.0  (-6%) 3
TSCO Tractor Supply Company 1.3% $81.06 $78.8 $78.8 $77.3 3.0  (2%) 4
NTRI Nutrisystem Inc. 1.3% $40.55 $40.2 $40.2 $38.7 5.8  (-4%) 4
AEO American Eagle Outfitters Inc. 1.3% $26.64 $24.9 $24.9 $24.3 4.0  (17%) 4
DLTR Dollar Tree Inc. 1.3% $92.70 $88.9 $88.9 $86.7 2.2  (7%) 3
ORLY O'Reilly Automotive Inc. 1.3% $318.78 $301.2 $301.2 $288.7 3.0  (-15%) 4
ROST Ross Stores Inc. 1.3% $92.17 $87.7 $87.7 $85.9 2.3  (-5%) 4
FIVE Five Below Inc. 1.3% $104.24 $101.2 $101.2 $97.3 3.6  (-18%) 4
COST Costco Wholesale Corporation 1.3% $218.24 $219.0 $219.0 $211.2 3.3  (-9%) 4
BBY Best Buy Co. Inc. 1.3% $78.68 $76.1 $76.1 $74.7 8.1  (-1%) 4
GRPN Groupon Inc. 1.3% $4.46 $4.7 $4.7 $4.6 4.0  (5%) 1
EXPE Expedia Group Inc. 1.3% $132.74 $130.0 $130.0 $125.7 4.6  (-5%) 4
KR Kroger Co. 1.3% $29.82 $28.9 $28.9 $27.7 5.8  (-1%) 5
DKS Dick's Sporting Goods Inc. 1.3% $34.65 $34.1 $34.1 $35.4 6.0  (1%) 1
KMX CarMax Inc. 1.3% $74.17 $75.8 $75.8 $74.5 10.7  (-1%) 2
EXPR Express Inc. 1.3% $10.37 $9.8 $9.8 $9.8 10.5  (-1%) 4
TGT Target Corporation 1.3% $82.62 $79.6 $79.6 $77.8 7.1  (-0%) 5
MNRO Monro Inc 1.3% $69.65 $67.5 $67.5 $62.5 15.4  (-8%) 5
TJX TJX Companies Inc 1.3% $99.81 $97.2 $97.2 $95.6 3.1  (-11%) 3
JWN Nordstrom Inc. 1.2% $52.55 $52.2 $52.2 $51.9 9.3  (7%) 3
FL Foot Locker Inc. 1.2% $47.61 $49.7 $49.7 $52.9 4.9  (3%) -1
KSS Kohl's Corporation 1.2% $75.11 $72.5 $72.5 $73.1 11.2  (-2%) 4
TIF Tiffany & Co. 1.2% $137.10 $136.1 $136.1 $134.5 3.1  (-5%) 4
ABG Asbury Automotive Group Inc. 1.2% $75.40 $70.5 $70.5 $71.5 5.9  (1%) 4
AMZN Amazon.com Inc. 1.2% $1,898.52 $1,829.8 $1,829.8 $1,751.6 0.8  (9%) 3
BKNG Booking Holdings Inc. 1.2% $1,942.39 $2,034.8 $2,034.8 $2,072.1 3.6  (8%) -2
PAG Penske Automotive Group Inc. 1.2% $51.19 $50.1 $50.1 $49.7 8.5  (2%) 4
LEXEA Liberty Expedia Holdings Inc Class A 1.2% $47.40 $47.4 $47.4 $46.0 3.3  (-18%) 3
AAP Advance Auto Parts Inc. 1.2% $147.79 $142.2 $142.2 $137.8 4.9  (-3%) 4
WMT Walmart Inc. 1.2% $89.01 $88.4 $88.4 $86.2 5.3  (-1%) 4
SBH Sally Beauty Holdings Inc. 1.2% $14.50 $15.6 $15.6 $15.7 13.4  (-9%) -2
SFM Sprouts Farmers Markets Inc. 1.2% $23.08 $22.3 $22.3 $22.0 11.4  (3%) 4
AZO AutoZone Inc. 1.2% $736.29 $709.6 $709.6 $689.4 3.0  (-8%) 4
PSMT PriceSmart Inc. 1.2% $82.85 $80.8 $80.8 $85.2 9.7  (-13%) 2
CVS CVS Health Corporation 1.2% $68.57 $66.5 $66.5 $67.0 8.6  (8%) 1
RAD Rite Aid Corporation 1.2% $1.54 $1.8 $1.8 $1.8 16.3  (-3%) 2
NFLX Netflix Inc. 1.2% $349.36 $362.6 $362.6 $377.4 0.9  (1%) 0
ODP Office Depot Inc. 1.2% $3.03 $2.7 $2.7 $2.7 6.0  (-10%) 4
JCP J. C. Penney Company Inc. 1.1% $2.43 $2.4 $2.4 $2.5 10.6  (0%) -1
AN AutoNation Inc. 1.1% $47.05 $47.8 $47.8 $48.5 4.5  (-6%) 0
PLCE Children's Place Inc. 1.1% $130.15 $123.5 $123.5 $126.3 6.0  (3%) 2
LAD Lithia Motors Inc. Class A 1.1% $87.32 $90.5 $90.5 $95.7 5.0  (33%) -2
WBA Walgreens Boots Alliance Inc 1.1% $66.17 $66.3 $66.3 $64.9 4.1  (15%) 3
GPI Group 1 Automotive Inc. 1.1% $76.25 $69.5 $69.5 $70.2 8.4  (0%) 3
CASY Casey's General Stores Inc. 1.1% $112.58 $109.9 $109.9 $105.3 11.7  (-2%) 5
TRIP TripAdvisor Inc. 1.1% $55.04 $57.9 $57.9 $57.2 8.9  (-2%) 2
GPS Gap Inc. 1.1% $31.18 $30.1 $30.1 $31.1 5.0  (-1%) 2
DDS Dillard's Inc. Class A 1.1% $88.17 $83.3 $83.3 $88.2 18.1  (-3%) 2
BIG Big Lots Inc. 1.1% $47.57 $44.0 $44.0 $42.5 8.7  (-18%) 4
W Wayfair Inc. Class A 1.1% $119.72 $118.9 $118.9 $113.7 6.4  (-10%) 3
GME GameStop Corp. Class A 1.0% $15.21 $14.9 $14.9 $14.7 19.5  (-12%) 5
MUSA Murphy USA Inc. 1.0% $84.78 $80.9 $80.9 $76.8 9.4  (-23%) 4
QRTEA Qurate Retail Inc. Class A 1.0% $23.16 $21.8 $21.8 $21.5 5.4  (-6%) 2
MIK Michaels Companies Inc 1.0% $20.38 $20.1 $20.1 $19.7 11.9  (-10%) 3
LB L Brands Inc. 1.0% $31.51 $31.8 $31.8 $34.6 4.9  (-0%) -1
PRTY Party City Holdco Inc. 1.0% $15.90 $16.0 $16.0 $15.7 7.9  (-18%) 3
SIG Signet Jewelers Limited 1.0% $59.71 $59.6 $59.6 $56.8 8.4  (2%) 3
CAL Caleres Inc. 0.9% $35.09 $34.5 $34.5 $34.7 10.3  (23%) 3
CONN Conn's Inc. 0.9% $35.45 $35.8 $35.8 $33.9 10.5  (1%) 3
PETS PetMed Express Inc. 0.9% $37.99 $37.9 $37.9 $40.2 4.0  (-3%) 2
CWH Camping World Holdings Inc. Class A 0.9% $20.91 $23.2 $23.2 $23.6 8.2  (-11%) -2
EYE National Vision Holdings Inc. 0.9% $44.79 $40.8 $40.8 $39.1 1.5  (-7%) 4
OSTK Overstock.com Inc. 0.8% $38.60 $38.1 $38.1 $36.5 5.4  (7%) 2
HZO MarineMax Inc. 0.7% $19.25 $19.9 $19.9 $21.1 4.3  (-4%) -1
LTRPA Liberty TripAdvisor Holdings Inc Class A 0.6% $15.75 $16.8 $16.8 $16.6 4.1  (-11%) 1
SAH Sonic Automotive Inc. Class A 0.5% $21.25 $19.7 $19.7 $21.0 12.8  (-6%) 4
WMK Weis Markets Inc. 0.5% $48.81 $51.2 $51.2 $53.0 20.0  (2%) 1
IMKTA Ingles Markets Incorporated Class A 0.4% $29.95 $29.3 $29.3 $30.0 23.4  (3%) -1