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,723.86 $1,644.7 $1,644.7 $1,570.4 1.5  (-3%) 3
HD Home Depot Inc. 7.5% $199.67 $191.4 $191.4 $185.1 2.0  (-1%) 3
DIS Walt Disney Company 5.2% $108.75 $102.7 $102.7 $101.7 3.0  (-3%) 3
CMCSA Comcast Corporation Class A 5.0% $33.82 $32.0 $32.0 $32.4 2.8  (2%) 1
NFLX Netflix Inc. 4.7% $392.87 $354.4 $354.4 $330.7 3.5  (6%) 4
MCD McDonald's Corporation 4.4% $167.05 $163.0 $163.0 $162.5 2.2  (-10%) 4
BKNG Booking Holdings Inc. 3.6% $2,123.06 $2,108.8 $2,108.8 $2,112.4 2.7  (27%) 2
NKE NIKE Inc. Class B 3.0% $74.70 $72.9 $72.9 $69.9 4.1  (-4%) 3
SBUX Starbucks Corporation 2.7% $57.02 $57.0 $57.0 $57.7 3.7  (5%) -1
TWX Time Warner Inc. 2.5% $98.77 $94.8 $94.8 $94.9 2.2  (2%) 3
LOW Lowe's Companies Inc. 2.4% $99.16 $95.5 $95.5 $89.3 2.5  (3%) 2
TJX TJX Companies Inc 1.8% $94.56 $90.9 $90.9 $86.5 3.9  (-14%) 3
CHTR Charter Communications Inc. Class A 1.8% $295.61 $273.0 $273.0 $284.5 5.8  (24%) 2
GM General Motors Company 1.6% $43.57 $41.2 $41.2 $39.1 3.0  (-9%) 3
F Ford Motor Company 1.5% $11.89 $11.7 $11.7 $11.4 3.5  (-6%) 4
MAR Marriott International Inc. Class A 1.4% $138.75 $138.2 $138.2 $136.9 2.8  (-12%) 1
TGT Target Corporation 1.3% $77.22 $75.5 $75.5 $73.2 8.7  (-3%) 5
FOXA Twenty-First Century Fox Inc. Class A 1.3% $44.58 $39.4 $39.4 $37.9 1.9  (17%) 4
ROST Ross Stores Inc. 1.0% $84.50 $82.6 $82.6 $80.8 1.8  (28%) 3
YUM Yum! Brands Inc. 0.9% $83.38 $82.8 $82.8 $84.1 2.4  (1%) -1
VFC V.F. Corporation 0.9% $84.03 $82.3 $82.3 $79.8 2.9  (-18%) 4
DG Dollar General Corporation 0.9% $96.33 $95.0 $95.0 $95.7 2.5  (4%) 0
APTV Aptiv PLC 0.8% $102.61 $99.2 $99.2 $93.0 2.7  (33%) 4
DLTR Dollar Tree Inc. 0.8% $88.34 $88.5 $88.5 $93.3 2.4  (-7%) -1
HLT Hilton Worldwide Holdings Inc 0.8% $82.93 $82.9 $82.9 $81.6 2.5  (6%) 0
ORLY O'Reilly Automotive Inc. 0.7% $281.89 $275.7 $275.7 $258.5 5.1  (3%) 5
BBY Best Buy Co. Inc. 0.7% $73.32 $72.6 $72.6 $73.7 10.1  (-7%) 2
RCL Royal Caribbean Cruises Ltd. 0.6% $113.50 $106.3 $106.3 $109.7 1.8  (5%) 1
AZO AutoZone Inc. 0.6% $682.99 $654.9 $654.9 $639.2 3.1  (18%) 3
CBS CBS Corporation Class B 0.6% $55.12 $51.4 $51.4 $51.4 2.3  (-8%) 1
OMC Omnicom Group Inc 0.6% $75.37 $73.5 $73.5 $73.6 19.1  (2%) 2
WYNN Wynn Resorts Limited 0.6% $176.25 $186.7 $186.7 $187.9 1.4  (-18%) -1
FOX Twenty-First Century Fox Inc. Class B 0.5% $44.42 $39.0 $39.0 $37.5 2.4  (2%) 3
MGM MGM Resorts International 0.5% $31.43 $31.5 $31.5 $32.7 2.1  (18%) -2
DHI D.R. Horton Inc. 0.5% $43.08 $42.5 $42.5 $43.6 2.1  (-20%) -1
LEN Lennar Corporation Class A 0.5% $53.07 $52.4 $52.4 $54.5 3.3  (-9%) -0
ULTA Ulta Beauty Inc 0.5% $246.60 $252.3 $252.3 $242.6 2.6  (-20%) 2
EXPE Expedia Group Inc. 0.5% $123.58 $119.3 $119.3 $114.3 6.4  (-12%) 5
MHK Mohawk Industries Inc. 0.5% $214.11 $210.6 $210.6 $219.8 1.4  (12%) -2
TPR Tapestry Inc. 0.5% $45.53 $44.9 $44.9 $48.1 1.4  (-13%) 0
NWL Newell Brands Inc 0.4% $26.39 $25.1 $25.1 $26.1 6.1  (2%) -1
GPC Genuine Parts Company 0.4% $94.07 $92.9 $92.9 $91.1 3.9  (10%) 2
PVH PVH Corp. 0.4% $160.24 $159.9 $159.9 $158.1 2.5  (0%) 3
KMX CarMax Inc. 0.4% $73.22 $69.9 $69.9 $65.6 11.3  (4%) 5
DRI Darden Restaurants Inc. 0.4% $92.19 $88.9 $88.9 $89.4 4.7  (-4%) 1
WHR Whirlpool Corporation 0.4% $155.47 $153.1 $153.1 $153.3 3.2  (26%) -2
NCLH Norwegian Cruise Line Holdings Ltd. 0.4% $54.45 $52.8 $52.8 $53.0 2.0  (-17%) -1
KSS Kohl's Corporation 0.4% $73.28 $70.0 $70.0 $65.3 7.5  (-6%) 5
VIAB Viacom Inc. Class B 0.4% $28.91 $27.6 $27.6 $29.3 3.3  (-11%) 0
CMG Chipotle Mexican Grill Inc. 0.4% $460.44 $443.9 $443.9 $403.4 5.3  (-1%) 5
TIF Tiffany & Co. 0.4% $135.67 $126.2 $126.2 $110.9 3.9  (5%) 4
KORS Michael Kors Holdings Ltd 0.3% $65.85 $65.0 $65.0 $65.0 2.8  (27%) 2
HAS Hasbro Inc. 0.3% $91.61 $88.5 $88.5 $87.3 3.8  (-0%) 3
BWA BorgWarner Inc. 0.3% $48.82 $50.5 $50.5 $51.0 5.0  (-12%) -3
M Macy's Inc 0.3% $37.56 $36.6 $36.6 $32.7 4.5  (-5%) 4
LKQ LKQ Corporation 0.3% $33.15 $31.6 $31.6 $33.3 1.8  (-1%) -1
IPG Interpublic Group of Companies Inc. 0.3% $23.58 $23.2 $23.2 $23.5 7.1  (-2%) 2
TSCO Tractor Supply Company 0.3% $74.32 $74.7 $74.7 $68.5 3.8  (3%) 4
LB L Brands Inc. 0.3% $35.99 $35.6 $35.6 $35.5 3.3  (13%) 2
AAP Advance Auto Parts Inc. 0.3% $133.50 $127.0 $127.0 $118.8 5.7  (4%) 5
PHM PulteGroup Inc. 0.3% $30.80 $30.7 $30.7 $30.4 5.1  (16%) 5
DISH DISH Network Corporation Class A 0.3% $34.08 $31.2 $31.2 $33.9 3.4  (7%) 2
DISCK Discovery Inc. Class C 0.3% $24.15 $21.4 $21.4 $21.6 1.6  (6%) 2
GRMN Garmin Ltd. 0.2% $61.94 $61.1 $61.1 $60.0 9.6  (-1%) 4
HOG Harley-Davidson Inc. 0.2% $44.20 $42.4 $42.4 $41.8 9.7  (-4%) 3
GPS Gap Inc. 0.2% $31.33 $30.9 $30.9 $30.3 7.0  (10%) 1
HBI Hanesbrands Inc. 0.2% $20.17 $19.0 $19.0 $18.3 7.2  (1%) 3
GT Goodyear Tire & Rubber Company 0.2% $25.10 $25.2 $25.2 $25.9 3.9  (-5%) -2
NWSA News Corporation Class A 0.2% $16.02 $15.6 $15.6 $15.8 4.4  (8%) -1
RL Ralph Lauren Corporation Class A 0.2% $139.09 $133.6 $133.6 $119.7 8.0  (4%) 5
JWN Nordstrom Inc. 0.2% $49.87 $49.8 $49.8 $49.3 9.7  (-11%) 3
HRB H&R Block Inc. 0.2% $23.77 $27.8 $27.8 $27.3 11.1  (-5%) 2
LEG Leggett & Platt Incorporated 0.2% $44.25 $42.5 $42.5 $42.7 8.0  (5%) 2
FL Foot Locker Inc. 0.2% $57.65 $52.9 $52.9 $47.3 4.3  (-9%) 4
MAT Mattel Inc. 0.2% $17.92 $15.9 $15.9 $14.9 16.1  (-3%) 4
TRIP TripAdvisor Inc. 0.1% $57.73 $53.0 $53.0 $46.2 4.3  (0%) 4
DISCA Discovery Inc. Class A 0.1% $25.50 $22.6 $22.6 $23.1 4.1  (-19%) 2
UAA Under Armour Inc. Class A 0.1% $23.47 $22.0 $22.0 $19.3 10.6  (5%) 5
UA Under Armour Inc. Class C 0.1% $21.73 $19.9 $19.9 $17.2 9.8  (-4%) 5
NWS News Corporation Class B 0.1% $16.15 $16.0 $16.0 $16.1 1.9  (10%) -1