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% $52.99 $52.9 $52.9 $52.1 12.8  (-6%) 4
T AT&T Inc. 2.0% $32.52 $32.8 $32.8 $33.4 6.1  (1%) 0
SKT Tanger Factory Outlet Centers Inc. 1.9% $22.31 $21.6 $21.6 $21.7 11.8  (3%) 3
NNN National Retail Properties Inc. 1.9% $42.17 $41.1 $41.1 $39.8 9.8  (-3%) 5
ABBV AbbVie Inc. 1.7% $98.75 $101.3 $101.3 $98.6 3.3  (28%) 1
MDP Meredith Corporation 1.6% $51.10 $49.6 $49.6 $51.0 17.5  (16%) 2
CVX Chevron Corporation 1.5% $126.51 $125.9 $125.9 $124.4 3.2  (8%) 2
XOM Exxon Mobil Corporation 1.5% $81.89 $81.5 $81.5 $79.6 2.6  (27%) 3
IBM International Business Machines Corporation 1.5% $145.20 $144.3 $144.3 $146.8 3.4  (13%) -1
ED Consolidated Edison Inc. 1.4% $73.25 $74.2 $74.2 $76.4 8.1  (10%) 0
KMB Kimberly-Clark Corporation 1.4% $102.04 $103.2 $103.2 $104.1 9.8  (-2%) 0
BKH Black Hills Corporation 1.4% $56.84 $56.8 $56.8 $56.2 14.1  (-2%) 3
PBCT People's United Financial Inc. 1.4% $18.79 $18.8 $18.8 $18.6 6.6  (-11%) 2
TGT Target Corporation 1.4% $77.22 $75.5 $75.5 $73.2 8.7  (-3%) 5
FRT Federal Realty Investment Trust 1.4% $121.09 $118.6 $118.6 $117.1 7.6  (-9%) 5
KO Coca-Cola Company 1.3% $43.58 $43.1 $43.1 $43.1 3.3  (-2%) 2
ORI Old Republic International Corporation 1.3% $20.99 $21.1 $21.1 $21.0 3.9  (-23%) 0
PG Procter & Gamble Company 1.3% $75.99 $74.8 $74.8 $74.8 3.5  (-6%) 2
UBSI United Bankshares Inc. 1.3% $36.75 $36.8 $36.8 $35.5 20.1  (-4%) 4
NFG National Fuel Gas Company 1.2% $52.88 $51.9 $51.9 $51.6 7.4  (-7%) 5
SON Sonoco Products Company 1.2% $53.08 $52.3 $52.3 $51.4 4.3  (-18%) 4
GPC Genuine Parts Company 1.2% $94.07 $92.9 $92.9 $91.1 3.9  (10%) 2
ESS Essex Property Trust Inc. 1.2% $234.83 $236.6 $236.6 $239.0 4.2  (-17%) -1
LEG Leggett & Platt Incorporated 1.2% $44.25 $42.5 $42.5 $42.7 8.0  (5%) 2
CAH Cardinal Health Inc. 1.2% $54.62 $53.1 $53.1 $57.2 1.8  (-34%) -2
ADM Archer-Daniels-Midland Company 1.2% $45.24 $44.7 $44.7 $44.7 1.5  (-23%) 2
CLX Clorox Company 1.1% $127.89 $122.7 $122.7 $122.0 6.3  (9%) 3
MDU MDU Resources Group Inc. 1.1% $28.14 $27.7 $27.7 $27.9 2.5  (-20%) 2
VVC Vectren Corporation 1.1% $70.78 $70.2 $70.2 $68.9 1.0  (-9%) 3
PEP PepsiCo Inc. 1.1% $105.13 $101.1 $101.1 $102.2 1.3  (-14%) 1
NJR New Jersey Resources Corporation 1.1% $41.35 $42.6 $42.6 $42.0 6.7  (-9%) 2
NEE NextEra Energy Inc. 1.1% $158.82 $159.6 $159.6 $160.9 4.8  (12%) -1
EMR Emerson Electric Co. 1.0% $72.90 $72.6 $72.6 $70.5 2.1  (-1%) 2
BMS Bemis Company Inc. 1.0% $42.93 $43.0 $43.0 $43.4 4.1  (11%) -1
APD Air Products and Chemicals Inc. 1.0% $165.72 $166.0 $166.0 $164.9 1.9  (2%) 2
TROW T. Rowe Price Group 1.0% $123.66 $123.0 $123.0 $115.9 6.3  (0%) 5
RPM RPM International Inc. 1.0% $50.96 $50.8 $50.8 $49.7 7.1  (23%) 2
CINF Cincinnati Financial Corporation 1.0% $68.92 $70.3 $70.3 $71.6 5.0  (-3%) -1
MCD McDonald's Corporation 1.0% $167.05 $163.0 $163.0 $162.5 2.2  (-10%) 4
BEN Franklin Resources Inc. 1.0% $33.15 $33.9 $33.9 $33.6 4.8  (5%) 0
MCY Mercury General Corporation 1.0% $47.36 $47.8 $47.8 $47.3 8.4  (15%) 3
JNJ Johnson & Johnson 1.0% $122.41 $122.3 $122.3 $125.2 3.0  (-3%) -1
VFC V.F. Corporation 1.0% $84.03 $82.3 $82.3 $79.8 2.9  (-18%) 4
SJM J. M. Smucker Company 1.0% $103.75 $107.0 $107.0 $113.1 10.2  (13%) 0
WGL WGL Holdings Inc. 0.9% $88.45 $88.3 $88.3 $86.9 3.7  (-21%) 3
WTR Aqua America Inc. 0.9% $33.28 $34.0 $34.0 $34.2 11.4  (-10%) -1
SYY Sysco Corporation 0.9% $66.48 $65.2 $65.2 $63.3 4.9  (12%) 4
NUE Nucor Corporation 0.9% $68.53 $65.7 $65.7 $63.8 2.2  (-10%) 3
WBA Walgreens Boots Alliance Inc 0.9% $64.87 $63.7 $63.7 $64.2 2.7  (-24%) -0
ATO Atmos Energy Corporation 0.9% $85.68 $86.6 $86.6 $86.2 2.1  (-26%) 1
AFL Aflac Incorporated 0.9% $45.68 $45.5 $45.5 $45.1 4.0  (-3%) 1
WMT Walmart Inc. 0.9% $83.79 $83.8 $83.8 $85.3 3.6  (0%) -1
UGI UGI Corporation 0.9% $49.25 $49.4 $49.4 $48.0 2.1  (-21%) 3
ADP Automatic Data Processing Inc. 0.9% $139.82 $132.8 $132.8 $125.2 1.5  (-8%) 4
PX Praxair Inc. 0.9% $161.55 $159.0 $159.0 $154.6 5.1  (-3%) 4
MDT Medtronic plc 0.9% $86.57 $86.2 $86.2 $83.2 2.2  (-8%) 2
CFR Cullen/Frost Bankers Inc. 0.9% $113.58 $116.7 $116.7 $113.6 3.9  (-30%) 3
MMM 3M Company 0.9% $203.63 $201.2 $201.2 $204.7 2.3  (21%) -1
CL Colgate-Palmolive Company 0.9% $63.31 $63.0 $63.0 $65.4 2.5  (-10%) -1
EV Eaton Vance Corp. 0.8% $54.89 $55.6 $55.6 $55.5 5.5  (-12%) 1
HRL Hormel Foods Corporation 0.8% $36.11 $36.1 $36.1 $35.9 17.5  (-1%) 3
TDS Telephone and Data Systems Inc. 0.8% $27.06 $26.1 $26.1 $27.0 3.4  (-16%) 1
UTX United Technologies Corporation 0.8% $126.94 $126.7 $126.7 $124.3 3.9  (-3%) 1
CWT California Water Service Group 0.8% $39.25 $39.6 $39.6 $39.1 4.7  (13%) 2
ABM ABM Industries Incorporated 0.8% $31.09 $29.8 $29.8 $30.8 6.3  (-13%) 2
CB Chubb Limited 0.8% $130.10 $132.5 $132.5 $134.1 2.7  (9%) -2
CAT Caterpillar Inc. 0.8% $153.14 $155.3 $155.3 $151.6 2.0  (-4%) 1
JW.A John Wiley & Sons Inc. Class A 0.7% $70.40 $68.4 $68.4 $67.0   4
LANC Lancaster Colony Corporation 0.7% $132.66 $128.3 $128.3 $126.5 8.9  (10%) 5
AWR American States Water Company 0.7% $56.13 $55.6 $55.6 $55.1 10.7  (46%) 4
MKC McCormick & Company Incorporated 0.7% $105.86 $103.0 $103.0 $104.5 13.5  (-1%) 0
CBU Community Bank System Inc. 0.7% $60.18 $60.6 $60.6 $58.1 16.7  (3%) 4
LOW Lowe's Companies Inc. 0.7% $99.16 $95.5 $95.5 $89.3 2.5  (3%) 2
PII Polaris Industries Inc. 0.7% $129.30 $118.7 $118.7 $115.5 11.8  (-6%) 4
ABT Abbott Laboratories 0.7% $62.96 $62.4 $62.4 $60.5 2.3  (-9%) 3
ITW Illinois Tool Works Inc. 0.7% $148.89 $147.2 $147.2 $148.9 2.6  (11%) 0
DOV Dover Corporation 0.7% $76.06 $78.6 $78.6 $85.7 1.4  (13%) -1
GWW W.W. Grainger Inc. 0.7% $317.39 $311.1 $311.1 $297.0 8.3  (-3%) 5
CHD Church & Dwight Co. Inc. 0.7% $49.80 $47.6 $47.6 $47.8 5.0  (25%) 2
CHRW C.H. Robinson Worldwide Inc. 0.7% $90.43 $88.5 $88.5 $89.4 6.1  (-13%) 3
LECO Lincoln Electric Holdings Inc. 0.6% $93.30 $90.9 $90.9 $89.0 3.5  (9%) 2
MSA MSA Safety Inc. 0.6% $95.29 $93.2 $93.2 $89.6 2.6  (-47%) 4
SWK Stanley Black & Decker Inc. 0.6% $142.29 $144.1 $144.1 $145.4 2.8  (-12%) -1
OZRK Bank of The Ozarks 0.6% $48.72 $48.6 $48.6 $47.9 16.6  (-5%) 2
PPG PPG Industries Inc. 0.6% $103.96 $103.1 $103.1 $105.9 2.9  (-14%) -2
DCI Donaldson Company Inc. 0.6% $47.98 $47.6 $47.6 $46.3 11.1  (0%) 3
CBSH Commerce Bancshares Inc. 0.6% $65.51 $65.5 $65.5 $64.1 11.4  (-4%) 4
TJX TJX Companies Inc 0.6% $94.56 $90.9 $90.9 $86.5 3.9  (-14%) 3
CSL Carlisle Companies Incorporated 0.6% $107.40 $108.4 $108.4 $105.7 6.2  (-5%) 3
GD General Dynamics Corporation 0.6% $195.82 $202.7 $202.7 $207.1 1.8  (-5%) -1
ALB Albemarle Corporation 0.6% $93.66 $96.8 $96.8 $96.9 7.3  (20%) -1
ATR Aptargroup Inc. 0.5% $94.86 $93.8 $93.8 $93.2 3.6  (-20%) 3
BDX Becton Dickinson and Company 0.5% $232.82 $227.5 $227.5 $227.1 3.7  (-13%) 3
PNR Pentair plc 0.5% $43.78 $44.7 $44.7 $53.6 0.8  (14%) -1
RLI RLI Corp. 0.5% $68.99 $67.6 $67.6 $65.6 17.0  (-5%) 5
EXPD Expeditors International of Washington Inc. 0.5% $76.77 $75.0 $75.0 $69.3 4.2  (-18%) 4
BRO Brown & Brown Inc. 0.5% $28.33 $28.0 $28.0 $27.2 4.0  (-8%) 3
ROST Ross Stores Inc. 0.4% $84.50 $82.6 $82.6 $80.8 1.8  (28%) 3
ECL Ecolab Inc. 0.4% $145.40 $145.3 $145.3 $145.1 6.2  (-3%) 3
FUL H.B. Fuller Company 0.4% $55.72 $53.2 $53.2 $51.6 10.0  (-0%) 5
BF.B Brown-Forman Corporation Class B 0.4% $52.94 $55.7 $55.7 $55.7   -2
AOS A. O. Smith Corporation 0.4% $63.97 $63.9 $63.9 $63.6 3.6  (-5%) -1
SPGI S&P Global Inc. 0.4% $207.29 $202.2 $202.2 $196.3 2.8  (-9%) 4
CDK CDK Global Inc 0.4% $65.86 $64.5 $64.5 $64.6 5.5  (-4%) 2
CTAS Cintas Corporation 0.4% $191.56 $185.9 $185.9 $178.8 9.1  (2%) 5
RNR RenaissanceRe Holdings Ltd. 0.3% $123.95 $125.1 $125.1 $130.2 2.6  (-19%) -1
SHW Sherwin-Williams Company 0.3% $401.20 $390.0 $390.0 $385.6 3.2  (13%) 1
NDSN Nordson Corporation 0.3% $129.54 $130.4 $130.4 $132.4 3.7  (-7%) -1
SEIC SEI Investments Company 0.3% $65.71 $65.5 $65.5 $66.6 3.4  (30%) -2
NVT nVent Electric plc 0.3% $26.74 $26.8 $26.8     1
WST West Pharmaceutical Services Inc. 0.2% $100.02 $93.8 $93.8 $90.6 5.2  (-1%) 3
ROP Roper Technologies Inc. 0.2% $283.21 $280.8 $280.8 $275.7 4.8  (-2%) 2