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% $51.64 $52.1 $52.1 $45.5 2.5  (-19%) 4
HFC HollyFrontier Corporation 2.2% $72.96 $75.6 $75.6 $66.6 3.0  (-4%) 4
CRC California Resources Corp 2.2% $37.61 $37.2 $37.2 $30.4 3.7  (-5%) 4
CRZO Carrizo Oil & Gas Inc. 2.2% $27.55 $26.0 $26.0 $22.4 3.4  (-5%) 3
ANDV Andeavor 2.2% $139.02 $144.1 $144.1 $132.7 1.1  (-35%) 2
OAS Oasis Petroleum Inc. 2.2% $12.63 $12.7 $12.7 $11.2 3.8  (11%) 4
SM SM Energy Company 2.1% $24.43 $24.8 $24.8 $23.3 4.6  (-24%) 3
QEP QEP Resources Inc. 2.1% $11.93 $12.3 $12.3 $12.0 4.1  (9%) 1
DK Delek US Holdings Inc 2.1% $51.92 $54.5 $54.5 $49.9 2.2  (-34%) 4
CLR Continental Resources Inc. 2.1% $64.26 $66.3 $66.3 $65.0 4.9  (-6%) 1
PBF PBF Energy Inc. Class A 2.0% $47.29 $47.1 $47.1 $41.7 2.9  (-4%) 4
OXY Occidental Petroleum Corporation 2.0% $84.35 $84.9 $84.9 $79.8 2.2  (13%) 3
RSPP RSP Permian Inc. 2.0% $40.50 $43.5 $43.5 $45.9 4.0  (4%) -2
WPX WPX Energy Inc. Class A 1.9% $17.76 $18.1 $18.1 $17.1 4.0  (2%) 2
MRO Marathon Oil Corporation 1.9% $21.12 $21.3 $21.3 $19.7 0.9  (-7%) 3
PSX Phillips 66 1.9% $115.55 $118.0 $118.0 $113.1 2.7  (39%) 3
NFX Newfield Exploration Company 1.9% $29.20 $29.2 $29.2 $28.1 2.2  (-24%) 2
VLO Valero Energy Corporation 1.9% $116.82 $120.7 $120.7 $113.0 2.9  (6%) 3
COP ConocoPhillips 1.9% $68.13 $68.7 $68.7 $66.8 2.8  (2%) 2
HES Hess Corporation 1.9% $60.97 $61.9 $61.9 $59.4 6.0  (-8%) 3
CPE Callon Petroleum Company 1.9% $10.21 $11.6 $11.6 $12.7 9.8  (11%) 0
MUR Murphy Oil Corporation 1.9% $33.51 $32.0 $32.0 $30.4 9.7  (7%) 5
DVN Devon Energy Corporation 1.9% $41.71 $41.6 $41.6 $38.3 1.4  (30%) 3
APA Apache Corporation 1.9% $42.89 $41.6 $41.6 $41.0 7.9  (2%) 4
PXD Pioneer Natural Resources Company 1.9% $191.45 $196.0 $196.0 $193.8 2.8  (-3%) 0
EOG EOG Resources Inc. 1.8% $117.53 $119.8 $119.8 $116.0 3.1  (2%) 2
APC Anadarko Petroleum Corporation 1.8% $71.04 $70.3 $70.3 $67.3 4.0  (-15%) 3
PE Parsley Energy Inc. Class A 1.8% $27.72 $29.1 $29.1 $29.7 2.2  (-12%) 0
EGN Energen Corporation 1.8% $63.78 $65.7 $65.7 $65.4 1.8  (-18%) 1
MPC Marathon Petroleum Corporation 1.8% $75.19 $78.7 $78.7 $77.4 2.3  (77%) 0
CVX Chevron Corporation 1.7% $126.51 $125.9 $125.9 $124.4 3.2  (8%) 2
NBL Noble Energy Inc. 1.7% $34.57 $35.4 $35.4 $33.9 3.2  (-15%) 2
XEC Cimarex Energy Co. 1.7% $86.55 $91.1 $91.1 $94.9 3.4  (9%) -2
MTDR Matador Resources Company 1.7% $26.43 $28.5 $28.5 $30.6 5.4  (1%) 1
XOM Exxon Mobil Corporation 1.7% $81.89 $81.5 $81.5 $79.6 2.6  (27%) 3
CXO Concho Resources Inc. 1.7% $127.25 $137.1 $137.1 $145.5 6.6  (0%) -1
PDCE PDC Energy Inc 1.7% $59.15 $61.8 $61.8 $57.5 4.1  (-11%) 3
FANG Diamondback Energy Inc. 1.6% $115.95 $121.3 $121.3 $123.6 1.8  (5%) -2
SWN Southwestern Energy Company 1.6% $5.20 $4.8 $4.8 $4.5 3.7  (-6%) 4
EQT EQT Corporation 1.5% $56.16 $52.6 $52.6 $50.6 3.2  (24%) 3
CHK Chesapeake Energy Corporation 1.5% $4.73 $4.5 $4.5 $3.7 5.9  (2%) 5
COG Cabot Oil & Gas Corporation 1.5% $23.61 $23.0 $23.0 $23.3 4.4  (0%) -1
LPI Laredo Petroleum Inc. 1.5% $8.55 $8.9 $8.9 $9.5 6.2  (8%) 0
AR Antero Resources Corporation 1.5% $19.76 $19.2 $19.2 $19.4 12.2  (0%) 3
RRC Range Resources Corporation 1.4% $16.15 $15.8 $15.8 $14.9 8.8  (-2%) 5
CNX CNX Resources Corporation 1.4% $16.98 $16.5 $16.5 $15.8 5.9  (16%) 5
GPOR Gulfport Energy Corporation 1.4% $11.07 $10.7 $10.7 $10.1 3.6  (25%) 2
CDEV Centennial Resource Development Inc. Class A 1.3% $16.78 $17.9 $17.9 $18.2 4.6  (-16%) -2
DNR Denbury Resources Inc. 1.1% $4.06 $4.2 $4.2 $3.7 5.0  (3%) 4
SRCI SRC Energy Inc 1.1% $10.78 $12.2 $12.2 $11.3 11.1  (-2%) 2
XOG Extraction Oil & Gas Inc. 0.9% $15.06 $16.2 $16.2 $14.5 7.0  (-13%) 5
KOS Kosmos Energy Ltd. 0.9% $8.05 $7.8 $7.8 $7.2 7.4  (-9%) 5
HK Halcon Resources Corp 0.8% $4.17 $4.7 $4.7 $5.0 6.2  (-3%) 0
HPR HighPoint Resources Corp. 0.8% $6.18 $6.8 $6.8 $6.4 5.1  (4%) 1
JAG Jagged Peak Energy Inc. 0.8% $11.49 $12.0 $12.0 $13.2 12.7  (58%) 1
REN Resolute Energy Corporation 0.7% $30.88 $32.9 $32.9 $33.4 10.5  (-1%) 0
CVI CVR Energy Inc. 0.7% $38.68 $41.5 $41.5 $38.2 12.4  (-4%) 4
INT World Fuel Services Corporation 0.6% $22.35 $21.7 $21.7 $23.3 2.8  (9%) -1
TELL Tellurian Inc. 0.5% $11.45 $11.2 $11.2 $10.3 12.3  (-2%) 3
UPL Ultra Petroleum Corp. 0.5% $1.98 $1.9 $1.9 $2.4 5.7  (13%) -0
GPRE Green Plains Inc. 0.5% $20.80 $20.8 $20.8 $19.2 8.5  (-14%) 5
BCEI Bonanza Creek Energy Inc 0.4% $33.55 $35.3 $35.3 $32.0 4.9  (-4%) 3
SD SandRidge Energy Inc. 0.3% $15.36 $14.8 $14.8 $14.6 4.3  (15%) 3
REI Ring Energy Inc. 0.3% $12.56 $13.9 $13.9 $14.9 6.9  (-2%) 0
PVAC Penn Virginia Corporation 0.2% $79.00 $70.6 $70.6 $56.3 1.8  (20%) 4
REGI Renewable Energy Group Inc. 0.2% $17.15 $17.5 $17.5 $15.1 4.7  (1%) 4
PARR Par Pacific Holdings Inc 0.2% $17.95 $18.0 $18.0 $17.9 14.9  (3%) 3
REX REX American Resources Corporation 0.1% $74.93 $74.8 $74.8 $74.4 15.6  (1%) 1