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

XLY Conmponent Weighting

Ticker
Symbol
Company Name ETF Weight Close Price 10-Day 20-Day 50-Day Short Int Ratio Technical Score
AMZN Amazon.com Inc. 21.7% $1,898.52 $1,829.8 $1,829.8 $1,751.6 0.8  (9%) 3
HD Home Depot Inc. 7.5% $198.08 $198.9 $198.9 $197.1 2.0  (-16%) 2
DIS Walt Disney Company 5.2% $114.16 $112.3 $112.3 $107.6 3.8  (19%) 4
CMCSA Comcast Corporation Class A 5.0% $35.49 $34.7 $34.7 $33.5 2.6  (-8%) 3
NFLX Netflix Inc. 4.7% $349.36 $362.6 $362.6 $377.4 0.9  (1%) 0
MCD McDonald's Corporation 4.4% $159.30 $157.8 $157.8 $160.2 1.8  (-4%) -1
BKNG Booking Holdings Inc. 3.6% $1,942.39 $2,034.8 $2,034.8 $2,072.1 3.6  (8%) -2
NKE NIKE Inc. Class B 3.0% $81.26 $77.9 $77.9 $76.0 1.9  (-10%) 3
SBUX Starbucks Corporation 2.7% $51.92 $51.5 $51.5 $52.6 2.2  (-3%) -1
LOW Lowe's Companies Inc. 2.4% $99.94 $99.3 $99.3 $98.3 2.4  (-5%) 2
TJX TJX Companies Inc 1.8% $99.81 $97.2 $97.2 $95.6 3.1  (-11%) 3
CHTR Charter Communications Inc. Class A 1.8% $305.17 $295.4 $295.4 $291.4 6.8  (-1%) 2
GM General Motors Company 1.6% $37.51 $38.3 $38.3 $40.4 2.2  (26%) -1
F Ford Motor Company 1.5% $9.91 $10.4 $10.4 $11.1 2.2  (6%) -1
MAR Marriott International Inc. Class A 1.4% $120.79 $129.1 $129.1 $131.9 3.1  (-2%) -1
TGT Target Corporation 1.3% $82.62 $79.6 $79.6 $77.8 7.1  (-0%) 5
FOXA Twenty-First Century Fox Inc. Class A 1.3% $45.60 $45.9 $45.9 $45.3 2.0  (-11%) 2
ROST Ross Stores Inc. 1.0% $92.17 $87.7 $87.7 $85.9 2.3  (-5%) 4
YUM Yum! Brands Inc. 0.9% $82.73 $79.8 $79.8 $80.4 3.3  (-6%) 2
VFC V.F. Corporation 0.9% $95.55 $91.2 $91.2 $86.0 2.7  (17%) 4
DG Dollar General Corporation 0.9% $102.98 $99.1 $99.1 $97.7 3.6  (20%) 3
APTV Aptiv PLC 0.8% $96.72 $95.2 $95.2 $96.6 3.2  (-3%) 1
DLTR Dollar Tree Inc. 0.8% $92.70 $88.9 $88.9 $86.7 2.2  (7%) 3
HLT Hilton Worldwide Holdings Inc 0.8% $76.15 $79.6 $79.6 $80.8 2.2  (-6%) -1
ORLY O'Reilly Automotive Inc. 0.7% $318.78 $301.2 $301.2 $288.7 3.0  (-15%) 4
BBY Best Buy Co. Inc. 0.7% $78.68 $76.1 $76.1 $74.7 8.1  (-1%) 4
RCL Royal Caribbean Cruises Ltd. 0.6% $114.18 $111.0 $111.0 $108.6 2.2  (-9%) 3
AZO AutoZone Inc. 0.6% $736.29 $709.6 $709.6 $689.4 3.0  (-8%) 4
CBS CBS Corporation Class B 0.6% $53.57 $55.6 $55.6 $55.1 2.0  (-3%) 1
OMC Omnicom Group Inc 0.6% $67.93 $69.8 $69.8 $72.9 6.0  (-5%) 0
WYNN Wynn Resorts Limited 0.6% $152.32 $160.4 $160.4 $167.4 1.5  (-40%) -1
FOX Twenty-First Century Fox Inc. Class B 0.5% $45.06 $45.5 $45.5 $44.9 1.5  (-0%) 2
MGM MGM Resorts International 0.5% $29.11 $30.3 $30.3 $30.3 2.2  (-2%) -1
DHI D.R. Horton Inc. 0.5% $45.00 $43.0 $43.0 $42.3 1.9  (7%) 2
LEN Lennar Corporation Class A 0.5% $53.45 $53.1 $53.1 $52.8 3.9  (-9%) 0
ULTA Ulta Beauty Inc 0.5% $236.15 $247.1 $247.1 $246.9 3.0  (-15%) 0
EXPE Expedia Group Inc. 0.5% $132.74 $130.0 $130.0 $125.7 4.6  (-5%) 4
MHK Mohawk Industries Inc. 0.5% $184.29 $203.6 $203.6 $208.7 1.7  (7%) -2
TPR Tapestry Inc. 0.5% $47.54 $47.1 $47.1 $46.5 2.8  (-8%) 2
NWL Newell Brands Inc 0.4% $20.88 $25.7 $25.7 $25.7 8.3  (1%) -1
GPC Genuine Parts Company 0.4% $99.37 $96.8 $96.8 $94.5 3.8  (-13%) 4
PVH PVH Corp. 0.4% $156.18 $152.7 $152.7 $154.9 2.0  (-11%) 2
KMX CarMax Inc. 0.4% $74.17 $75.8 $75.8 $74.5 10.7  (-1%) 2
DRI Darden Restaurants Inc. 0.4% $109.42 $109.5 $109.5 $103.5 4.9  (-15%) 3
WHR Whirlpool Corporation 0.4% $130.80 $139.1 $139.1 $144.8 1.7  (22%) -2
NCLH Norwegian Cruise Line Holdings Ltd. 0.4% $50.95 $49.3 $49.3 $50.2 2.4  (14%) 1
KSS Kohl's Corporation 0.4% $75.11 $72.5 $72.5 $73.1 11.2  (-2%) 4
VIAB Viacom Inc. Class B 0.4% $30.34 $28.7 $28.7 $28.9 3.7  (-7%) 1
CMG Chipotle Mexican Grill Inc. 0.4% $487.68 $460.9 $460.9 $456.5 2.5  (-4%) 4
TIF Tiffany & Co. 0.4% $137.10 $136.1 $136.1 $134.5 3.1  (-5%) 4
KORS Michael Kors Holdings Ltd 0.3% $72.34 $67.1 $67.1 $66.2 2.7  (-13%) 3
HAS Hasbro Inc. 0.3% $98.33 $98.2 $98.2 $94.1 3.3  (8%) 3
BWA BorgWarner Inc. 0.3% $45.00 $45.0 $45.0 $46.3 2.2  (-17%) -1
M Macy's Inc 0.3% $40.56 $38.7 $38.7 $38.2 6.4  (-10%) 5
LKQ LKQ Corporation 0.3% $33.97 $33.7 $33.7 $32.9 2.9  (29%) 2
IPG Interpublic Group of Companies Inc. 0.3% $22.29 $22.3 $22.3 $22.9 4.2  (10%) -2
TSCO Tractor Supply Company 0.3% $81.06 $78.8 $78.8 $77.3 3.0  (2%) 4
LB L Brands Inc. 0.3% $31.51 $31.8 $31.8 $34.6 4.9  (-0%) -1
AAP Advance Auto Parts Inc. 0.3% $147.79 $142.2 $142.2 $137.8 4.9  (-3%) 4
PHM PulteGroup Inc. 0.3% $29.33 $29.6 $29.6 $29.8 3.7  (-1%) -1
DISH DISH Network Corporation Class A 0.3% $36.59 $32.3 $32.3 $32.7 4.9  (3%) 1
DISCK Discovery Inc. Class C 0.3% $24.31 $24.6 $24.6 $24.3 3.3  (-7%) 3
GRMN Garmin Ltd. 0.2% $64.67 $64.0 $64.0 $62.3 9.6  (-8%) 5
HOG Harley-Davidson Inc. 0.2% $43.75 $43.3 $43.3 $43.1 5.8  (-4%) 4
GPS Gap Inc. 0.2% $31.18 $30.1 $30.1 $31.1 5.0  (-1%) 2
HBI Hanesbrands Inc. 0.2% $18.78 $20.6 $20.6 $20.8 9.3  (-7%) 1
GT Goodyear Tire & Rubber Company 0.2% $24.77 $23.1 $23.1 $23.9 3.2  (5%) 1
NWSA News Corporation Class A 0.2% $15.26 $15.2 $15.2 $15.5 4.9  (1%) -1
RL Ralph Lauren Corporation Class A 0.2% $136.63 $133.2 $133.2 $133.5 5.7  (-1%) 3
JWN Nordstrom Inc. 0.2% $52.55 $52.2 $52.2 $51.9 9.3  (7%) 3
HRB H&R Block Inc. 0.2% $25.63 $24.9 $24.9 $25.0 10.1  (-7%) 3
LEG Leggett & Platt Incorporated 0.2% $43.93 $44.5 $44.5 $44.2 6.0  (8%) 2
FL Foot Locker Inc. 0.2% $47.61 $49.7 $49.7 $52.9 4.9  (3%) -1
MAT Mattel Inc. 0.2% $15.61 $16.0 $16.0 $16.6 14.0  (4%) 1
TRIP TripAdvisor Inc. 0.1% $55.04 $57.9 $57.9 $57.2 8.9  (-2%) 2
DISCA Discovery Inc. Class A 0.1% $26.10 $26.5 $26.5 $26.1 9.5  (-3%) 4
UAA Under Armour Inc. Class A 0.1% $20.72 $20.8 $20.8 $22.0 9.2  (-7%) 1
UA Under Armour Inc. Class C 0.1% $19.15 $19.4 $19.4 $20.4 6.9  (-11%) 1
NWS News Corporation Class B 0.1% $15.40 $15.4 $15.4 $15.7 3.3  (-5%) -2