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

IEZ Conmponent Weighting

Ticker
Symbol
Company Name ETF Weight Close Price 10-Day 20-Day 50-Day Short Int Ratio Technical Score
SLB SCHLUMBERGER NV 15.2% $65.40 $66.6 $66.6 $67.2 3.1  (3%) -2
HAL HALLIBURTON 10.7% $41.51 $42.8 $42.8 $45.1 1.5  (59%) -2
BHGE BAKER HUGHES CLASS A 6.1% $34.67 $33.5 $33.5 $33.6 5.0  (11%) 2
FTI TECHNIPFMC PLC 5.7% $29.99 $31.0 $31.0 $31.3 2.3  (-5%) -1
NOV NATIONAL OILWELL VARCO INC 5.6% $45.65 $44.9 $44.9 $43.5 6.3  (3%) 4
HP HELMERICH & PAYNE INC 3.9% $60.50 $61.2 $61.2 $63.3 5.3  (3%) 0
RIG TRANSOCEAN LTD 3.5% $12.41 $12.9 $12.9 $12.9 6.5  (5%) 1
CLB CORE LABORATORIES NV 3.3% $111.32 $113.1 $113.1 $118.9 13.2  (-10%) 1
PTEN PATTERSON UTI ENERGY INC 3.2% $16.68 $16.8 $16.8 $17.9 2.0  (3%) -1
WFT WEATHERFORD INTERNATIONAL PLC 2.4% $3.02 $3.3 $3.3 $3.4 9.0  (-3%) 1
ESV ENSCO PLC CLASS A 2.3% $7.09 $7.2 $7.2 $6.9 7.2  (0%) 4
OIS OIL STATES INTERNATIONAL INC 2.3% $32.60 $33.3 $33.3 $33.3 9.3  (-10%) 1
SLCA US SILICA HOLDINGS INC 2.2% $25.20 $25.4 $25.4 $27.1 4.4  (-7%) -2
AROC ARCHROCK INC 2.2% $13.05 $13.0 $13.0 $12.4 2.1  (-20%) 3
NBR NABORS INDUSTRIES LTD 2.1% $6.27 $6.2 $6.2 $6.5 5.3  (12%) -0
OII OCEANEERING INTERNATIONAL INC 2.0% $26.13 $26.5 $26.5 $25.3 5.8  (-3%) 4
CJ C J ENERGY SVCS INC 2.0% $23.64 $23.0 $23.0 $23.8 5.3  (10%) 1
SPN SUPERIOR ENERGY SERVICES INC 1.8% $9.42 $9.5 $9.5 $9.8 2.3  (-16%) -2
RDC ROWAN COMPANIES CLASS A PLC 1.8% $13.30 $14.4 $14.4 $15.1 5.9  (-3%) 1
MDR MCDERMOTT INTERNATIONAL INC 1.7% $20.33 $18.7 $18.7 $19.6 14.7  (3%) 4
DRQ DRIL QUIP INC 1.6% $51.35 $54.2 $54.2 $51.7 11.5  (10%) 3
DO DIAMOND OFFSHORE DRILLING INC 1.5% $18.15 $19.0 $19.0 $19.2 16.1  (-2%) 0
HLX HELIX ENERGY SOLUTIONS GROUP INC 1.5% $9.34 $9.2 $9.2 $8.3 3.2  (-5%) 4
UNT UNIT CORP 1.5% $25.35 $25.2 $25.2 $24.4 9.0  (-8%) 3
NE NOBLE PLC 1.4% $5.77 $5.9 $5.9 $5.9 11.3  (6%) 1
PUMP PROPETRO HOLDING CORP 1.4% $16.93 $15.8 $15.8 $15.6 12.1  (-7%) 3
RES RPC INC 1.4% $14.69 $14.7 $14.7 $14.8 6.2  (15%) 1
NR NEWPARK RESOURCES INC 1.3% $10.55 $10.2 $10.2 $10.4 6.8  (-5%) 2
FET FORUM ENERGY TECHNOLOGIES INC 1.3% $12.20 $12.1 $12.1 $12.5 6.5  (-11%) 0
EXTN EXTERRAN CORP 1.3% $27.78 $27.2 $27.2 $26.9 1.7  (5%) 1
CKH SEACOR HOLDINGS INC 1.3% $51.22 $53.0 $53.0 $54.2 7.1  (-8%) 1
TDW TIDEWATER INC 1.3% $32.68 $32.1 $32.1 $30.7 4.9  (17%) 3
FRAC KEANE GROUP INC 1.1% $13.96 $13.1 $13.1 $13.4 2.4  (-29%) 2
FI FRANK S INTERNATIONAL NV 0.9% $8.94 $8.4 $8.4 $7.9 13.1  (-2%) 5