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% $18.01 $18.2 $18.2 $18.2 7.8  (-9%) 2
OKE ONEOK INC 2.1% $69.34 $67.7 $67.7 $63.7 4.6  (-8%) 4
F F MOTOR 2.0% $11.89 $11.7 $11.7 $11.4 3.5  (-6%) 4
PPL PPL CORP 2.0% $27.07 $26.7 $26.7 $27.6 6.0  (179%) 0
OXY OCCIDENTAL PETROLEUM CORP 1.9% $84.35 $84.9 $84.9 $79.8 2.2  (13%) 3
ETR ENTERGY CORP 1.7% $76.71 $77.8 $77.8 $78.9 3.4  (-8%) 0
FE FIRSTENERGY CORP 1.6% $34.27 $33.7 $33.7 $34.0 7.9  (-4%) 3
T AT&T INC 1.6% $32.52 $32.8 $32.8 $33.4 6.1  (1%) 0
STX SEAGATE TECHNOLOGY PLC 1.6% $59.08 $57.6 $57.6 $57.9 4.2  (3%) 1
CVX CHEVRON CORP 1.5% $126.51 $125.9 $125.9 $124.4 3.2  (8%) 2
VLO VALERO ENERGY CORP 1.5% $116.82 $120.7 $120.7 $113.0 2.9  (6%) 3
EIX EDISON INTERNATIONAL 1.5% $60.20 $61.0 $61.0 $62.5 3.2  (-6%) -1
XOM EXXON MOBIL CORP 1.4% $81.89 $81.5 $81.5 $79.6 2.6  (27%) 3
HFC HOLLYFRONTIER CORP 1.4% $72.96 $75.6 $75.6 $66.6 3.0  (-4%) 4
PEG PUBLIC SERVICE ENTERPRISE GROUP IN 1.4% $52.22 $51.5 $51.5 $51.0 4.4  (-4%) 4
D DOMINION ENERGY INC 1.4% $65.52 $63.7 $63.7 $64.6 8.3  (1%) 2
EXC EXELON CORP 1.4% $41.07 $40.3 $40.3 $39.9 4.4  (40%) 3
AEP AMERICAN ELECTRIC POWER INC 1.4% $64.62 $65.5 $65.5 $67.2 3.1  (4%) -1
WEC WEC ENERGY GROUP INC 1.4% $59.86 $60.8 $60.8 $62.0 5.4  (4%) 1
CNP CENTERPOINT ENERGY INC 1.3% $26.18 $25.7 $25.7 $26.1 2.3  (25%) 1
XEL XCEL ENERGY INC 1.3% $42.87 $43.8 $43.8 $44.8 4.0  (2%) 0
LNT ALLIANT ENERGY CORP 1.3% $39.62 $40.1 $40.1 $41.1 5.0  (-18%) -1
ES EVERSOURCE ENERGY 1.3% $53.99 $55.6 $55.6 $57.7 3.0  (-3%) -1
MRK MERCK & CO INC 1.3% $61.56 $60.5 $60.5 $58.9 2.0  (-2%) 4
CMS CMS ENERGY CORP 1.3% $43.62 $44.3 $44.3 $45.0 1.5  (-8%) 0
DTE DTE ENERGY 1.3% $97.05 $99.4 $99.4 $101.8 3.7  (-6%) -1
MO ALTRIA GROUP INC 1.2% $56.70 $56.3 $56.3 $57.7 2.8  (5%) 1
PFE PFIZER INC 1.2% $36.16 $36.1 $36.1 $36.0 2.6  (-3%) 1
LB L BRANDS INC 1.2% $35.99 $35.6 $35.6 $35.5 3.3  (13%) 2
KSS KOHLS CORP 1.2% $73.28 $70.0 $70.0 $65.3 7.5  (-6%) 5
M MACYS INC 1.2% $37.56 $36.6 $36.6 $32.7 4.5  (-5%) 4
LYB LYONDELLBASELL INDUSTRIES NV CLASS 1.2% $114.15 $115.6 $115.6 $109.9 4.0  (3%) 2
NWL NEWELL BRANDS INC 1.2% $26.39 $25.1 $25.1 $26.1 6.1  (2%) -1
KO COCA-COLA 1.2% $43.58 $43.1 $43.1 $43.1 3.3  (-2%) 2
IBM INTERNATIONAL BUSINESS MACHINES CO 1.2% $145.20 $144.3 $144.3 $146.8 3.4  (13%) -1
PNW PINNACLE WEST CORP 1.2% $75.41 $76.4 $76.4 $78.1 2.3  (10%) 0
SRE SEMPRA ENERGY 1.1% $113.32 $106.0 $106.0 $108.3 6.6  (-2%) 2
IPG INTERPUBLIC GROUP OF COMPANIES INC 1.1% $23.58 $23.2 $23.2 $23.5 7.1  (-2%) 2
WU WESTERN UNION 1.1% $20.66 $20.4 $20.4 $19.8 7.6  (-5%) 4
GE GENERAL ELECTRIC 1.1% $13.64 $14.2 $14.2 $14.1 3.1  (-5%) -1
TGT TARGET CORP 1.1% $77.22 $75.5 $75.5 $73.2 8.7  (-3%) 5
NI NISOURCE INC 1.1% $23.99 $24.3 $24.3 $24.4 3.4  (6%) -1
KMB KIMBERLY CLARK CORP 1.1% $102.04 $103.2 $103.2 $104.1 9.8  (-2%) 0
GIS GENERAL MILLS INC 1.1% $44.51 $42.9 $42.9 $43.4 5.8  (4%) 2
NEE NEXTERA ENERGY INC 1.1% $158.82 $159.6 $159.6 $160.9 4.8  (12%) -1
PM PHILIP MORRIS INTERNATIONAL INC 1.0% $80.85 $79.7 $79.7 $85.3 2.0  (7%) -2
IVZ INVESCO LTD 1.0% $27.21 $27.9 $27.9 $29.0 1.4  (-10%) -2
GPC GENUINE PARTS 1.0% $94.07 $92.9 $92.9 $91.1 3.9  (10%) 2
LLY ELI LILLY 1.0% $86.35 $84.2 $84.2 $81.6 2.7  (20%) 4
ETN EATON PLC 1.0% $79.28 $78.9 $78.9 $77.4 3.4  (17%) 1
IP INTERNATIONAL PAPER 1.0% $56.84 $56.2 $56.2 $54.1 3.3  (6%) 3
QCOM QUALCOMM INC 1.0% $59.46 $58.9 $58.9 $55.6 1.9  (10%) 2
HP HELMERICH & PAYNE INC 1.0% $64.97 $67.3 $67.3 $69.0 7.7  (4%) 2
CF CF INDUSTRIES HOLDINGS INC 0.9% $44.92 $42.1 $42.1 $40.1 5.4  (15%) 4
MCD MCDONALDS CORP 0.9% $167.05 $163.0 $163.0 $162.5 2.2  (-10%) 4
DRI DARDEN RESTAURANTS INC 0.9% $92.19 $88.9 $88.9 $89.4 4.7  (-4%) 1
EMR EMERSON ELECTRIC 0.9% $72.90 $72.6 $72.6 $70.5 2.1  (-1%) 2
CINF CINCINNATI FINANCIAL CORP 0.9% $68.92 $70.3 $70.3 $71.6 5.0  (-3%) -1
LAZ LAZARD LTD CLASS A 0.9% $53.69 $53.3 $53.3 $53.4 2.4  (21%) -1
GRMN GARMIN LTD 0.9% $61.94 $61.1 $61.1 $60.0 9.6  (-1%) 4
OGE OGE ENERGY CORP 0.9% $34.56 $34.1 $34.1 $33.4 1.8  (1%) 4
COP CONOCOPHILLIPS 0.9% $68.13 $68.7 $68.7 $66.8 2.8  (2%) 2
SYY SYSCO CORP 0.9% $66.48 $65.2 $65.2 $63.3 4.9  (12%) 4
INTC INTEL CORPORATION CORP 0.8% $55.54 $55.3 $55.3 $53.6 3.6  (6%) 3
PACW PACWEST BANCORP 0.8% $54.25 $54.4 $54.4 $52.5 5.6  (-5%) 4
AJG ARTHUR J GALLAGHER 0.8% $65.98 $67.0 $67.0 $68.1 1.7  (-4%) -2
BBT BB AND T CORP 0.8% $52.44 $54.1 $54.1 $53.5 3.0  (-15%) -1
WRK WESTROCK 0.8% $60.50 $60.7 $60.7 $61.9 2.0  (0%) -1
PBCT PEOPLES UNITED FINANCIAL INC 0.8% $18.79 $18.8 $18.8 $18.6 6.6  (-11%) 2
NYCB NEW YORK COMMUNITY BANCORP INC 0.7% $11.54 $11.8 $11.8 $12.1 10.4  (-2%) 0
WM WASTE MANAGEMENT INC 0.7% $83.57 $83.0 $83.0 $83.0 2.8  (11%) 2
LMT LOCKHEED MARTIN CORP 0.7% $310.59 $319.3 $319.3 $326.3 1.4  (8%) -1
PKG PACKAGING CORP OF AMERICA CORP 0.7% $120.78 $121.2 $121.2 $117.4 2.2  (-19%) 2
LEG LEGGETT & PLATT INC 0.7% $44.25 $42.5 $42.5 $42.7 8.0  (5%) 2
OLN OLIN CORP 0.7% $30.41 $32.7 $32.7 $31.6 2.1  (61%) -1
CAT CATERPILLAR INC 0.7% $153.14 $155.3 $155.3 $151.6 2.0  (-4%) 1
SON SONOCO PRODUCTS 0.7% $53.08 $52.3 $52.3 $51.4 4.3  (-18%) 4
SCG SCANA CORP 0.6% $36.90 $35.7 $35.7 $36.1 4.6  (9%) 2
HRB H&R BLOCK INC 0.6% $23.77 $27.8 $27.8 $27.3 11.1  (-5%) 2
WSO WATSCO INC 0.6% $188.41 $185.5 $185.5 $181.8 5.7  (-10%) 5
HUN HUNTSMAN CORP 0.6% $33.13 $32.4 $32.4 $31.1 2.3  (-15%) 2
ORI OLD REPUBLIC INTERNATIONAL CORP 0.6% $20.99 $21.1 $21.1 $21.0 3.9  (-23%) 0
IDA IDACORP INC 0.6% $87.71 $88.8 $88.8 $89.6 4.0  (-16%) -1
CNK CINEMARK HOLDINGS INC 0.5% $35.52 $34.6 $34.6 $37.0 8.9  (-6%) -1
FNB FNB CORP 0.5% $13.79 $13.7 $13.7 $13.4 6.5  (-5%) 2
NUS NU SKIN ENTERPRISES INC CLASS A 0.5% $83.53 $81.7 $81.7 $77.1 7.2  (-9%) 5
NJR NEW JERSEY RESOURCES CORP 0.5% $41.35 $42.6 $42.6 $42.0 6.7  (-9%) 2
BOH BANK OF HAWAII CORP. 0.4% $85.47 $86.2 $86.2 $84.9 8.2  (1%) 3
UBSI UNITED BANKSHARES INC 0.4% $36.75 $36.8 $36.8 $35.5 20.1  (-4%) 4
AVA AVISTA CORP 0.4% $52.78 $52.5 $52.5 $52.2 6.8  (-9%) 4
VLY VALLEY NATIONAL 0.4% $12.65 $12.9 $12.9 $12.6 6.2  (-5%) 2
BKH BLACK HILLS CORP 0.4% $56.84 $56.8 $56.8 $56.2 14.1  (-2%) 3
UFS DOMTAR CORP 0.4% $47.66 $48.0 $48.0 $46.3 3.1  (-13%) 3
NWE NORTHWESTERN CORP 0.4% $53.55 $53.3 $53.3 $53.8 3.3  (20%) -1
FII FEDERATED INVESTORS INC CLASS B 0.3% $23.68 $24.5 $24.5 $27.1 6.7  (-16%) 0
TUP TUPPERWARE BRANDS CORP 0.3% $44.08 $44.1 $44.1 $44.1 4.3  (7%) -1
MDP MEREDITH CORP 0.3% $51.10 $49.6 $49.6 $51.0 17.5  (16%) 2
TRMK TRUSTMARK CORP 0.3% $32.63 $32.8 $32.8 $32.0 13.5  (8%) 4
PBI PITNEY BOWES INC 0.2% $9.21 $9.2 $9.2 $9.7 1.9  (6%) -1