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% $21.66 $23.1 $23.1 $23.3 7.2  (-0%) 2
TLRD Tailored Brands Inc. 1.6% $26.19 $33.2 $33.2 $31.4 6.7  (-1%) 2
FINL Finish Line Inc. Class A 1.6% $13.48 $13.5 $13.5 $13.5 10.3  (4%) 0
HIBB Hibbett Sports Inc. 1.5% $22.70 $26.2 $26.2 $26.8 13.2  (5%) 0
ULTA Ulta Beauty Inc 1.5% $246.60 $252.3 $252.3 $242.6 2.6  (-20%) 2
DSW DSW Inc. Class A 1.5% $25.22 $25.1 $25.1 $23.6 6.2  (-4%) 4
ANF Abercrombie & Fitch Co. Class A 1.4% $25.59 $25.4 $25.4 $26.2 5.9  (-4%) 2
SVU SUPERVALU INC. 1.4% $19.51 $18.6 $18.6 $17.1 7.5  (-2%) 5
URBN Urban Outfitters Inc. 1.4% $45.99 $44.0 $44.0 $41.2 5.3  (7%) 5
RCII Rent-A-Center Inc 1.4% $12.37 $10.5 $10.5 $10.1 24.3  (8%) 5
DG Dollar General Corporation 1.4% $96.33 $95.0 $95.0 $95.7 2.5  (4%) 0
SFLY Shutterfly Inc. 1.4% $95.51 $95.1 $95.1 $89.7 4.0  (34%) 3
BKE Buckle Inc. 1.3% $26.55 $26.3 $26.3 $24.3 31.4  (5%) 5
M Macy's Inc 1.3% $37.56 $36.6 $36.6 $32.7 4.5  (-5%) 4
BURL Burlington Stores Inc. 1.3% $154.09 $146.3 $146.3 $140.8 5.2  (3%) 4
OLLI Ollie's Bargain Outlet Holdings Inc 1.3% $75.65 $72.1 $72.1 $66.5 10.1  (9%) 4
CHS Chico's FAS Inc. 1.3% $8.47 $9.3 $9.3 $9.7 4.9  (2%) 0
GCO Genesco Inc. 1.3% $39.90 $42.9 $42.9 $43.0 12.2  (-0%) 2
TSCO Tractor Supply Company 1.3% $74.32 $74.7 $74.7 $68.5 3.8  (3%) 4
NTRI Nutrisystem Inc. 1.3% $36.45 $35.6 $35.6 $32.5 4.3  (8%) 2
AEO American Eagle Outfitters Inc. 1.3% $23.80 $23.3 $23.3 $21.9 3.4  (19%) 4
DLTR Dollar Tree Inc. 1.3% $88.34 $88.5 $88.5 $93.3 2.4  (-7%) -1
ORLY O'Reilly Automotive Inc. 1.3% $281.89 $275.7 $275.7 $258.5 5.1  (3%) 5
ROST Ross Stores Inc. 1.3% $84.50 $82.6 $82.6 $80.8 1.8  (28%) 3
FIVE Five Below Inc. 1.3% $102.09 $82.1 $82.1 $76.6 6.3  (-6%) 5
COST Costco Wholesale Corporation 1.3% $205.12 $200.2 $200.2 $195.7 4.3  (-0%) 4
BBY Best Buy Co. Inc. 1.3% $73.32 $72.6 $72.6 $73.7 10.1  (-7%) 2
GRPN Groupon Inc. 1.3% $4.62 $4.7 $4.7 $4.7 3.1  (-9%) 0
EXPE Expedia Group Inc. 1.3% $123.58 $119.3 $119.3 $114.3 6.4  (-12%) 5
KR Kroger Co. 1.3% $26.16 $25.0 $25.0 $24.6 7.3  (-18%) 4
DKS Dick's Sporting Goods Inc. 1.3% $37.40 $34.5 $34.5 $33.5 4.4  (8%) 4
KMX CarMax Inc. 1.3% $73.22 $69.9 $69.9 $65.6 11.3  (4%) 5
EXPR Express Inc. 1.3% $9.42 $9.5 $9.5 $8.5 8.2  (13%) 5
TGT Target Corporation 1.3% $77.22 $75.5 $75.5 $73.2 8.7  (-3%) 5
MNRO Monro Inc 1.3% $58.85 $56.7 $56.7 $55.9 14.1  (3%) 5
TJX TJX Companies Inc 1.3% $94.56 $90.9 $90.9 $86.5 3.9  (-14%) 3
JWN Nordstrom Inc. 1.2% $49.87 $49.8 $49.8 $49.3 9.7  (-11%) 3
FL Foot Locker Inc. 1.2% $57.65 $52.9 $52.9 $47.3 4.3  (-9%) 4
KSS Kohl's Corporation 1.2% $73.28 $70.0 $70.0 $65.3 7.5  (-6%) 5
TIF Tiffany & Co. 1.2% $135.67 $126.2 $126.2 $110.9 3.9  (5%) 4
ABG Asbury Automotive Group Inc. 1.2% $73.15 $71.4 $71.4 $69.7 10.5  (-3%) 5
AMZN Amazon.com Inc. 1.2% $1,723.86 $1,644.7 $1,644.7 $1,570.4 1.5  (-3%) 3
BKNG Booking Holdings Inc. 1.2% $2,123.06 $2,108.8 $2,108.8 $2,112.4 2.7  (27%) 2
PAG Penske Automotive Group Inc. 1.2% $50.41 $49.2 $49.2 $46.9 13.8  (-3%) 4
LEXEA Liberty Expedia Holdings Inc Class A 1.2% $45.57 $43.2 $43.2 $41.1 5.4  (0%) 4
AAP Advance Auto Parts Inc. 1.2% $133.50 $127.0 $127.0 $118.8 5.7  (4%) 5
WMT Walmart Inc. 1.2% $83.79 $83.8 $83.8 $85.3 3.6  (0%) -1
SBH Sally Beauty Holdings Inc. 1.2% $15.30 $15.4 $15.4 $15.9 9.9  (-1%) 0
SFM Sprouts Farmers Markets Inc. 1.2% $21.41 $21.7 $21.7 $22.7 5.2  (-0%) -1
AZO AutoZone Inc. 1.2% $682.99 $654.9 $654.9 $639.2 3.1  (18%) 3
PSMT PriceSmart Inc. 1.2% $88.40 $85.8 $85.8 $86.1 13.0  (-1%) 4
CVS CVS Health Corporation 1.2% $69.12 $65.6 $65.6 $65.3 3.9  (3%) 2
RAD Rite Aid Corporation 1.2% $1.77 $1.7 $1.7 $1.7 23.0  (3%) 3
NFLX Netflix Inc. 1.2% $392.87 $354.4 $354.4 $330.7 3.5  (6%) 4
ODP Office Depot Inc. 1.2% $2.92 $2.6 $2.6 $2.4 3.8  (5%) 3
JCP J. C. Penney Company Inc. 1.1% $2.70 $2.6 $2.6 $2.9 8.1  (5%) 0
AN AutoNation Inc. 1.1% $49.02 $47.4 $47.4 $47.0 6.8  (22%) 4
PLCE Children's Place Inc. 1.1% $128.70 $129.9 $129.9 $129.7 4.4  (15%) -0
LAD Lithia Motors Inc. Class A 1.1% $101.42 $98.9 $98.9 $98.9 9.7  (8%) 1
WBA Walgreens Boots Alliance Inc 1.1% $64.87 $63.7 $63.7 $64.2 2.7  (-24%) -0
GPI Group 1 Automotive Inc. 1.1% $71.16 $71.6 $71.6 $68.0 11.1  (3%) 3
CASY Casey's General Stores Inc. 1.1% $99.11 $97.9 $97.9 $100.0 7.3  (-3%) -1
TRIP TripAdvisor Inc. 1.1% $57.73 $53.0 $53.0 $46.2 4.3  (0%) 4
GPS Gap Inc. 1.1% $31.33 $30.9 $30.9 $30.3 7.0  (10%) 1
DDS Dillard's Inc. Class A 1.1% $88.93 $85.1 $85.1 $79.0 13.5  (-4%) 5
BIG Big Lots Inc. 1.1% $41.55 $41.5 $41.5 $42.0 11.4  (6%) -0
W Wayfair Inc. Class A 1.1% $109.50 $95.8 $95.8 $82.0 7.3  (8%) 4
GME GameStop Corp. Class A 1.0% $12.85 $13.5 $13.5 $13.4 10.7  (6%) 1
MUSA Murphy USA Inc. 1.0% $71.05 $69.1 $69.1 $67.4 5.2  (-1%) 2
QRTEA Qurate Retail Inc. Class A 1.0% $21.45 $21.4 $21.4 $23.0 3.9  (3%) -1
MIK Michaels Companies Inc 1.0% $18.86 $19.5 $19.5 $19.1 8.3  (-3%) -1
LB L Brands Inc. 1.0% $35.99 $35.6 $35.6 $35.5 3.3  (13%) 2
PRTY Party City Holdco Inc. 1.0% $15.15 $14.8 $14.8 $15.3 8.8  (-3%) 2
SIG Signet Jewelers Limited 1.0% $55.51 $46.6 $46.6 $41.7 7.2  (6%) 3
CAL Caleres Inc. 0.9% $33.90 $35.2 $35.2 $34.4 7.7  (18%) 2
CONN Conn's Inc. 0.9% $35.80 $27.7 $27.7 $27.2 9.9  (-9%) 3
PETS PetMed Express Inc. 0.9% $42.87 $38.4 $38.4 $37.3 7.1  (-2%) 3
CWH Camping World Holdings Inc. Class A 0.9% $23.56 $21.4 $21.4 $24.6 1.9  (98%) 0
EYE National Vision Holdings Inc. 0.9% $36.42 $36.8 $36.8 $34.4 6.7  (17%) 4
OSTK Overstock.com Inc. 0.8% $39.45 $35.8 $35.8 $36.6 6.2  (-0%) 1
HZO MarineMax Inc. 0.7% $23.65 $23.8 $23.8 $22.0 5.6  (2%) 3
LTRPA Liberty TripAdvisor Holdings Inc Class A 0.6% $16.85 $15.0 $15.0 $12.3 1.4  (-17%) 4
SAH Sonic Automotive Inc. Class A 0.5% $21.70 $21.7 $21.7 $20.6 39.6  (-1%) 4
WMK Weis Markets Inc. 0.5% $53.10 $53.6 $53.6 $48.7 13.3  (-3%) 5
IMKTA Ingles Markets Incorporated Class A 0.4% $29.35 $29.4 $29.4 $31.4 10.4  (18%) -1