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% $5.24 $5.0 $5.0 $6.0 7.9  (1%) -0
FFIV F5 Networks Inc. 3.1% $179.91 $174.9 $174.9 $175.8 5.6  (6%) 1
AAOI Applied Optoelectronics Inc. 2.9% $40.10 $41.3 $41.3 $43.0 8.7  (-4%) 1
CCOI Cogent Communications Holdings Inc 2.9% $50.00 $52.1 $52.1 $52.9 11.1  (-6%) -1
VG Vonage Holdings Corp. 2.9% $13.70 $13.4 $13.4 $12.7 3.6  (-20%) 3
PANW Palo Alto Networks Inc. 2.9% $213.10 $211.5 $211.5 $209.3 4.0  (5%) 1
UBNT Ubiquiti Networks Inc. 2.8% $81.78 $85.7 $85.7 $85.5 24.4  (-3%) 2
OCLR Oclaro Inc. 2.8% $8.96 $8.9 $8.9 $8.9 5.9  (8%) 0
CTL CenturyLink Inc. 2.8% $20.97 $19.0 $19.0 $18.7 12.0  (-6%) 4
IDCC InterDigital Inc. 2.8% $81.80 $82.5 $82.5 $82.7 6.0  (-7%) 1
MSI Motorola Solutions Inc. 2.7% $121.45 $121.5 $121.5 $117.5 5.3  (9%) 4
NTCT NetScout Systems Inc. 2.7% $26.45 $28.9 $28.9 $29.1 10.6  (4%) 1
S Sprint Corp. 2.7% $6.08 $5.6 $5.6 $5.5 18.9  (-6%) 5
VZ Verizon Communications Inc. 2.7% $53.01 $51.7 $51.7 $50.2 2.6  (-3%) 4
CSCO Cisco Systems Inc. 2.6% $43.78 $42.7 $42.7 $43.1 2.0  (-5%) -1
CIEN Ciena Corporation 2.6% $26.00 $26.0 $26.0 $25.6 9.1  (-6%) 1
ARRS ARRIS International Plc 2.6% $24.73 $25.4 $25.4 $25.4 4.5  (-14%) -2
ZAYO Zayo Group Holdings Inc. 2.6% $37.75 $37.7 $37.7 $37.0 10.4  (-3%) 3
TDS Telephone and Data Systems Inc. 2.6% $30.46 $26.0 $26.0 $26.6 3.6  (15%) 1
JNPR Juniper Networks Inc. 2.6% $26.94 $27.3 $27.3 $27.3 3.9  (-2%) 0
NTGR NETGEAR Inc. 2.5% $67.05 $70.1 $70.1 $67.0 3.9  (0%) 2
VIAV Viavi Solutions Inc. 2.5% $10.49 $10.3 $10.3 $10.1 7.5  (-6%) 4
ANET Arista Networks Inc. 2.4% $269.34 $269.5 $269.5 $268.8 4.1  (-5%) 2
TMUS T-Mobile US Inc. 2.4% $64.97 $61.3 $61.3 $60.0 5.5  (-0%) 5
CNSL Consolidated Communications Holdings Inc. 2.4% $11.31 $12.1 $12.1 $12.4 21.0  (-4%) 0
T AT&T Inc. 2.4% $32.49 $31.7 $31.7 $32.2 1.8  (5%) -0
VSAT ViaSat Inc. 2.3% $71.77 $69.7 $69.7 $66.7 28.5  (0%) 5
EXTR Extreme Networks Inc. 2.3% $6.24 $8.4 $8.4 $8.5 4.0  (50%) -1
LITE Lumentum Holdings Inc. 2.3% $58.45 $56.0 $56.0 $57.2 5.3  (10%) 2
FNSR Finisar Corporation 2.3% $18.63 $17.6 $17.6 $17.7 8.8  (-19%) 3
INFN Infinera Corporation 2.1% $8.57 $8.8 $8.8 $9.2 4.2  (-1%) -2
PLT Plantronics Inc. 2.0% $67.40 $71.9 $71.9 $74.5 2.8  (65%) -1
COMM CommScope Holding Co. Inc. 1.9% $31.97 $30.7 $30.7 $30.1 7.6  (5%) 3
ACIA Acacia Communications Inc. 1.9% $38.54 $34.7 $34.7 $34.3 10.5  (-7%) 5
ADTN ADTRAN Inc. 1.7% $15.90 $16.2 $16.2 $15.4 2.7  (10%) 4
SATS EchoStar Corporation Class A 1.5% $48.74 $45.8 $45.8 $46.1 7.3  (-39%) 2
IRDM Iridium Communications Inc. 1.5% $20.35 $18.6 $18.6 $17.3 17.5  (0%) 5
WIFI Boingo Wireless Inc. 1.4% $30.24 $25.1 $25.1 $23.9 8.1  (-10%) 4
CAMP CalAmp Corp. 1.2% $23.24 $23.2 $23.2 $22.8 6.7  (32%) 3
CBB Cincinnati Bell Inc. 1.0% $12.10 $13.5 $13.5 $13.9 8.3  (-10%) 0
ORBC ORBCOMM Inc. 0.9% $10.67 $10.1 $10.1 $10.1 11.5  (10%) 3
ATNI ATN International Inc. 0.8% $69.12 $60.5 $60.5 $56.7 13.3  (13%) 4
SHEN Shenandoah Telecommunications Company 0.8% $37.05 $33.0 $33.0 $33.0 9.7  (-6%) 3
USM United States Cellular Corporation 0.7% $43.10 $35.7 $35.7 $36.4 3.2  (-5%) 1
CMTL Comtech Telecommunications Corp. 0.6% $34.55 $34.1 $34.1 $33.0 3.8  (-4%) 3
GSAT Globalstar Inc. 0.5% $0.53 $0.5 $0.5 $0.5 15.8  (-3%) 2