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

XLU Conmponent Weighting

Ticker
Symbol
Company Name ETF Weight Close Price 10-Day 20-Day 50-Day Short Int Ratio Technical Score
NEE NextEra Energy Inc. 11.7% $158.82 $159.6 $159.6 $160.9 4.8  (12%) -1
DUK Duke Energy Corporation 8.5% $73.46 $74.5 $74.5 $76.8 6.1  (0%) 1
SO Southern Company 7.1% $44.21 $43.8 $43.8 $44.6 6.5  (-5%) 1
D Dominion Energy Inc 6.6% $65.52 $63.7 $63.7 $64.6 8.3  (1%) 2
EXC Exelon Corporation 5.9% $41.07 $40.3 $40.3 $39.9 4.4  (40%) 3
AEP American Electric Power Company Inc. 5.2% $64.62 $65.5 $65.5 $67.2 3.1  (4%) -1
SRE Sempra Energy 4.3% $113.32 $106.0 $106.0 $108.3 6.6  (-2%) 2
PEG Public Service Enterprise Group Inc 4.0% $52.22 $51.5 $51.5 $51.0 4.4  (-4%) 4
ED Consolidated Edison Inc. 3.7% $73.25 $74.2 $74.2 $76.4 8.1  (10%) 0
XEL Xcel Energy Inc. 3.6% $42.87 $43.8 $43.8 $44.8 4.0  (2%) 0
PCG PG&E Corporation 3.6% $39.89 $42.1 $42.1 $43.7 2.1  (-13%) -1
EIX Edison International 3.2% $60.20 $61.0 $61.0 $62.5 3.2  (-6%) -1
WEC WEC Energy Group Inc 3.1% $59.86 $60.8 $60.8 $62.0 5.4  (4%) 1
PPL PPL Corporation 3.0% $27.07 $26.7 $26.7 $27.6 6.0  (179%) 0
ES Eversource Energy 2.9% $53.99 $55.6 $55.6 $57.7 3.0  (-3%) -1
DTE DTE Energy Company 2.9% $97.05 $99.4 $99.4 $101.8 3.7  (-6%) -1
AWK American Water Works Company Inc. 2.3% $79.78 $80.9 $80.9 $82.5 8.2  (-3%) 1
FE FirstEnergy Corp. 2.3% $34.27 $33.7 $33.7 $34.0 7.9  (-4%) 3
ETR Entergy Corporation 2.2% $76.71 $77.8 $77.8 $78.9 3.4  (-8%) 0
AEE Ameren Corporation 2.2% $56.37 $57.3 $57.3 $57.2 2.4  (-14%) 0
CMS CMS Energy Corporation 2.0% $43.62 $44.3 $44.3 $45.0 1.5  (-8%) 0
CNP CenterPoint Energy Inc. 1.7% $26.18 $25.7 $25.7 $26.1 2.3  (25%) 1
LNT Alliant Energy Corp 1.5% $39.62 $40.1 $40.1 $41.1 5.0  (-18%) -1
NRG NRG Energy Inc. 1.4% $33.51 $33.7 $33.7 $32.6 1.9  (0%) 2
PNW Pinnacle West Capital Corporation 1.4% $75.41 $76.4 $76.4 $78.1 2.3  (10%) 0
NI NiSource Inc 1.3% $23.99 $24.3 $24.3 $24.4 3.4  (6%) -1
AES AES Corporation 1.2% $13.18 $12.6 $12.6 $12.2 2.5  (-12%) 4
SCG SCANA Corporation 0.8% $36.90 $35.7 $35.7 $36.1 4.6  (9%) 2