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

XTL Conmponent Weighting

Ticker
Symbol
Company Name ETF Weight Close Price 10-Day 20-Day 50-Day Short Int Ratio Technical Score
FTR Frontier Communications Corporation Class B 3.4% $7.84 $8.0 $8.0 $8.5 6.1  (-1%) 1
FFIV F5 Networks Inc. 3.1% $181.64 $175.6 $175.6 $165.9 4.7  (6%) 4
AAOI Applied Optoelectronics Inc. 2.9% $43.74 $40.3 $40.3 $34.5 10.4  (-7%) 4
CCOI Cogent Communications Holdings Inc 2.9% $53.40 $51.3 $51.3 $49.1 8.1  (-1%) 5
VG Vonage Holdings Corp. 2.9% $12.43 $11.6 $11.6 $11.3 2.8  (-19%) 3
PANW Palo Alto Networks Inc. 2.9% $215.56 $206.0 $206.0 $199.1 4.2  (-7%) 3
UBNT Ubiquiti Networks Inc. 2.8% $87.57 $83.4 $83.4 $77.4 16.0  (-8%) 5
OCLR Oclaro Inc. 2.8% $9.13 $9.0 $9.0 $8.7 3.7  (8%) 2
CTL CenturyLink Inc. 2.8% $18.01 $18.2 $18.2 $18.2 7.8  (-9%) 2
IDCC InterDigital Inc. 2.8% $85.30 $81.0 $81.0 $79.0 5.1  (-15%) 5
MSI Motorola Solutions Inc. 2.7% $113.90 $110.6 $110.6 $109.1 3.5  (3%) 4
NTCT NetScout Systems Inc. 2.7% $29.95 $27.6 $27.6 $27.4 7.9  (4%) 4
S Sprint Corp. 2.7% $5.46 $5.2 $5.2 $5.4 6.4  (32%) 4
VZ Verizon Communications Inc. 2.7% $47.82 $48.3 $48.3 $48.3 1.8  (-17%) 0
CSCO Cisco Systems Inc. 2.6% $44.69 $43.6 $43.6 $43.9 2.7  (11%) 1
CIEN Ciena Corporation 2.6% $24.95 $24.5 $24.5 $25.4 5.2  (-2%) 0
ARRS ARRIS International Plc 2.6% $26.16 $26.0 $26.0 $26.6 2.9  (-13%) -1
ZAYO Zayo Group Holdings Inc. 2.6% $36.56 $35.1 $35.1 $35.4 3.7  (-4%) 1
TDS Telephone and Data Systems Inc. 2.6% $27.06 $26.1 $26.1 $27.0 3.4  (-16%) 1
JNPR Juniper Networks Inc. 2.6% $27.82 $27.3 $27.3 $26.0 2.3  (-4%) 3
NTGR NETGEAR Inc. 2.5% $65.10 $62.0 $62.0 $59.9 9.3  (-2%) 4
VIAV Viavi Solutions Inc. 2.5% $9.83 $9.8 $9.8 $9.9 3.4  (-1%) -1
ANET Arista Networks Inc. 2.4% $281.12 $262.9 $262.9 $259.8 2.8  (19%) 2
TMUS T-Mobile US Inc. 2.4% $59.53 $57.3 $57.3 $58.9 1.8  (26%) 1
CNSL Consolidated Communications Holdings Inc. 2.4% $12.65 $11.6 $11.6 $11.5 14.5  (-6%) 4
T AT&T Inc. 2.4% $32.52 $32.8 $32.8 $33.4 6.1  (1%) 0
VSAT ViaSat Inc. 2.3% $64.93 $63.1 $63.1 $63.6 24.3  (-7%) 2
EXTR Extreme Networks Inc. 2.3% $9.06 $9.0 $9.0 $9.8 1.5  (-7%) -0
LITE Lumentum Holdings Inc. 2.3% $59.05 $61.1 $61.1 $60.2 5.1  (-13%) 1
FNSR Finisar Corporation 2.3% $17.70 $17.1 $17.1 $16.4 11.7  (-4%) 4
INFN Infinera Corporation 2.1% $9.85 $9.5 $9.5 $10.5 4.4  (-8%) -1
PLT Plantronics Inc. 2.0% $75.78 $73.3 $73.3 $67.9 2.2  (-8%) 4
COMM CommScope Holding Co. Inc. 1.9% $30.27 $29.8 $29.8 $33.2 2.1  (33%) -2
ACIA Acacia Communications Inc. 1.9% $35.32 $33.5 $33.5 $32.3 3.4  (-16%) 2
ADTN ADTRAN Inc. 1.7% $15.15 $14.8 $14.8 $14.9 4.5  (5%) 1
SATS EchoStar Corporation Class A 1.5% $46.75 $48.1 $48.1 $51.3 2.7  (-15%) -2
IRDM Iridium Communications Inc. 1.5% $17.85 $14.7 $14.7 $13.1 27.1  (-1%) 5
WIFI Boingo Wireless Inc. 1.4% $24.21 $22.1 $22.1 $22.8 3.2  (1%) 1
CAMP CalAmp Corp. 1.2% $22.40 $21.6 $21.6 $21.7 6.2  (7%) 2
CBB Cincinnati Bell Inc. 1.0% $12.95 $13.8 $13.8 $14.7 9.9  (-1%) 0
ORBC ORBCOMM Inc. 0.9% $10.14 $9.7 $9.7 $9.4 9.5  (4%) 3
ATNI ATN International Inc. 0.8% $53.02 $53.6 $53.6 $56.6 7.5  (57%) 2
SHEN Shenandoah Telecommunications Company 0.8% $33.40 $31.9 $31.9 $34.3 5.8  (6%) 2
USM United States Cellular Corporation 0.7% $36.75 $36.4 $36.4 $38.1 2.2  (31%) 0
CMTL Comtech Telecommunications Corp. 0.6% $32.50 $31.6 $31.6 $31.1 2.7  (-10%) 3
GSAT Globalstar Inc. 0.5% $0.52 $0.6 $0.6 $0.6 23.2  (-1%) -1