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% $170.85 $169.3 $169.3 $165.7 5.0  (-1%) 2
DUK Duke Energy Corporation 8.5% $80.81 $80.7 $80.7 $78.3 3.5  (-0%) 3
SO Southern Company 7.1% $46.81 $47.9 $47.9 $46.3 8.7  (-5%) 4
D Dominion Energy Inc 6.6% $71.03 $70.9 $70.9 $68.1 6.3  (-3%) 4
EXC Exelon Corporation 5.9% $43.37 $42.2 $42.2 $41.8 3.6  (-13%) 2
AEP American Electric Power Company Inc. 5.2% $70.98 $70.5 $70.5 $68.6 2.3  (-14%) 3
SRE Sempra Energy 4.3% $114.73 $115.3 $115.3 $113.3 12.2  (2%) 3
PEG Public Service Enterprise Group Inc 4.0% $51.98 $51.5 $51.5 $52.2 3.2  (-11%) -1
ED Consolidated Edison Inc. 3.7% $78.95 $78.5 $78.5 $76.8 9.2  (1%) 2
XEL Xcel Energy Inc. 3.6% $47.64 $46.4 $46.4 $45.2 3.4  (11%) 3
PCG PG&E Corporation 3.6% $43.90 $43.0 $43.0 $42.4 1.6  (5%) 1
EIX Edison International 3.2% $67.42 $66.3 $66.3 $63.7 3.2  (1%) 3
WEC WEC Energy Group Inc 3.1% $66.98 $65.4 $65.4 $63.6 5.3  (-1%) 4
PPL PPL Corporation 3.0% $28.93 $28.6 $28.6 $28.0 12.2  (-0%) 3
ES Eversource Energy 2.9% $61.14 $59.7 $59.7 $57.7 2.4  (1%) 3
DTE DTE Energy Company 2.9% $110.72 $108.0 $108.0 $103.7 3.4  (7%) 4
AWK American Water Works Company Inc. 2.3% $88.22 $87.8 $87.8 $85.0 7.7  (-2%) 4
FE FirstEnergy Corp. 2.3% $36.30 $35.7 $35.7 $35.2 7.0  (-9%) 4
ETR Entergy Corporation 2.2% $83.33 $81.5 $81.5 $80.3 6.4  (-10%) 4
AEE Ameren Corporation 2.2% $62.83 $61.7 $61.7 $60.0 3.9  (7%) 3
CMS CMS Energy Corporation 2.0% $48.45 $47.9 $47.9 $46.5 2.1  (24%) 3
CNP CenterPoint Energy Inc. 1.7% $28.20 $28.0 $28.0 $27.1 4.9  (-4%) 3
LNT Alliant Energy Corp 1.5% $42.78 $42.7 $42.7 $41.7 4.4  (-1%) 2
NRG NRG Energy Inc. 1.4% $34.13 $32.2 $32.2 $32.3 1.8  (-6%) 2
PNW Pinnacle West Capital Corporation 1.4% $81.31 $80.3 $80.3 $79.0 2.3  (-10%) 2
NI NiSource Inc 1.3% $26.51 $26.2 $26.2 $25.5 5.6  (6%) 4
AES AES Corporation 1.2% $13.74 $13.3 $13.3 $13.1 2.1  (2%) 4
SCG SCANA Corporation 0.8% $38.28 $40.0 $40.0 $38.5 2.9  (-2%) 2