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

DVY Conmponent Weighting

Ticker
Symbol
Company Name ETF Weight Close Price 10-Day 20-Day 50-Day Short Int Ratio Technical Score
CTL CENTURYLINK INC 2.3% $20.97 $19.0 $19.0 $18.7 12.0  (-6%) 4
OKE ONEOK INC 2.1% $68.74 $69.7 $69.7 $69.4 3.2  (-26%) 1
F F MOTOR 2.0% $9.91 $10.4 $10.4 $11.1 2.2  (6%) -1
PPL PPL CORP 2.0% $28.93 $28.6 $28.6 $28.0 12.2  (-0%) 3
OXY OCCIDENTAL PETROLEUM CORP 1.9% $77.79 $82.7 $82.7 $83.6 1.8  (1%) -1
ETR ENTERGY CORP 1.7% $83.33 $81.5 $81.5 $80.3 6.4  (-10%) 4
FE FIRSTENERGY CORP 1.6% $36.30 $35.7 $35.7 $35.2 7.0  (-9%) 4
T AT&T INC 1.6% $32.49 $31.7 $31.7 $32.2 1.8  (5%) -0
STX SEAGATE TECHNOLOGY PLC 1.6% $51.02 $55.8 $55.8 $56.9 6.6  (3%) 0
CVX CHEVRON CORP 1.5% $122.53 $123.8 $123.8 $124.5 3.4  (-3%) -1
VLO VALERO ENERGY CORP 1.5% $115.14 $111.5 $111.5 $113.5 2.8  (-15%) 2
EIX EDISON INTERNATIONAL 1.5% $67.42 $66.3 $66.3 $63.7 3.2  (1%) 3
XOM EXXON MOBIL CORP 1.4% $80.32 $81.8 $81.8 $81.7 2.9  (-4%) -1
HFC HOLLYFRONTIER CORP 1.4% $68.36 $70.7 $70.7 $71.8 4.3  (-10%) 1
PEG PUBLIC SERVICE ENTERPRISE GROUP IN 1.4% $51.98 $51.5 $51.5 $52.2 3.2  (-11%) -1
D DOMINION ENERGY INC 1.4% $71.03 $70.9 $70.9 $68.1 6.3  (-3%) 4
EXC EXELON CORP 1.4% $43.37 $42.2 $42.2 $41.8 3.6  (-13%) 2
AEP AMERICAN ELECTRIC POWER INC 1.4% $70.98 $70.5 $70.5 $68.6 2.3  (-14%) 3
WEC WEC ENERGY GROUP INC 1.4% $66.98 $65.4 $65.4 $63.6 5.3  (-1%) 4
CNP CENTERPOINT ENERGY INC 1.3% $28.20 $28.0 $28.0 $27.1 4.9  (-4%) 3
XEL XCEL ENERGY INC 1.3% $47.64 $46.4 $46.4 $45.2 3.4  (11%) 3
LNT ALLIANT ENERGY CORP 1.3% $42.78 $42.7 $42.7 $41.7 4.4  (-1%) 2
ES EVERSOURCE ENERGY 1.3% $61.14 $59.7 $59.7 $57.7 2.4  (1%) 3
MRK MERCK & CO INC 1.3% $66.00 $64.2 $64.2 $62.5 2.2  (4%) 4
CMS CMS ENERGY CORP 1.3% $48.45 $47.9 $47.9 $46.5 2.1  (24%) 3
DTE DTE ENERGY 1.3% $110.72 $108.0 $108.0 $103.7 3.4  (7%) 4
MO ALTRIA GROUP INC 1.2% $59.22 $58.2 $58.2 $57.5 3.2  (26%) 2
PFE PFIZER INC 1.2% $41.00 $38.8 $38.8 $37.4 2.6  (-5%) 4
LB L BRANDS INC 1.2% $31.51 $31.8 $31.8 $34.6 4.9  (-0%) -1
KSS KOHLS CORP 1.2% $75.11 $72.5 $72.5 $73.1 11.2  (-2%) 4
M MACYS INC 1.2% $40.56 $38.7 $38.7 $38.2 6.4  (-10%) 5
LYB LYONDELLBASELL INDUSTRIES NV CLASS 1.2% $113.38 $109.6 $109.6 $111.0 4.1  (-8%) 3
NWL NEWELL BRANDS INC 1.2% $20.88 $25.7 $25.7 $25.7 8.3  (1%) -1
KO COCA-COLA 1.2% $46.35 $45.7 $45.7 $44.5 2.8  (9%) 4
IBM INTERNATIONAL BUSINESS MACHINES CO 1.2% $144.77 $145.8 $145.8 $144.0 3.1  (12%) 1
PNW PINNACLE WEST CORP 1.2% $81.31 $80.3 $80.3 $79.0 2.3  (-10%) 2
SRE SEMPRA ENERGY 1.1% $114.73 $115.3 $115.3 $113.3 12.2  (2%) 3
IPG INTERPUBLIC GROUP OF COMPANIES INC 1.1% $22.29 $22.3 $22.3 $22.9 4.2  (10%) -2
WU WESTERN UNION 1.1% $18.92 $20.0 $20.0 $20.4 11.4  (-5%) 1
GE GENERAL ELECTRIC 1.1% $12.94 $13.3 $13.3 $13.5 1.7  (2%) -2
TGT TARGET CORP 1.1% $82.62 $79.6 $79.6 $77.8 7.1  (-0%) 5
NI NISOURCE INC 1.1% $26.51 $26.2 $26.2 $25.5 5.6  (6%) 4
KMB KIMBERLY CLARK CORP 1.1% $111.21 $108.8 $108.8 $105.4 6.1  (-0%) 4
GIS GENERAL MILLS INC 1.1% $45.27 $44.7 $44.7 $44.4 6.4  (1%) 4
NEE NEXTERA ENERGY INC 1.1% $170.85 $169.3 $169.3 $165.7 5.0  (-1%) 2
PM PHILIP MORRIS INTERNATIONAL INC 1.0% $84.40 $84.1 $84.1 $81.8 1.4  (3%) 1
IVZ INVESCO LTD 1.0% $25.49 $25.8 $25.8 $26.6 1.7  (20%) -2
GPC GENUINE PARTS 1.0% $99.37 $96.8 $96.8 $94.5 3.8  (-13%) 4
LLY ELI LILLY 1.0% $102.19 $95.0 $95.0 $89.6 3.2  (27%) 4
ETN EATON PLC 1.0% $81.71 $79.5 $79.5 $78.3 3.8  (-6%) 4
IP INTERNATIONAL PAPER 1.0% $53.16 $52.8 $52.8 $54.0 3.1  (1%) 1
QCOM QUALCOMM INC 1.0% $65.08 $61.6 $61.6 $59.6 1.3  (7%) 4
HP HELMERICH & PAYNE INC 1.0% $60.50 $61.2 $61.2 $63.3 5.3  (3%) 0
CF CF INDUSTRIES HOLDINGS INC 0.9% $49.75 $45.1 $45.1 $44.1 5.4  (-8%) 5
MCD MCDONALDS CORP 0.9% $159.30 $157.8 $157.8 $160.2 1.8  (-4%) -1
DRI DARDEN RESTAURANTS INC 0.9% $109.42 $109.5 $109.5 $103.5 4.9  (-15%) 3
EMR EMERSON ELECTRIC 0.9% $74.05 $70.8 $70.8 $70.9 2.3  (-11%) 2
CINF CINCINNATI FINANCIAL CORP 0.9% $75.00 $72.7 $72.7 $70.5 4.0  (15%) 3
LAZ LAZARD LTD CLASS A 0.9% $52.26 $52.0 $52.0 $51.6 3.7  (59%) 2
GRMN GARMIN LTD 0.9% $64.67 $64.0 $64.0 $62.3 9.6  (-8%) 5
OGE OGE ENERGY CORP 0.9% $36.88 $35.9 $35.9 $35.1 1.4  (28%) 4
COP CONOCOPHILLIPS 0.9% $71.75 $71.2 $71.2 $69.5 2.1  (-23%) 2
SYY SYSCO CORP 0.9% $70.03 $70.0 $70.0 $68.4 6.0  (3%) 4
INTC INTEL CORPORATION CORP 0.8% $50.14 $50.8 $50.8 $52.2 3.3  (-0%) -2
PACW PACWEST BANCORP 0.8% $51.01 $50.4 $50.4 $51.8 3.3  (-15%) 0
AJG ARTHUR J GALLAGHER 0.8% $71.36 $70.7 $70.7 $68.1 2.0  (5%) 2
BBT BB AND T CORP 0.8% $51.20 $51.3 $51.3 $51.9 2.4  (17%) -1
WRK WESTROCK 0.8% $55.56 $56.9 $56.9 $58.1 1.4  (-22%) -2
PBCT PEOPLES UNITED FINANCIAL INC 0.8% $18.50 $18.4 $18.4 $18.5 7.8  (14%) 1
NYCB NEW YORK COMMUNITY BANCORP INC 0.7% $10.72 $11.0 $11.0 $11.3 9.0  (3%) 0
WM WASTE MANAGEMENT INC 0.7% $90.14 $86.6 $86.6 $84.3 2.5  (-11%) 4
LMT LOCKHEED MARTIN CORP 0.7% $315.71 $319.8 $319.8 $312.7 1.3  (-8%) 1
PKG PACKAGING CORP OF AMERICA CORP 0.7% $111.56 $113.3 $113.3 $115.6 1.8  (-4%) -1
LEG LEGGETT & PLATT INC 0.7% $43.93 $44.5 $44.5 $44.2 6.0  (8%) 2
OLN OLIN CORP 0.7% $30.33 $29.3 $29.3 $29.9 3.5  (1%) 1
CAT CATERPILLAR INC 0.7% $138.52 $139.5 $139.5 $143.0 1.1  (-12%) -1
SON SONOCO PRODUCTS 0.7% $55.59 $55.3 $55.3 $53.6 4.8  (40%) 3
SCG SCANA CORP 0.6% $38.28 $40.0 $40.0 $38.5 2.9  (-2%) 2
HRB H&R BLOCK INC 0.6% $25.63 $24.9 $24.9 $25.0 10.1  (-7%) 3
WSO WATSCO INC 0.6% $171.90 $176.3 $176.3 $180.7 3.7  (-11%) 0
HUN HUNTSMAN CORP 0.6% $32.65 $31.3 $31.3 $31.3 2.8  (-3%) 2
ORI OLD REPUBLIC INTERNATIONAL CORP 0.6% $21.60 $20.9 $20.9 $20.7 2.7  (26%) 2
IDA IDACORP INC 0.6% $96.66 $93.9 $93.9 $91.8 5.3  (20%) 5
CNK CINEMARK HOLDINGS INC 0.5% $35.77 $35.4 $35.4 $35.4 13.7  (3%) 1
FNB FNB CORP 0.5% $13.13 $13.2 $13.2 $13.5 5.7  (5%) 1
NUS NU SKIN ENTERPRISES INC CLASS A 0.5% $82.92 $76.8 $76.8 $79.3 8.3  (1%) 3
NJR NEW JERSEY RESOURCES CORP 0.5% $46.35 $45.7 $45.7 $44.6 8.3  (9%) 4
BOH BANK OF HAWAII CORP. 0.4% $82.96 $83.1 $83.1 $84.5 6.2  (-7%) 1
UBSI UNITED BANKSHARES INC 0.4% $38.25 $37.0 $37.0 $37.1 13.4  (3%) 4
AVA AVISTA CORP 0.4% $50.78 $50.5 $50.5 $51.8 10.2  (11%) 0
VLY VALLEY NATIONAL 0.4% $11.76 $12.3 $12.3 $12.5 6.3  (-7%) 0
BKH BLACK HILLS CORP 0.4% $60.45 $60.3 $60.3 $59.7 13.7  (2%) 2
UFS DOMTAR CORP 0.4% $49.87 $48.6 $48.6 $48.2 4.4  (-4%) 4
NWE NORTHWESTERN CORP 0.4% $59.51 $58.8 $58.8 $56.7 2.2  (-16%) 3
FII FEDERATED INVESTORS INC CLASS B 0.3% $22.91 $23.4 $23.4 $23.7 9.9  (13%) 0
TUP TUPPERWARE BRANDS CORP 0.3% $35.22 $38.1 $38.1 $40.8 2.9  (-11%) -1
MDP MEREDITH CORP 0.3% $53.25 $52.6 $52.6 $52.1 25.9  (4%) 3
TRMK TRUSTMARK CORP 0.3% $35.10 $34.7 $34.7 $33.7 10.5  (20%) 5
PBI PITNEY BOWES INC 0.2% $8.21 $8.5 $8.5 $8.9 5.4  (20%) -1