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

IYE Conmponent Weighting

Ticker
Symbol
Company Name ETF Weight Close Price 10-Day 20-Day 50-Day Short Int Ratio Technical Score
XOM EXXON MOBIL CORP 20.7% $80.32 $81.8 $81.8 $81.7 2.9  (-4%) -1
CVX CHEVRON CORP 15.2% $122.53 $123.8 $123.8 $124.5 3.4  (-3%) -1
SLB SCHLUMBERGER NV 6.0% $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.3% $122.31 $125.0 $125.0 $121.9 4.0  (-12%) 2
OXY OCCIDENTAL PETROLEUM CORP 3.7% $77.79 $82.7 $82.7 $83.6 1.8  (1%) -1
VLO VALERO ENERGY CORP 3.1% $115.14 $111.5 $111.5 $113.5 2.8  (-15%) 2
PSX PHILLIPS 3.1% $122.18 $116.3 $116.3 $115.0 1.9  (-15%) 4
HAL HALLIBURTON 2.9% $41.51 $42.8 $42.8 $45.1 1.5  (59%) -2
MPC MARATHON PETROLEUM CORP 2.3% $80.75 $76.5 $76.5 $75.2 6.1  (3%) 3
APC ANADARKO PETROLEUM CORP 2.2% $66.06 $70.7 $70.7 $71.3 3.3  (-11%) -1
PXD PIONEER NATURAL RESOURCE 2.1% $185.65 $185.4 $185.4 $187.1 3.5  (1%) -2
KMI KINDER MORGAN INC 2.0% $17.94 $17.8 $17.8 $17.5 3.6  (37%) 3
OKE ONEOK INC 1.6% $68.74 $69.7 $69.7 $69.4 3.2  (-26%) 1
CXO CONCHO RESOURCES INC 1.5% $134.84 $143.7 $143.7 $137.4 1.9  (-59%) -0
WMB WILLIAMS INC 1.4% $31.79 $29.4 $29.4 $28.0 3.3  (25%) 4
DVN DEVON ENERGY CORP 1.3% $42.07 $44.0 $44.0 $43.1 2.3  (4%) 0
ANDV ANDEAVOR 1.3% $149.92 $143.2 $143.2 $140.0 3.3  (3%) 4
NBL NOBLE ENERGY INC 1.0% $30.63 $34.3 $34.3 $34.8 7.1  (5%) 1
APA APACHE CORP 1.0% $43.29 $45.4 $45.4 $44.4 12.9  (-2%) 2
MRO MARATHON OIL CORP 1.0% $20.09 $20.7 $20.7 $20.9 1.5  (11%) 0
HES HESS CORP 1.0% $64.00 $65.1 $65.1 $64.0 4.8  (-11%) 1
BHGE BAKER HUGHES CLASS A 1.0% $34.67 $33.5 $33.5 $33.6 5.0  (11%) 2
NOV NATIONAL OILWELL VARCO INC 0.9% $45.65 $44.9 $44.9 $43.5 6.3  (3%) 4
FTI TECHNIPFMC PLC 0.9% $29.99 $31.0 $31.0 $31.3 2.3  (-5%) -1
FANG DIAMONDBACK ENERGY INC 0.8% $131.15 $132.4 $132.4 $127.0 5.7  (3%) 1
EQT EQT CORP 0.8% $49.95 $52.9 $52.9 $53.8 3.4  (-3%) -1
LNG CHENIERE ENERGY INC 0.8% $62.88 $62.6 $62.6 $64.3 5.1  (-13%) -1
HFC HOLLYFRONTIER CORP 0.7% $68.36 $70.7 $70.7 $71.8 4.3  (-10%) 1
COG CABOT OIL & GAS CORP 0.7% $23.54 $23.7 $23.7 $23.6 4.2  (38%) -1
TRGP TARGA RESOURCES CORP 0.7% $52.52 $52.1 $52.1 $50.2 8.2  (13%) 5
XEC CIMAREX ENERGY 0.6% $88.87 $96.6 $96.6 $94.7 3.7  (-22%) -1
PE PARSLEY ENERGY INC CLASS A 0.5% $29.96 $31.4 $31.4 $30.0 3.7  (-14%) -0
HP HELMERICH & PAYNE INC 0.5% $60.50 $61.2 $61.2 $63.3 5.3  (3%) 0
WPX WPX ENERGY INC 0.4% $18.29 $18.8 $18.8 $18.3 3.6  (-31%) 0
OGE OGE ENERGY CORP 0.4% $36.88 $35.9 $35.9 $35.1 1.4  (28%) 4
EGN ENERGEN CORP 0.4% $72.21 $74.0 $74.0 $70.2 3.5  (-26%) 2
CLR CONTINENTAL RESOURCES INC 0.4% $63.87 $62.3 $62.3 $63.6 5.3  (-8%) 3
NFX NEWFIELD EXPLORATION 0.4% $27.51 $28.5 $28.5 $29.2 3.1  (2%) -1
FSLR FIRST SOLAR INC 0.4% $54.45 $53.5 $53.5 $54.3 2.4  (-20%) 0
CLB CORE LABORATORIES NV 0.3% $111.32 $113.1 $113.1 $118.9 13.2  (-10%) 1
RIG TRANSOCEAN LTD 0.3% $12.41 $12.9 $12.9 $12.9 6.5  (5%) 1
MUR MURPHY OIL CORP 0.3% $30.16 $32.4 $32.4 $32.9 12.7  (-5%) 1
PTEN PATTERSON UTI ENERGY INC 0.3% $16.68 $16.8 $16.8 $17.9 2.0  (3%) -1
PBF PBF ENERGY INC CLASS A 0.3% $50.20 $45.4 $45.4 $45.5 3.8  (-1%) 3
AR ANTERO RESOURCES CORP 0.3% $18.71 $20.4 $20.4 $20.4 11.4  (-7%) 1
WLL WHITING PETROLEUM CORP 0.2% $47.49 $49.1 $49.1 $51.0 4.1  (-4%) 0
PDCE PDC ENERGY INC 0.2% $55.25 $60.7 $60.7 $60.7 6.3  (-1%) 1
RRC RANGE RESOURCES CORP 0.2% $16.11 $15.9 $15.9 $16.2 6.6  (8%) 0
CNX CNX RESOURCES CORP 0.2% $16.02 $16.6 $16.6 $16.9 5.3  (-1%) -1
OAS OASIS PETROLEUM INC 0.2% $12.80 $12.3 $12.3 $12.7 7.3  (3%) 2
WFT WEATHERFORD INTERNATIONAL PLC 0.2% $3.02 $3.3 $3.3 $3.4 9.0  (-3%) 1
QEP QEP RESOURCES INC 0.2% $9.93 $11.2 $11.2 $11.7 3.3  (-5%) -1
CHK CHESAPEAKE ENERGY CORP 0.2% $4.63 $4.6 $4.6 $4.8 3.8  (2%) 1
ESV ENSCO PLC CLASS A 0.2% $7.09 $7.2 $7.2 $6.9 7.2  (0%) 4
SLCA US SILICA HOLDINGS INC 0.2% $25.20 $25.4 $25.4 $27.1 4.4  (-7%) -2
SM SM ENERGY 0.2% $27.56 $27.2 $27.2 $25.9 5.6  (-9%) 4
NBR NABORS INDUSTRIES LTD 0.2% $6.27 $6.2 $6.2 $6.5 5.3  (12%) -0
SWN SOUTHWESTERN ENERGY 0.1% $5.42 $5.2 $5.2 $5.2 4.1  (-1%) 3
OII OCEANEERING INTERNATIONAL INC 0.1% $26.13 $26.5 $26.5 $25.3 5.8  (-3%) 4
SPN SUPERIOR ENERGY SERVICES INC 0.1% $9.42 $9.5 $9.5 $9.8 2.3  (-16%) -2
SEMG SEMGROUP CORP CLASS A 0.1% $25.65 $24.9 $24.9 $25.1 14.6  (-10%) 2
DRQ DRIL QUIP INC 0.1% $51.35 $54.2 $54.2 $51.7 11.5  (10%) 3
RDC ROWAN COMPANIES CLASS A PLC 0.1% $13.30 $14.4 $14.4 $15.1 5.9  (-3%) 1
GPOR GULFPORT ENERGY CORP 0.1% $11.39 $11.7 $11.7 $11.6 4.6  (8%) 1
INT WORLD FUEL SERVICES CORP 0.1% $26.38 $24.1 $24.1 $22.6 3.2  (-17%) 3