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

XLE Conmponent Weighting

Ticker
Symbol
Company Name ETF Weight Close Price 10-Day 20-Day 50-Day Short Int Ratio Technical Score
XOM Exxon Mobil Corporation 21.9% $81.89 $81.5 $81.5 $79.6 2.6  (27%) 3
CVX Chevron Corporation 17.3% $126.51 $125.9 $125.9 $124.4 3.2  (8%) 2
SLB Schlumberger NV 6.9% $68.33 $70.3 $70.3 $69.4 3.5  (2%) 0
COP ConocoPhillips 4.9% $68.13 $68.7 $68.7 $66.8 2.8  (2%) 2
EOG EOG Resources Inc. 4.7% $117.53 $119.8 $119.8 $116.0 3.1  (2%) 2
OXY Occidental Petroleum Corporation 4.3% $84.35 $84.9 $84.9 $79.8 2.2  (13%) 3
VLO Valero Energy Corporation 3.6% $116.82 $120.7 $120.7 $113.0 2.9  (6%) 3
PSX Phillips 66 3.5% $115.55 $118.0 $118.0 $113.1 2.7  (39%) 3
HAL Halliburton Company 3.4% $47.73 $50.1 $50.1 $50.8 2.1  (-10%) -1
MPC Marathon Petroleum Corporation 2.6% $75.19 $78.7 $78.7 $77.4 2.3  (77%) 0
APC Anadarko Petroleum Corporation 2.5% $71.04 $70.3 $70.3 $67.3 4.0  (-15%) 3
PXD Pioneer Natural Resources Company 2.5% $191.45 $196.0 $196.0 $193.8 2.8  (-3%) 0
KMI Kinder Morgan Inc Class P 2.3% $16.95 $16.5 $16.5 $16.2 3.4  (-8%) 3
OKE ONEOK Inc. 1.9% $69.34 $67.7 $67.7 $63.7 4.6  (-8%) 4
CXO Concho Resources Inc. 1.7% $127.25 $137.1 $137.1 $145.5 6.6  (0%) -1
WMB Williams Companies Inc. 1.6% $27.21 $27.0 $27.0 $26.3 2.4  (-7%) 1
DVN Devon Energy Corporation 1.5% $41.71 $41.6 $41.6 $38.3 1.4  (30%) 3
ANDV Andeavor 1.4% $139.02 $144.1 $144.1 $132.7 1.1  (-35%) 2
NBL Noble Energy Inc. 1.2% $34.57 $35.4 $35.4 $33.9 3.2  (-15%) 2
APA Apache Corporation 1.1% $42.89 $41.6 $41.6 $41.0 7.9  (2%) 4
MRO Marathon Oil Corporation 1.1% $21.12 $21.3 $21.3 $19.7 0.9  (-7%) 3
HES Hess Corporation 1.1% $60.97 $61.9 $61.9 $59.4 6.0  (-8%) 3
BHGE Baker Hughes a GE Company Class A 1.1% $33.68 $34.9 $34.9 $34.4 6.8  (17%) 2
NOV National Oilwell Varco Inc. 1.1% $42.16 $42.4 $42.4 $40.3 9.4  (5%) 4
FTI TechnipFMC Plc 1.1% $32.16 $32.3 $32.3 $32.2 2.4  (-8%) 2
EQT EQT Corporation 0.9% $56.16 $52.6 $52.6 $50.6 3.2  (24%) 3
COG Cabot Oil & Gas Corporation 0.8% $23.61 $23.0 $23.0 $23.3 4.4  (0%) -1
XEC Cimarex Energy Co. 0.7% $86.55 $91.1 $91.1 $94.9 3.4  (9%) -2
HP Helmerich & Payne Inc. 0.5% $64.97 $67.3 $67.3 $69.0 7.7  (4%) 2
NFX Newfield Exploration Company 0.4% $29.20 $29.2 $29.2 $28.1 2.2  (-24%) 2
RRC Range Resources Corporation 0.2% $16.15 $15.8 $15.8 $14.9 8.8  (-2%) 5