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

XES Conmponent Weighting

Ticker
Symbol
Company Name ETF Weight Close Price 10-Day 20-Day 50-Day Short Int Ratio Technical Score
OIS Oil States International Inc. 4.1% $32.60 $33.3 $33.3 $33.3 9.3  (-10%) 1
RIG Transocean Ltd. 3.7% $12.41 $12.9 $12.9 $12.9 6.5  (5%) 1
ESV Ensco plc Class A 3.6% $7.09 $7.2 $7.2 $6.9 7.2  (0%) 4
DO Diamond Offshore Drilling Inc. 3.5% $18.15 $19.0 $19.0 $19.2 16.1  (-2%) 0
BHGE Baker Hughes a GE Company Class A 3.4% $34.67 $33.5 $33.5 $33.6 5.0  (11%) 2
CJ C&J Energy Services Inc. 3.4% $23.64 $23.0 $23.0 $23.8 5.3  (10%) 1
RDC Rowan Cos. Plc Class A 3.4% $13.30 $14.4 $14.4 $15.1 5.9  (-3%) 1
CLB Core Laboratories NV 3.3% $111.32 $113.1 $113.1 $118.9 13.2  (-10%) 1
SLCA U.S. Silica Holdings Inc. 3.3% $25.20 $25.4 $25.4 $27.1 4.4  (-7%) -2
HAL Halliburton Company 3.3% $41.51 $42.8 $42.8 $45.1 1.5  (59%) -2
WFT Weatherford International plc 3.3% $3.02 $3.3 $3.3 $3.4 9.0  (-3%) 1
OII Oceaneering International Inc. 3.2% $26.13 $26.5 $26.5 $25.3 5.8  (-3%) 4
PTEN Patterson-UTI Energy Inc. 3.2% $16.68 $16.8 $16.8 $17.9 2.0  (3%) -1
SPN Superior Energy Services Inc. 3.2% $9.42 $9.5 $9.5 $9.8 2.3  (-16%) -2
FTI TechnipFMC Plc 3.2% $29.99 $31.0 $31.0 $31.3 2.3  (-5%) -1
NBR Nabors Industries Ltd. 3.1% $6.27 $6.2 $6.2 $6.5 5.3  (12%) -0
NE Noble Corporation plc 3.0% $5.77 $5.9 $5.9 $5.9 11.3  (6%) 1
HP Helmerich & Payne Inc. 3.0% $60.50 $61.2 $61.2 $63.3 5.3  (3%) 0
NOV National Oilwell Varco Inc. 3.0% $45.65 $44.9 $44.9 $43.5 6.3  (3%) 4
PUMP ProPetro Holding Corp. 2.9% $16.93 $15.8 $15.8 $15.6 12.1  (-7%) 3
SLB Schlumberger NV 2.9% $65.40 $66.6 $66.6 $67.2 3.1  (3%) -2
FET Forum Energy Technologies Inc. 2.9% $12.20 $12.1 $12.1 $12.5 6.5  (-11%) 0
RES RPC Inc. 2.7% $14.69 $14.7 $14.7 $14.8 6.2  (15%) 1
FRAC Keane Group Inc. 2.7% $13.96 $13.1 $13.1 $13.4 2.4  (-29%) 2
DRQ Dril-Quip Inc. 2.6% $51.35 $54.2 $54.2 $51.7 11.5  (10%) 3
MDR McDermott International Inc. 2.5% $20.33 $18.7 $18.7 $19.6 14.7  (3%) 4
UNT Unit Corporation 1.8% $25.35 $25.2 $25.2 $24.4 9.0  (-8%) 3
HLX Helix Energy Solutions Group Inc. 1.8% $9.34 $9.2 $9.2 $8.3 3.2  (-5%) 4
BRS Bristow Group Inc. 1.5% $11.30 $13.6 $13.6 $13.5 6.1  (-2%) 0
BAS Basic Energy Services Inc. 1.5% $8.90 $10.1 $10.1 $11.4 3.2  (-15%) -1
AROC Archrock Inc. 1.4% $13.05 $13.0 $13.0 $12.4 2.1  (-20%) 3
FI Frank's International NV 1.1% $8.94 $8.4 $8.4 $7.9 13.1  (-2%) 5
CKH SEACOR Holdings Inc. 0.9% $51.22 $53.0 $53.0 $54.2 7.1  (-8%) 1
TDW Tidewater Inc 0.8% $32.68 $32.1 $32.1 $30.7 4.9  (17%) 3
EXTN Exterran Corp. 0.8% $27.78 $27.2 $27.2 $26.9 1.7  (5%) 1
NR Newpark Resources Inc. 0.7% $10.55 $10.2 $10.2 $10.4 6.8  (-5%) 2
TTI TETRA Technologies Inc. 0.7% $4.69 $4.4 $4.4 $4.4 11.4  (-4%) 1
MTRX Matrix Service Company 0.6% $20.35 $19.8 $19.8 $19.4 2.2  (-10%) 2