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.80 $35.2 $35.2 $34.2 6.2  (-1%) 3
RIG Transocean Ltd. 3.7% $12.31 $12.9 $12.9 $12.3 4.5  (-8%) 2
ESV Ensco plc Class A 3.6% $6.29 $6.7 $6.7 $6.1 7.3  (3%) 4
DO Diamond Offshore Drilling Inc. 3.5% $18.86 $18.9 $18.9 $18.6 15.2  (1%) 3
BHGE Baker Hughes a GE Company Class A 3.4% $33.68 $34.9 $34.9 $34.4 6.8  (17%) 2
CJ C&J Energy Services Inc. 3.4% $23.43 $27.2 $27.2 $28.3 2.7  (-23%) -1
RDC Rowan Cos. Plc Class A 3.4% $15.39 $15.9 $15.9 $15.1 5.0  (-8%) 2
CLB Core Laboratories NV 3.3% $125.07 $125.9 $125.9 $121.8 16.8  (-5%) 4
SLCA U.S. Silica Holdings Inc. 3.3% $28.38 $31.1 $31.1 $30.0 7.6  (2%) 2
HAL Halliburton Company 3.3% $47.73 $50.1 $50.1 $50.8 2.1  (-10%) -1
WFT Weatherford International plc 3.3% $3.50 $3.5 $3.5 $3.1 5.9  (-1%) 4
OII Oceaneering International Inc. 3.2% $23.79 $24.0 $24.0 $22.2 6.7  (12%) 4
PTEN Patterson-UTI Energy Inc. 3.2% $18.69 $20.5 $20.5 $20.6 3.1  (-6%) 0
SPN Superior Energy Services Inc. 3.2% $9.80 $11.0 $11.0 $10.5 4.0  (-8%) 1
FTI TechnipFMC Plc 3.2% $32.16 $32.3 $32.3 $32.2 2.4  (-8%) 2
NBR Nabors Industries Ltd. 3.1% $6.99 $7.6 $7.6 $7.6 2.3  (7%) 0
NE Noble Corporation plc 3.0% $5.45 $5.7 $5.7 $5.1 9.1  (-2%) 4
HP Helmerich & Payne Inc. 3.0% $64.97 $67.3 $67.3 $69.0 7.7  (4%) 2
NOV National Oilwell Varco Inc. 3.0% $42.16 $42.4 $42.4 $40.3 9.4  (5%) 4
PUMP ProPetro Holding Corp. 2.9% $14.62 $16.8 $16.8 $17.6 4.9  (6%) -1
SLB Schlumberger NV 2.9% $68.33 $70.3 $70.3 $69.4 3.5  (2%) 0
FET Forum Energy Technologies Inc. 2.9% $12.05 $13.9 $13.9 $13.3 6.9  (-4%) 2
RES RPC Inc. 2.7% $14.19 $16.5 $16.5 $17.7 10.6  (-36%) 0
FRAC Keane Group Inc. 2.7% $13.66 $14.8 $14.8 $15.3 4.4  (-11%) -2
DRQ Dril-Quip Inc. 2.6% $48.55 $48.0 $48.0 $45.9 10.5  (-1%) 4
MDR McDermott International Inc. 2.5% $20.87 $21.6 $21.6 $14.0 4.6  (-49%) 3
UNT Unit Corporation 1.8% $22.85 $22.0 $22.0 $21.7 5.7  (-4%) 4
HLX Helix Energy Solutions Group Inc. 1.8% $7.42 $7.8 $7.8 $7.4 4.6  (-5%) 2
BRS Bristow Group Inc. 1.5% $13.00 $14.1 $14.1 $15.2 6.5  (-15%) 0
BAS Basic Energy Services Inc. 1.5% $12.78 $13.7 $13.7 $14.6 2.5  (4%) -1
AROC Archrock Inc. 1.4% $11.35 $11.7 $11.7 $11.0 0.5  (-73%) 3
FI Frank's International NV 1.1% $7.78 $7.5 $7.5 $7.1 9.8  (3%) 5
CKH SEACOR Holdings Inc. 0.9% $53.99 $52.9 $52.9 $54.2 3.3  (-8%) 2
TDW Tidewater Inc 0.8% $29.28 $30.3 $30.3 $31.9 3.6  (2%) 1
EXTN Exterran Corp. 0.8% $27.30 $28.1 $28.1 $28.6 1.1  (-9%) -2
NR Newpark Resources Inc. 0.7% $10.30 $10.6 $10.6 $10.1 7.3  (3%) 3
TTI TETRA Technologies Inc. 0.7% $4.33 $4.4 $4.4 $4.1 5.9  (20%) 3
MTRX Matrix Service Company 0.6% $19.30 $18.9 $18.9 $17.1 4.7  (-2%) 3