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

XOP Conmponent Weighting

Ticker
Symbol
Company Name ETF Weight Close Price 10-Day 20-Day 50-Day Short Int Ratio Technical Score
WLL Whiting Petroleum Corporation 2.4% $47.49 $49.1 $49.1 $51.0 4.1  (-4%) 0
HFC HollyFrontier Corporation 2.2% $68.36 $70.7 $70.7 $71.8 4.3  (-10%) 1
CRC California Resources Corp 2.2% $34.16 $37.7 $37.7 $39.5 5.4  (-0%) -1
CRZO Carrizo Oil & Gas Inc. 2.2% $24.46 $27.7 $27.7 $27.5 6.6  (-6%) 1
ANDV Andeavor 2.2% $149.92 $143.2 $143.2 $140.0 3.3  (3%) 4
OAS Oasis Petroleum Inc. 2.2% $12.80 $12.3 $12.3 $12.7 7.3  (3%) 2
SM SM Energy Company 2.1% $27.56 $27.2 $27.2 $25.9 5.6  (-9%) 4
QEP QEP Resources Inc. 2.1% $9.93 $11.2 $11.2 $11.7 3.3  (-5%) -1
DK Delek US Holdings Inc 2.1% $52.46 $49.9 $49.9 $51.5 2.4  (-4%) 3
CLR Continental Resources Inc. 2.1% $63.87 $62.3 $62.3 $63.6 5.3  (-8%) 3
PBF PBF Energy Inc. Class A 2.0% $50.20 $45.4 $45.4 $45.5 3.8  (-1%) 3
OXY Occidental Petroleum Corporation 2.0% $77.79 $82.7 $82.7 $83.6 1.8  (1%) -1
WPX WPX Energy Inc. Class A 1.9% $18.29 $18.8 $18.8 $18.3 3.6  (-31%) 0
MRO Marathon Oil Corporation 1.9% $20.09 $20.7 $20.7 $20.9 1.5  (11%) 0
PSX Phillips 66 1.9% $122.18 $116.3 $116.3 $115.0 1.9  (-15%) 4
NFX Newfield Exploration Company 1.9% $27.51 $28.5 $28.5 $29.2 3.1  (2%) -1
VLO Valero Energy Corporation 1.9% $115.14 $111.5 $111.5 $113.5 2.8  (-15%) 2
COP ConocoPhillips 1.9% $71.75 $71.2 $71.2 $69.5 2.1  (-23%) 2
HES Hess Corporation 1.9% $64.00 $65.1 $65.1 $64.0 4.8  (-11%) 1
CPE Callon Petroleum Company 1.9% $11.25 $11.0 $11.0 $10.8 12.5  (-0%) 2
MUR Murphy Oil Corporation 1.9% $30.16 $32.4 $32.4 $32.9 12.7  (-5%) 1
DVN Devon Energy Corporation 1.9% $42.07 $44.0 $44.0 $43.1 2.3  (4%) 0
APA Apache Corporation 1.9% $43.29 $45.4 $45.4 $44.4 12.9  (-2%) 2
PXD Pioneer Natural Resources Company 1.9% $185.65 $185.4 $185.4 $187.1 3.5  (1%) -2
EOG EOG Resources Inc. 1.8% $122.31 $125.0 $125.0 $121.9 4.0  (-12%) 2
APC Anadarko Petroleum Corporation 1.8% $66.06 $70.7 $70.7 $71.3 3.3  (-11%) -1
PE Parsley Energy Inc. Class A 1.8% $29.96 $31.4 $31.4 $30.0 3.7  (-14%) -0
EGN Energen Corporation 1.8% $72.21 $74.0 $74.0 $70.2 3.5  (-26%) 2
MPC Marathon Petroleum Corporation 1.8% $80.75 $76.5 $76.5 $75.2 6.1  (3%) 3
CVX Chevron Corporation 1.7% $122.53 $123.8 $123.8 $124.5 3.4  (-3%) -1
NBL Noble Energy Inc. 1.7% $30.63 $34.3 $34.3 $34.8 7.1  (5%) 1
XEC Cimarex Energy Co. 1.7% $88.87 $96.6 $96.6 $94.7 3.7  (-22%) -1
MTDR Matador Resources Company 1.7% $32.01 $32.2 $32.2 $29.8 10.3  (-1%) 1
XOM Exxon Mobil Corporation 1.7% $80.32 $81.8 $81.8 $81.7 2.9  (-4%) -1
CXO Concho Resources Inc. 1.7% $134.84 $143.7 $143.7 $137.4 1.9  (-59%) -0
PDCE PDC Energy Inc 1.7% $55.25 $60.7 $60.7 $60.7 6.3  (-1%) 1
FANG Diamondback Energy Inc. 1.6% $131.15 $132.4 $132.4 $127.0 5.7  (3%) 1
SWN Southwestern Energy Company 1.6% $5.42 $5.2 $5.2 $5.2 4.1  (-1%) 3
EQT EQT Corporation 1.5% $49.95 $52.9 $52.9 $53.8 3.4  (-3%) -1
CHK Chesapeake Energy Corporation 1.5% $4.63 $4.6 $4.6 $4.8 3.8  (2%) 1
COG Cabot Oil & Gas Corporation 1.5% $23.54 $23.7 $23.7 $23.6 4.2  (38%) -1
LPI Laredo Petroleum Inc. 1.5% $8.40 $9.3 $9.3 $9.1 8.5  (2%) 1
AR Antero Resources Corporation 1.5% $18.71 $20.4 $20.4 $20.4 11.4  (-7%) 1
RRC Range Resources Corporation 1.4% $16.11 $15.9 $15.9 $16.2 6.6  (8%) 0
CNX CNX Resources Corporation 1.4% $16.02 $16.6 $16.6 $16.9 5.3  (-1%) -1
GPOR Gulfport Energy Corporation 1.4% $11.39 $11.7 $11.7 $11.6 4.6  (8%) 1
CDEV Centennial Resource Development Inc. Class A 1.3% $18.43 $17.8 $17.8 $17.6 10.0  (5%) 2
DNR Denbury Resources Inc. 1.1% $4.27 $4.5 $4.5 $4.5 5.0  (-0%) 1
SRCI SRC Energy Inc 1.1% $9.92 $10.9 $10.9 $11.1 12.0  (8%) 1
XOG Extraction Oil & Gas Inc. 0.9% $12.60 $14.3 $14.3 $15.0 11.5  (-1%) 1
KOS Kosmos Energy Ltd. 0.9% $7.99 $7.9 $7.9 $8.0 11.2  (-6%) 1
HK Halcon Resources Corp 0.8% $3.95 $3.9 $3.9 $4.1 8.7  (5%) 0
HPR HighPoint Resources Corp. 0.8% $5.03 $6.5 $6.5 $6.4 6.1  (-13%) 1
JAG Jagged Peak Energy Inc. 0.8% $13.73 $14.0 $14.0 $13.0 16.1  (-26%) 2
REN Resolute Energy Corporation 0.7% $31.70 $32.0 $32.0 $32.2 13.6  (-7%) 0
CVI CVR Energy Inc. 0.7% $34.18 $37.1 $37.1 $37.7 7.8  (-4%) 1
INT World Fuel Services Corporation 0.6% $26.38 $24.1 $24.1 $22.6 3.2  (-17%) 3
TELL Tellurian Inc. 0.5% $7.13 $7.7 $7.7 $9.0 15.5  (7%) -1
UPL Ultra Petroleum Corp. 0.5% $1.26 $1.7 $1.7 $1.9 14.4  (7%) -1
GPRE Green Plains Inc. 0.5% $17.35 $16.5 $16.5 $18.3 9.6  (4%) 0
BCEI Bonanza Creek Energy Inc 0.4% $33.66 $36.5 $36.5 $35.6 1.2  (37%) 1
SD SandRidge Energy Inc. 0.3% $16.25 $16.8 $16.8 $16.5 6.3  (-5%) 2
REI Ring Energy Inc. 0.3% $11.89 $12.6 $12.6 $12.8 12.7  (1%) -1
PVAC Penn Virginia Corporation 0.2% $78.56 $84.3 $84.3 $82.2 4.1  (25%) 1
REGI Renewable Energy Group Inc. 0.2% $20.25 $17.5 $17.5 $17.6 18.9  (-3%) 4
PARR Par Pacific Holdings Inc 0.2% $17.25 $17.3 $17.3 $17.6 12.4  (-13%) -1
REX REX American Resources Corporation 0.1% $76.84 $75.4 $75.4 $76.5 13.1  (-2%) 2