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

SDY Conmponent Weighting

Ticker
Symbol
Company Name ETF Weight Close Price 10-Day 20-Day 50-Day Short Int Ratio Technical Score
O Realty Income Corporation 2.0% $56.98 $55.9 $55.9 $54.6 10.8  (5%) 5
T AT&T Inc. 2.0% $32.49 $31.7 $31.7 $32.2 1.8  (5%) -0
SKT Tanger Factory Outlet Centers Inc. 1.9% $23.81 $23.8 $23.8 $23.3 15.4  (1%) 4
NNN National Retail Properties Inc. 1.9% $45.33 $44.7 $44.7 $43.6 7.8  (17%) 4
ABBV AbbVie Inc. 1.7% $95.47 $93.7 $93.7 $95.6 3.8  (1%) -1
MDP Meredith Corporation 1.6% $53.25 $52.6 $52.6 $52.1 25.9  (4%) 3
CVX Chevron Corporation 1.5% $122.53 $123.8 $123.8 $124.5 3.4  (-3%) -1
XOM Exxon Mobil Corporation 1.5% $80.32 $81.8 $81.8 $81.7 2.9  (-4%) -1
IBM International Business Machines Corporation 1.5% $144.77 $145.8 $145.8 $144.0 3.1  (12%) 1
ED Consolidated Edison Inc. 1.4% $78.95 $78.5 $78.5 $76.8 9.2  (1%) 2
KMB Kimberly-Clark Corporation 1.4% $111.21 $108.8 $108.8 $105.4 6.1  (-0%) 4
BKH Black Hills Corporation 1.4% $60.45 $60.3 $60.3 $59.7 13.7  (2%) 2
PBCT People's United Financial Inc. 1.4% $18.50 $18.4 $18.4 $18.5 7.8  (14%) 1
TGT Target Corporation 1.4% $82.62 $79.6 $79.6 $77.8 7.1  (-0%) 5
FRT Federal Realty Investment Trust 1.4% $125.97 $124.7 $124.7 $123.4 6.1  (8%) 4
KO Coca-Cola Company 1.3% $46.35 $45.7 $45.7 $44.5 2.8  (9%) 4
ORI Old Republic International Corporation 1.3% $21.60 $20.9 $20.9 $20.7 2.7  (26%) 2
PG Procter & Gamble Company 1.3% $81.40 $80.3 $80.3 $78.2 2.8  (4%) 3
UBSI United Bankshares Inc. 1.3% $38.25 $37.0 $37.0 $37.1 13.4  (3%) 4
NFG National Fuel Gas Company 1.2% $55.27 $54.1 $54.1 $53.5 10.9  (26%) 4
SON Sonoco Products Company 1.2% $55.59 $55.3 $55.3 $53.6 4.8  (40%) 3
GPC Genuine Parts Company 1.2% $99.37 $96.8 $96.8 $94.5 3.8  (-13%) 4
ESS Essex Property Trust Inc. 1.2% $239.54 $236.0 $236.0 $236.9 3.3  (-9%) 1
LEG Leggett & Platt Incorporated 1.2% $43.93 $44.5 $44.5 $44.2 6.0  (8%) 2
CAH Cardinal Health Inc. 1.2% $49.37 $49.8 $49.8 $51.3 3.1  (27%) -1
ADM Archer-Daniels-Midland Company 1.2% $50.24 $48.2 $48.2 $46.7 2.7  (6%) 4
CLX Clorox Company 1.1% $140.21 $135.2 $135.2 $131.2 7.2  (19%) 5
MDU MDU Resources Group Inc. 1.1% $28.68 $28.8 $28.8 $28.5 2.5  (38%) 2
VVC Vectren Corporation 1.1% $71.44 $71.4 $71.4 $71.2 2.2  (20%) 2
PEP PepsiCo Inc. 1.1% $113.70 $114.5 $114.5 $109.4 1.9  (62%) 3
NJR New Jersey Resources Corporation 1.1% $46.35 $45.7 $45.7 $44.6 8.3  (9%) 4
NEE NextEra Energy Inc. 1.1% $170.85 $169.3 $169.3 $165.7 5.0  (-1%) 2
EMR Emerson Electric Co. 1.0% $74.05 $70.8 $70.8 $70.9 2.3  (-11%) 2
BMS Bemis Company Inc. 1.0% $50.10 $45.3 $45.3 $43.5 2.9  (18%) 3
APD Air Products and Chemicals Inc. 1.0% $160.48 $158.4 $158.4 $159.8 1.2  (-7%) 1
TROW T. Rowe Price Group 1.0% $118.89 $119.8 $119.8 $120.7 5.1  (-8%) 2
RPM RPM International Inc. 1.0% $63.75 $62.7 $62.7 $57.2 2.4  (6%) 4
CINF Cincinnati Financial Corporation 1.0% $75.00 $72.7 $72.7 $70.5 4.0  (15%) 3
MCD McDonald's Corporation 1.0% $159.30 $157.8 $157.8 $160.2 1.8  (-4%) -1
BEN Franklin Resources Inc. 1.0% $32.89 $32.6 $32.6 $32.9 4.9  (-9%) 1
MCY Mercury General Corporation 1.0% $52.73 $47.5 $47.5 $46.9 10.7  (17%) 5
JNJ Johnson & Johnson 1.0% $131.20 $129.4 $129.4 $125.4 2.0  (-11%) 3
VFC V.F. Corporation 1.0% $95.55 $91.2 $91.2 $86.0 2.7  (17%) 4
SJM J. M. Smucker Company 1.0% $110.70 $110.6 $110.6 $108.4 11.6  (1%) 3
WTR Aqua America Inc. 0.9% $37.43 $36.7 $36.7 $35.5 13.6  (7%) 5
SYY Sysco Corporation 0.9% $70.03 $70.0 $70.0 $68.4 6.0  (3%) 4
NUE Nucor Corporation 0.9% $63.41 $65.5 $65.5 $65.2 1.7  (-2%) 1
WBA Walgreens Boots Alliance Inc 0.9% $66.17 $66.3 $66.3 $64.9 4.1  (15%) 3
ATO Atmos Energy Corporation 0.9% $91.24 $91.2 $91.2 $89.6 6.4  (-4%) 4
AFL Aflac Incorporated 0.9% $46.76 $44.7 $44.7 $44.6 3.7  (-8%) 2
WMT Walmart Inc. 0.9% $89.01 $88.4 $88.4 $86.2 5.3  (-1%) 4
UGI UGI Corporation 0.9% $54.61 $53.0 $53.0 $51.8 3.9  (22%) 3
ADP Automatic Data Processing Inc. 0.9% $138.37 $136.8 $136.8 $136.1 2.0  (-10%) 3
PX Praxair Inc. 0.9% $157.15 $163.7 $163.7 $160.9 4.1  (9%) 1
MDT Medtronic plc 0.9% $91.22 $89.3 $89.3 $87.6 2.3  (5%) 3
CFR Cullen/Frost Bankers Inc. 0.9% $111.38 $112.9 $112.9 $113.0 5.0  (8%) 1
MMM 3M Company 0.9% $204.78 $204.0 $204.0 $201.5 2.5  (-5%) 2
CL Colgate-Palmolive Company 0.9% $65.93 $66.2 $66.2 $64.9 2.7  (-6%) 2
EV Eaton Vance Corp. 0.8% $52.91 $53.2 $53.2 $53.7 5.5  (-8%) 0
HRL Hormel Foods Corporation 0.8% $37.12 $36.9 $36.9 $36.6 16.8  (9%) 3
TDS Telephone and Data Systems Inc. 0.8% $30.46 $26.0 $26.0 $26.6 3.6  (15%) 1
UTX United Technologies Corporation 0.8% $134.24 $132.5 $132.5 $128.6 3.9  (23%) 4
CWT California Water Service Group 0.8% $40.70 $40.8 $40.8 $40.3 4.0  (21%) 1
ABM ABM Industries Incorporated 0.8% $31.17 $30.6 $30.6 $30.3 8.2  (4%) 2
CB Chubb Limited 0.8% $137.08 $135.9 $135.9 $132.1 3.3  (30%) 2
CAT Caterpillar Inc. 0.8% $138.52 $139.5 $139.5 $143.0 1.1  (-12%) -1
JW.A John Wiley & Sons Inc. Class A 0.7% $63.05 $64.3 $64.3 $65.5   -2
LANC Lancaster Colony Corporation 0.7% $147.65 $144.5 $144.5 $139.0 11.6  (10%) 4
AWR American States Water Company 0.7% $59.74 $60.1 $60.1 $58.4 8.3  (5%) 4
MKC McCormick & Company Incorporated 0.7% $120.82 $118.9 $118.9 $112.4 14.9  (0%) 4
CBU Community Bank System Inc. 0.7% $63.71 $63.2 $63.2 $61.8 13.2  (0%) 5
LOW Lowe's Companies Inc. 0.7% $99.94 $99.3 $99.3 $98.3 2.4  (-5%) 2
PII Polaris Industries Inc. 0.7% $109.71 $114.3 $114.3 $119.7 5.7  (-8%) 1
ABT Abbott Laboratories 0.7% $64.64 $64.3 $64.3 $63.0 2.1  (12%) 3
ITW Illinois Tool Works Inc. 0.7% $138.51 $140.9 $140.9 $142.7 1.4  (-2%) -2
DOV Dover Corporation 0.7% $82.42 $79.4 $79.4 $77.1 2.6  (43%) 3
GWW W.W. Grainger Inc. 0.7% $351.66 $335.4 $335.4 $320.2 4.0  (-15%) 4
CHD Church & Dwight Co. Inc. 0.7% $55.57 $55.4 $55.4 $52.6 9.1  (-4%) 4
CHRW C.H. Robinson Worldwide Inc. 0.7% $94.75 $91.6 $91.6 $89.1 7.1  (1%) 4
LECO Lincoln Electric Holdings Inc. 0.6% $92.87 $91.8 $91.8 $90.8 2.6  (-20%) 4
MSA MSA Safety Inc. 0.6% $100.17 $99.0 $99.0 $97.1 3.6  (16%) 3
SWK Stanley Black & Decker Inc. 0.6% $141.85 $141.3 $141.3 $139.5 1.7  (73%) 2
PPG PPG Industries Inc. 0.6% $109.21 $107.6 $107.6 $105.3 4.6  (-3%) 2
DCI Donaldson Company Inc. 0.6% $47.39 $46.6 $46.6 $46.6 15.3  (-10%) 3
CBSH Commerce Bancshares Inc. 0.6% $69.41 $68.5 $68.5 $66.9 8.2  (-8%) 5
TJX TJX Companies Inc 0.6% $99.81 $97.2 $97.2 $95.6 3.1  (-11%) 3
CSL Carlisle Companies Incorporated 0.6% $125.67 $119.2 $119.2 $113.3 4.2  (-17%) 4
GD General Dynamics Corporation 0.6% $192.57 $195.3 $195.3 $194.8 1.9  (1%) -1
ALB Albemarle Corporation 0.6% $100.76 $94.1 $94.1 $94.1 9.5  (11%) 2
ATR Aptargroup Inc. 0.5% $103.90 $98.8 $98.8 $95.8 5.1  (5%) 5
BDX Becton Dickinson and Company 0.5% $251.50 $248.2 $248.2 $240.0 6.0  (-5%) 4
PNR Pentair plc 0.5% $43.68 $43.5 $43.5 $43.4 2.4  (31%) 1
RLI RLI Corp. 0.5% $75.17 $72.8 $72.8 $69.7 13.7  (1%) 5
EXPD Expeditors International of Washington Inc. 0.5% $73.25 $74.3 $74.3 $74.5 6.9  (5%) 2
BRO Brown & Brown Inc. 0.5% $29.72 $29.3 $29.3 $28.6 3.3  (9%) 3
ROST Ross Stores Inc. 0.4% $92.17 $87.7 $87.7 $85.9 2.3  (-5%) 4
ECL Ecolab Inc. 0.4% $147.84 $143.9 $143.9 $143.2 5.4  (-10%) 3
FUL H.B. Fuller Company 0.4% $57.74 $56.3 $56.3 $55.0 12.2  (3%) 5
BF.B Brown-Forman Corporation Class B 0.4% $53.63 $52.9 $52.9 $52.2   2
AOS A. O. Smith Corporation 0.4% $58.13 $59.2 $59.2 $60.7 3.1  (9%) -2
SPGI S&P Global Inc. 0.4% $200.95 $206.8 $206.8 $205.9 2.9  (-22%) 0
CDK CDK Global Inc 0.4% $64.11 $64.7 $64.7 $65.1 4.4  (-13%) -1
CTAS Cintas Corporation 0.4% $211.40 $203.5 $203.5 $194.8 5.1  (-0%) 5
RNR RenaissanceRe Holdings Ltd. 0.3% $127.90 $127.2 $127.2 $124.8 2.4  (-17%) 2
SHW Sherwin-Williams Company 0.3% $444.05 $433.6 $433.6 $413.4 2.7  (1%) 4
NDSN Nordson Corporation 0.3% $133.08 $131.6 $131.6 $130.5 5.3  (11%) 1
SEIC SEI Investments Company 0.3% $59.61 $61.5 $61.5 $63.5 3.5  (9%) -2
NVT nVent Electric plc 0.3% $28.46 $26.5 $26.5 $26.4 0.6  (50%) 3
WST West Pharmaceutical Services Inc. 0.2% $115.32 $106.3 $106.3 $101.6 3.1  (3%) 3
ROP Roper Technologies Inc. 0.2% $295.47 $290.5 $290.5 $283.5 2.6  (-1%) 4