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% $81.89 $81.5 $81.5 $79.6 2.6  (27%) 3
CVX CHEVRON CORP 15.2% $126.51 $125.9 $125.9 $124.4 3.2  (8%) 2
SLB SCHLUMBERGER NV 6.0% $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.3% $117.53 $119.8 $119.8 $116.0 3.1  (2%) 2
OXY OCCIDENTAL PETROLEUM CORP 3.7% $84.35 $84.9 $84.9 $79.8 2.2  (13%) 3
VLO VALERO ENERGY CORP 3.1% $116.82 $120.7 $120.7 $113.0 2.9  (6%) 3
PSX PHILLIPS 3.1% $115.55 $118.0 $118.0 $113.1 2.7  (39%) 3
HAL HALLIBURTON 2.9% $47.73 $50.1 $50.1 $50.8 2.1  (-10%) -1
MPC MARATHON PETROLEUM CORP 2.3% $75.19 $78.7 $78.7 $77.4 2.3  (77%) 0
APC ANADARKO PETROLEUM CORP 2.2% $71.04 $70.3 $70.3 $67.3 4.0  (-15%) 3
PXD PIONEER NATURAL RESOURCE 2.1% $191.45 $196.0 $196.0 $193.8 2.8  (-3%) 0
KMI KINDER MORGAN INC 2.0% $16.95 $16.5 $16.5 $16.2 3.4  (-8%) 3
OKE ONEOK INC 1.6% $69.34 $67.7 $67.7 $63.7 4.6  (-8%) 4
CXO CONCHO RESOURCES INC 1.5% $127.25 $137.1 $137.1 $145.5 6.6  (0%) -1
WMB WILLIAMS INC 1.4% $27.21 $27.0 $27.0 $26.3 2.4  (-7%) 1
DVN DEVON ENERGY CORP 1.3% $41.71 $41.6 $41.6 $38.3 1.4  (30%) 3
ANDV ANDEAVOR 1.3% $139.02 $144.1 $144.1 $132.7 1.1  (-35%) 2
NBL NOBLE ENERGY INC 1.0% $34.57 $35.4 $35.4 $33.9 3.2  (-15%) 2
APA APACHE CORP 1.0% $42.89 $41.6 $41.6 $41.0 7.9  (2%) 4
MRO MARATHON OIL CORP 1.0% $21.12 $21.3 $21.3 $19.7 0.9  (-7%) 3
HES HESS CORP 1.0% $60.97 $61.9 $61.9 $59.4 6.0  (-8%) 3
BHGE BAKER HUGHES CLASS A 1.0% $33.68 $34.9 $34.9 $34.4 6.8  (17%) 2
NOV NATIONAL OILWELL VARCO INC 0.9% $42.16 $42.4 $42.4 $40.3 9.4  (5%) 4
FTI TECHNIPFMC PLC 0.9% $32.16 $32.3 $32.3 $32.2 2.4  (-8%) 2
FANG DIAMONDBACK ENERGY INC 0.8% $115.95 $121.3 $121.3 $123.6 1.8  (5%) -2
EQT EQT CORP 0.8% $56.16 $52.6 $52.6 $50.6 3.2  (24%) 3
LNG CHENIERE ENERGY INC 0.8% $64.93 $64.4 $64.4 $61.0 4.0  (-2%) 4
HFC HOLLYFRONTIER CORP 0.7% $72.96 $75.6 $75.6 $66.6 3.0  (-4%) 4
COG CABOT OIL & GAS CORP 0.7% $23.61 $23.0 $23.0 $23.3 4.4  (0%) -1
TRGP TARGA RESOURCES CORP 0.7% $48.52 $48.5 $48.5 $47.4 5.8  (-2%) 4
XEC CIMAREX ENERGY 0.6% $86.55 $91.1 $91.1 $94.9 3.4  (9%) -2
PE PARSLEY ENERGY INC CLASS A 0.5% $27.72 $29.1 $29.1 $29.7 2.2  (-12%) 0
HP HELMERICH & PAYNE INC 0.5% $64.97 $67.3 $67.3 $69.0 7.7  (4%) 2
WPX WPX ENERGY INC 0.4% $17.76 $18.1 $18.1 $17.1 4.0  (2%) 2
OGE OGE ENERGY CORP 0.4% $34.56 $34.1 $34.1 $33.4 1.8  (1%) 4
EGN ENERGEN CORP 0.4% $63.78 $65.7 $65.7 $65.4 1.8  (-18%) 1
RSPP RSP PERMIAN INC 0.4% $40.50 $43.5 $43.5 $45.9 4.0  (4%) -2
CLR CONTINENTAL RESOURCES INC 0.4% $64.26 $66.3 $66.3 $65.0 4.9  (-6%) 1
NFX NEWFIELD EXPLORATION 0.4% $29.20 $29.2 $29.2 $28.1 2.2  (-24%) 2
FSLR FIRST SOLAR INC 0.4% $53.71 $62.6 $62.6 $68.0 2.0  (-8%) -1
CLB CORE LABORATORIES NV 0.3% $125.07 $125.9 $125.9 $121.8 16.8  (-5%) 4
RIG TRANSOCEAN LTD 0.3% $12.31 $12.9 $12.9 $12.3 4.5  (-8%) 2
MUR MURPHY OIL CORP 0.3% $33.51 $32.0 $32.0 $30.4 9.7  (7%) 5
PTEN PATTERSON UTI ENERGY INC 0.3% $18.69 $20.5 $20.5 $20.6 3.1  (-6%) 0
PBF PBF ENERGY INC CLASS A 0.3% $47.29 $47.1 $47.1 $41.7 2.9  (-4%) 4
AR ANTERO RESOURCES CORP 0.3% $19.76 $19.2 $19.2 $19.4 12.2  (0%) 3
WLL WHITING PETROLEUM CORP 0.2% $51.64 $52.1 $52.1 $45.5 2.5  (-19%) 4
PDCE PDC ENERGY INC 0.2% $59.15 $61.8 $61.8 $57.5 4.1  (-11%) 3
RRC RANGE RESOURCES CORP 0.2% $16.15 $15.8 $15.8 $14.9 8.8  (-2%) 5
CNX CNX RESOURCES CORP 0.2% $16.98 $16.5 $16.5 $15.8 5.9  (16%) 5
OAS OASIS PETROLEUM INC 0.2% $12.63 $12.7 $12.7 $11.2 3.8  (11%) 4
WFT WEATHERFORD INTERNATIONAL PLC 0.2% $3.50 $3.5 $3.5 $3.1 5.9  (-1%) 4
QEP QEP RESOURCES INC 0.2% $11.93 $12.3 $12.3 $12.0 4.1  (9%) 1
CHK CHESAPEAKE ENERGY CORP 0.2% $4.73 $4.5 $4.5 $3.7 5.9  (2%) 5
ESV ENSCO PLC CLASS A 0.2% $6.29 $6.7 $6.7 $6.1 7.3  (3%) 4
SLCA US SILICA HOLDINGS INC 0.2% $28.38 $31.1 $31.1 $30.0 7.6  (2%) 2
SM SM ENERGY 0.2% $24.43 $24.8 $24.8 $23.3 4.6  (-24%) 3
NBR NABORS INDUSTRIES LTD 0.2% $6.99 $7.6 $7.6 $7.6 2.3  (7%) 0
SWN SOUTHWESTERN ENERGY 0.1% $5.20 $4.8 $4.8 $4.5 3.7  (-6%) 4
OII OCEANEERING INTERNATIONAL INC 0.1% $23.79 $24.0 $24.0 $22.2 6.7  (12%) 4
SPN SUPERIOR ENERGY SERVICES INC 0.1% $9.80 $11.0 $11.0 $10.5 4.0  (-8%) 1
SEMG SEMGROUP CORP CLASS A 0.1% $25.00 $25.2 $25.2 $24.5 12.3  (-7%) 2
DRQ DRIL QUIP INC 0.1% $48.55 $48.0 $48.0 $45.9 10.5  (-1%) 4
RDC ROWAN COMPANIES CLASS A PLC 0.1% $15.39 $15.9 $15.9 $15.1 5.0  (-8%) 2
GPOR GULFPORT ENERGY CORP 0.1% $11.07 $10.7 $10.7 $10.1 3.6  (25%) 2
INT WORLD FUEL SERVICES CORP 0.1% $22.35 $21.7 $21.7 $23.3 2.8  (9%) -1