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% $68.33 $70.3 $70.3 $69.4 3.5  (2%) 0
HAL HALLIBURTON 10.7% $47.73 $50.1 $50.1 $50.8 2.1  (-10%) -1
BHGE BAKER HUGHES CLASS A 6.1% $33.68 $34.9 $34.9 $34.4 6.8  (17%) 2
FTI TECHNIPFMC PLC 5.7% $32.16 $32.3 $32.3 $32.2 2.4  (-8%) 2
NOV NATIONAL OILWELL VARCO INC 5.6% $42.16 $42.4 $42.4 $40.3 9.4  (5%) 4
HP HELMERICH & PAYNE INC 3.9% $64.97 $67.3 $67.3 $69.0 7.7  (4%) 2
RIG TRANSOCEAN LTD 3.5% $12.31 $12.9 $12.9 $12.3 4.5  (-8%) 2
CLB CORE LABORATORIES NV 3.3% $125.07 $125.9 $125.9 $121.8 16.8  (-5%) 4
PTEN PATTERSON UTI ENERGY INC 3.2% $18.69 $20.5 $20.5 $20.6 3.1  (-6%) 0
WFT WEATHERFORD INTERNATIONAL PLC 2.4% $3.50 $3.5 $3.5 $3.1 5.9  (-1%) 4
ESV ENSCO PLC CLASS A 2.3% $6.29 $6.7 $6.7 $6.1 7.3  (3%) 4
OIS OIL STATES INTERNATIONAL INC 2.3% $32.80 $35.2 $35.2 $34.2 6.2  (-1%) 3
SLCA US SILICA HOLDINGS INC 2.2% $28.38 $31.1 $31.1 $30.0 7.6  (2%) 2
AROC ARCHROCK INC 2.2% $11.35 $11.7 $11.7 $11.0 0.5  (-73%) 3
NBR NABORS INDUSTRIES LTD 2.1% $6.99 $7.6 $7.6 $7.6 2.3  (7%) 0
OII OCEANEERING INTERNATIONAL INC 2.0% $23.79 $24.0 $24.0 $22.2 6.7  (12%) 4
CJ C J ENERGY SVCS INC 2.0% $23.43 $27.2 $27.2 $28.3 2.7  (-23%) -1
SPN SUPERIOR ENERGY SERVICES INC 1.8% $9.80 $11.0 $11.0 $10.5 4.0  (-8%) 1
RDC ROWAN COMPANIES CLASS A PLC 1.8% $15.39 $15.9 $15.9 $15.1 5.0  (-8%) 2
MDR MCDERMOTT INTERNATIONAL INC 1.7% $20.87 $21.6 $21.6 $14.0 4.6  (-49%) 3
DRQ DRIL QUIP INC 1.6% $48.55 $48.0 $48.0 $45.9 10.5  (-1%) 4
DO DIAMOND OFFSHORE DRILLING INC 1.5% $18.86 $18.9 $18.9 $18.6 15.2  (1%) 3
HLX HELIX ENERGY SOLUTIONS GROUP INC 1.5% $7.42 $7.8 $7.8 $7.4 4.6  (-5%) 2
UNT UNIT CORP 1.5% $22.85 $22.0 $22.0 $21.7 5.7  (-4%) 4
NE NOBLE PLC 1.4% $5.45 $5.7 $5.7 $5.1 9.1  (-2%) 4
PUMP PROPETRO HOLDING CORP 1.4% $14.62 $16.8 $16.8 $17.6 4.9  (6%) -1
RES RPC INC 1.4% $14.19 $16.5 $16.5 $17.7 10.6  (-36%) 0
NR NEWPARK RESOURCES INC 1.3% $10.30 $10.6 $10.6 $10.1 7.3  (3%) 3
FET FORUM ENERGY TECHNOLOGIES INC 1.3% $12.05 $13.9 $13.9 $13.3 6.9  (-4%) 2
EXTN EXTERRAN CORP 1.3% $27.30 $28.1 $28.1 $28.6 1.1  (-9%) -2
CKH SEACOR HOLDINGS INC 1.3% $53.99 $52.9 $52.9 $54.2 3.3  (-8%) 2
TDW TIDEWATER INC 1.3% $29.28 $30.3 $30.3 $31.9 3.6  (2%) 1
FRAC KEANE GROUP INC 1.1% $13.66 $14.8 $14.8 $15.3 4.4  (-11%) -2
FI FRANK S INTERNATIONAL NV 0.9% $7.78 $7.5 $7.5 $7.1 9.8  (3%) 5