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% $80.32 $81.8 $81.8 $81.7 2.9  (-4%) -1
CVX Chevron Corporation 17.3% $122.53 $123.8 $123.8 $124.5 3.4  (-3%) -1
SLB Schlumberger NV 6.9% $65.40 $66.6 $66.6 $67.2 3.1  (3%) -2
COP ConocoPhillips 4.9% $71.75 $71.2 $71.2 $69.5 2.1  (-23%) 2
EOG EOG Resources Inc. 4.7% $122.31 $125.0 $125.0 $121.9 4.0  (-12%) 2
OXY Occidental Petroleum Corporation 4.3% $77.79 $82.7 $82.7 $83.6 1.8  (1%) -1
VLO Valero Energy Corporation 3.6% $115.14 $111.5 $111.5 $113.5 2.8  (-15%) 2
PSX Phillips 66 3.5% $122.18 $116.3 $116.3 $115.0 1.9  (-15%) 4
HAL Halliburton Company 3.4% $41.51 $42.8 $42.8 $45.1 1.5  (59%) -2
MPC Marathon Petroleum Corporation 2.6% $80.75 $76.5 $76.5 $75.2 6.1  (3%) 3
APC Anadarko Petroleum Corporation 2.5% $66.06 $70.7 $70.7 $71.3 3.3  (-11%) -1
PXD Pioneer Natural Resources Company 2.5% $185.65 $185.4 $185.4 $187.1 3.5  (1%) -2
KMI Kinder Morgan Inc Class P 2.3% $17.94 $17.8 $17.8 $17.5 3.6  (37%) 3
OKE ONEOK Inc. 1.9% $68.74 $69.7 $69.7 $69.4 3.2  (-26%) 1
CXO Concho Resources Inc. 1.7% $134.84 $143.7 $143.7 $137.4 1.9  (-59%) -0
WMB Williams Companies Inc. 1.6% $31.79 $29.4 $29.4 $28.0 3.3  (25%) 4
DVN Devon Energy Corporation 1.5% $42.07 $44.0 $44.0 $43.1 2.3  (4%) 0
ANDV Andeavor 1.4% $149.92 $143.2 $143.2 $140.0 3.3  (3%) 4
NBL Noble Energy Inc. 1.2% $30.63 $34.3 $34.3 $34.8 7.1  (5%) 1
APA Apache Corporation 1.1% $43.29 $45.4 $45.4 $44.4 12.9  (-2%) 2
MRO Marathon Oil Corporation 1.1% $20.09 $20.7 $20.7 $20.9 1.5  (11%) 0
HES Hess Corporation 1.1% $64.00 $65.1 $65.1 $64.0 4.8  (-11%) 1
BHGE Baker Hughes a GE Company Class A 1.1% $34.67 $33.5 $33.5 $33.6 5.0  (11%) 2
NOV National Oilwell Varco Inc. 1.1% $45.65 $44.9 $44.9 $43.5 6.3  (3%) 4
FTI TechnipFMC Plc 1.1% $29.99 $31.0 $31.0 $31.3 2.3  (-5%) -1
EQT EQT Corporation 0.9% $49.95 $52.9 $52.9 $53.8 3.4  (-3%) -1
COG Cabot Oil & Gas Corporation 0.8% $23.54 $23.7 $23.7 $23.6 4.2  (38%) -1
XEC Cimarex Energy Co. 0.7% $88.87 $96.6 $96.6 $94.7 3.7  (-22%) -1
HP Helmerich & Payne Inc. 0.5% $60.50 $61.2 $61.2 $63.3 5.3  (3%) 0
NFX Newfield Exploration Company 0.4% $27.51 $28.5 $28.5 $29.2 3.1  (2%) -1
RRC Range Resources Corporation 0.2% $16.11 $15.9 $15.9 $16.2 6.6  (8%) 0