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

XTN Conmponent Weighting

Ticker
Symbol
Company Name ETF Weight Close Price 10-Day 20-Day 50-Day Short Int Ratio Technical Score
KEX Kirby Corporation 3.0% $85.65 $90.5 $90.5 $87.8 8.5  (-12%) 2
HA Hawaiian Holdings Inc. 3.0% $37.15 $38.2 $38.2 $38.8 3.8  (-15%) -1
HTZ Hertz Global Holdings Inc. 2.9% $18.07 $16.3 $16.3 $18.7 4.1  (11%) -0
CAR Avis Budget Group Inc. 2.7% $41.93 $40.9 $40.9 $44.5 4.5  (-15%) -2
CSX CSX Corporation 2.7% $65.89 $65.0 $65.0 $61.5 3.1  (-14%) 4
AAWW Atlas Air Worldwide Holdings Inc. 2.7% $72.85 $70.3 $70.3 $66.9 9.9  (2%) 5
UPS United Parcel Service Inc. Class B 2.6% $117.19 $116.4 $116.4 $112.8 4.3  (0%) 3
SKYW SkyWest Inc 2.6% $56.25 $57.0 $57.0 $56.3 2.3  (-9%) -1
HUBG Hub Group Inc. Class A 2.6% $50.90 $49.7 $49.7 $46.2 2.4  (2%) 4
UHAL AMERCO 2.6% $352.09 $348.3 $348.3 $345.4 7.1  (3%) 1
GWR Genesee & Wyoming Inc. Class A 2.6% $80.56 $78.6 $78.6 $75.0 4.5  (5%) 4
ALK Alaska Air Group Inc. 2.6% $62.50 $60.7 $60.7 $62.0 2.7  (-17%) 0
NSC Norfolk Southern Corporation 2.6% $153.47 $153.0 $153.0 $145.7 4.3  (12%) 3
SNDR Schneider National Inc. Class B 2.6% $28.69 $29.2 $29.2 $27.8 8.6  (-1%) 5
FDX FedEx Corporation 2.6% $263.48 $254.7 $254.7 $248.9 3.3  (7%) 4
EXPD Expeditors International of Washington Inc. 2.6% $76.77 $75.0 $75.0 $69.3 4.2  (-18%) 4
JBHT J.B. Hunt Transport Services Inc. 2.5% $129.65 $127.9 $127.9 $121.8 5.4  (-16%) 5
UNP Union Pacific Corporation 2.5% $144.94 $144.3 $144.3 $138.9 3.6  (17%) 4
KSU Kansas City Southern 2.5% $108.66 $109.0 $109.0 $109.1 2.4  (-1%) -0
UAL United Continental Holdings Inc. 2.5% $73.02 $70.4 $70.4 $68.9 4.9  (-6%) 4
MIC Macquarie Infrastructure Corporation 2.5% $41.71 $39.2 $39.2 $38.7 6.9  (5%) 3
DAL Delta Air Lines Inc. 2.4% $54.90 $54.2 $54.2 $53.5 2.1  (-7%) 0
ALGT Allegiant Travel Company 2.4% $149.55 $153.1 $153.1 $156.1 10.4  (7%) 0
LSTR Landstar System Inc. 2.4% $113.70 $113.3 $113.3 $109.5 4.7  (23%) 3
SAIA Saia Inc. 2.4% $82.80 $81.6 $81.6 $76.3 3.4  (4%) 4
CHRW C.H. Robinson Worldwide Inc. 2.4% $90.43 $88.5 $88.5 $89.4 6.1  (-13%) 3
ODFL Old Dominion Freight Line Inc. 2.4% $160.28 $155.6 $155.6 $147.5 4.0  (19%) 4
XPO XPO Logistics Inc. 2.4% $111.66 $109.2 $109.2 $104.7 6.1  (2%) 4
WERN Werner Enterprises Inc. 2.4% $38.50 $38.5 $38.5 $36.9 10.7  (7%) 3
JBLU JetBlue Airways Corporation 2.3% $19.04 $19.0 $19.0 $19.3 3.5  (-7%) -1
R Ryder System Inc. 2.3% $71.46 $68.6 $68.6 $69.5 3.8  (-11%) 1
LUV Southwest Airlines Co. 2.3% $51.94 $51.3 $51.3 $52.7 1.9  (-12%) -2
ECHO Echo Global Logistics Inc 2.2% $30.45 $28.4 $28.4 $28.2 5.9  (30%) 4
FWRD Forward Air Corporation 2.2% $61.05 $59.9 $59.9 $56.7 3.4  (-9%) 4
SAVE Spirit Airlines Inc. 2.2% $38.17 $37.2 $37.2 $36.9 8.4  (5%) 2
KNX Knight-Swift Transportation Holdings Inc. Class A 2.1% $41.81 $40.5 $40.5 $41.2 9.2  (-4%) 2
AAL American Airlines Group Inc. 2.0% $43.08 $43.7 $43.7 $44.6 4.3  (3%) -1
ARCB ArcBest Corporation 1.9% $47.60 $48.0 $48.0 $40.5 1.7  (9%) 3
ATSG Air Transport Services Group Inc. 1.8% $24.02 $22.1 $22.1 $21.8 2.9  (-7%) 1
HTLD Heartland Express Inc. 1.8% $19.01 $18.9 $18.9 $18.4 11.3  (-7%) 2
MATX Matson Inc. 1.5% $38.21 $35.4 $35.4 $32.3 6.4  (3%) 4
MRTN Marten Transport Ltd. 1.0% $23.10 $22.6 $22.6 $21.8 2.3  (-45%) 1