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

XLK Conmponent Weighting

Ticker
Symbol
Company Name ETF Weight Close Price 10-Day 20-Day 50-Day Short Int Ratio Technical Score
AAPL Apple Inc. 14.7% $190.80 $189.7 $189.7 $181.3 1.3  (-9%) 2
MSFT Microsoft Corporation 11.8% $101.42 $99.7 $99.7 $96.6 2.0  (-3%) 4
FB Facebook Inc. Class A 6.9% $196.81 $189.0 $189.0 $178.2 1.4  (4%) 3
GOOG Alphabet Inc. Class C 5.1% $1,152.12 $1,103.9 $1,103.9 $1,070.3 2.0  (21%) 2
GOOGL Alphabet Inc. Class A 5.0% $1,160.11 $1,112.9 $1,112.9 $1,076.5 1.8  (16%) 2
INTC Intel Corporation 4.0% $55.54 $55.3 $55.3 $53.6 3.6  (6%) 3
V Visa Inc. Class A 3.7% $135.00 $132.4 $132.4 $128.1 4.9  (2%) 4
CSCO Cisco Systems Inc. 3.5% $44.69 $43.6 $43.6 $43.9 2.7  (11%) 1
VZ Verizon Communications Inc. 3.2% $47.82 $48.3 $48.3 $48.3 1.8  (-17%) 0
T AT&T Inc. 3.2% $32.52 $32.8 $32.8 $33.4 6.1  (1%) 0
MA Mastercard Incorporated Class A 2.8% $199.31 $195.2 $195.2 $186.6 2.0  (22%) 4
ORCL Oracle Corporation 2.3% $45.90 $47.2 $47.2 $46.5 2.9  (-8%) -1
NVDA NVIDIA Corporation 2.2% $266.91 $255.5 $255.5 $242.4 0.9  (-7%) 4
IBM International Business Machines Corporation 2.0% $145.20 $144.3 $144.3 $146.8 3.4  (13%) -1
ADBE Adobe Systems Incorporated 1.8% $258.10 $247.6 $247.6 $235.6 2.8  (22%) 4
TXN Texas Instruments Incorporated 1.7% $114.72 $113.4 $113.4 $107.8 2.8  (13%) 4
AVGO Broadcom Inc. 1.5% $268.46 $252.6 $252.6 $243.5 2.0  (12%) 2
ACN Accenture Plc Class A 1.5% $162.76 $158.5 $158.5 $154.8 5.4  (11%) 3
CRM salesforce.com inc. 1.4% $138.41 $131.0 $131.0 $126.2 4.4  (-7%) 3
PYPL PayPal Holdings Inc 1.3% $85.61 $82.8 $82.8 $79.0 1.6  (8%) 3
QCOM QUALCOMM Incorporated 1.2% $59.46 $58.9 $58.9 $55.6 1.9  (10%) 2
ADP Automatic Data Processing Inc. 0.9% $139.82 $132.8 $132.8 $125.2 1.5  (-8%) 4
AMAT Applied Materials Inc. 0.9% $49.69 $51.2 $51.2 $52.4 1.3  (-11%) -2
MU Micron Technology Inc. 0.9% $59.18 $59.4 $59.4 $53.8 2.0  (13%) 3
ATVI Activision Blizzard Inc. 0.9% $77.71 $73.0 $73.0 $69.9 1.1  (-13%) 2
CTSH Cognizant Technology Solutions Corporation Class A 0.8% $78.55 $76.5 $76.5 $78.5 1.6  (-14%) 1
INTU Intuit Inc. 0.7% $209.08 $201.3 $201.3 $189.7 2.6  (-7%) 4
EA Electronic Arts Inc. 0.6% $144.39 $135.2 $135.2 $127.8 1.6  (34%) 3
HPQ HP Inc. 0.6% $23.80 $22.7 $22.7 $22.1 3.5  (-3%) 3
EBAY eBay Inc. 0.6% $39.00 $38.9 $38.9 $39.1 3.7  (-9%) -1
ADI Analog Devices Inc. 0.5% $101.70 $98.1 $98.1 $93.7 5.1  (-2%) 5
FIS Fidelity National Information Services Inc. 0.5% $107.72 $104.7 $104.7 $101.1 2.3  (43%) 3
TEL TE Connectivity Ltd. 0.5% $99.31 $95.6 $95.6 $95.9 2.8  (15%) 1
LRCX Lam Research Corporation 0.5% $181.17 $196.7 $196.7 $196.7 5.6  (17%) -1
DXC DXC Technology Co. 0.5% $84.45 $90.7 $90.7 $97.9 3.8  (-1%) -2
RHT Red Hat Inc. 0.5% $175.90 $167.4 $167.4 $163.9 3.4  (-7%) 3
FISV Fiserv Inc. 0.5% $76.43 $73.7 $73.7 $72.2 2.7  (10%) 3
ADSK Autodesk Inc. 0.5% $138.41 $135.5 $135.5 $132.3 4.3  (13%) 2
HPE Hewlett Packard Enterprise Co. 0.4% $15.82 $16.1 $16.1 $16.8 2.6  (-0%) -1
APH Amphenol Corporation Class A 0.4% $91.20 $89.0 $89.0 $86.8 3.6  (5%) 3
GLW Corning Inc 0.4% $28.89 $28.0 $28.0 $27.6 3.7  (29%) 3
WDC Western Digital Corporation 0.4% $82.55 $85.1 $85.1 $84.9 1.9  (41%) -1
MCHP Microchip Technology Incorporated 0.3% $102.57 $98.6 $98.6 $92.2 11.9  (-3%) 5
PAYX Paychex Inc. 0.3% $69.34 $66.7 $66.7 $63.7 4.9  (5%) 3
NTAP NetApp Inc. 0.3% $77.50 $71.1 $71.1 $69.2 4.1  (1%) 4
CTL CenturyLink Inc. 0.3% $18.01 $18.2 $18.2 $18.2 7.8  (-9%) 2
GPN Global Payments Inc. 0.3% $117.75 $114.5 $114.5 $113.0 4.2  (19%) 3
MSI Motorola Solutions Inc. 0.3% $113.90 $110.6 $110.6 $109.1 3.5  (3%) 4
SYMC Symantec Corporation 0.3% $21.36 $21.3 $21.3 $24.6 1.2  (-13%) -1
SWKS Skyworks Solutions Inc. 0.3% $101.97 $100.1 $100.1 $97.0 2.3  (-10%) 1
XLNX Xilinx Inc. 0.3% $70.43 $70.0 $70.0 $68.5 2.4  (4%) 1
KLAC KLA-Tencor Corporation 0.3% $113.13 $114.0 $114.0 $109.4 4.2  (-1%) 2
STX Seagate Technology PLC 0.3% $59.08 $57.6 $57.6 $57.9 4.2  (3%) 1
TSS Total System Services Inc. 0.2% $87.14 $86.6 $86.6 $86.2 2.4  (12%) 1
CTXS Citrix Systems Inc. 0.2% $106.82 $106.7 $106.7 $102.8 2.7  (-14%) 3
ANSS ANSYS Inc. 0.2% $176.92 $167.7 $167.7 $164.6 3.5  (-0%) 4
SNPS Synopsys Inc. 0.2% $90.87 $89.6 $89.6 $87.3 2.1  (1%) 2
AKAM Akamai Technologies Inc. 0.2% $80.86 $77.6 $77.6 $74.6 2.3  (0%) 4
TTWO Take-Two Interactive Software Inc. 0.2% $121.84 $113.9 $113.9 $107.6 1.6  (45%) 2
CDNS Cadence Design Systems Inc. 0.2% $44.94 $43.1 $43.1 $40.7 2.3  (-4%) 4
IT Gartner Inc. 0.2% $137.29 $134.4 $134.4 $127.2 5.7  (-0%) 4
CA CA Inc. 0.2% $37.06 $35.9 $35.9 $35.1 4.4  (6%) 4
FFIV F5 Networks Inc. 0.2% $181.64 $175.6 $175.6 $165.9 4.7  (6%) 4
VRSN VeriSign Inc. 0.2% $141.22 $133.0 $133.0 $126.3 2.1  (-86%) 4
ADS Alliance Data Systems Corporation 0.2% $226.47 $216.1 $216.1 $210.0 2.5  (-9%) 1
QRVO Qorvo Inc. 0.2% $83.65 $80.9 $80.9 $76.7 4.0  (-11%) 3
AMD Advanced Micro Devices Inc. 0.1% $16.25 $14.3 $14.3 $12.2 4.0  (-3%) 4
WU Western Union Company 0.1% $20.66 $20.4 $20.4 $19.8 7.6  (-5%) 4
IPGP IPG Photonics Corporation 0.1% $241.16 $247.3 $247.3 $237.8 3.4  (12%) 0
JNPR Juniper Networks Inc. 0.1% $27.82 $27.3 $27.3 $26.0 2.3  (-4%) 3
FLIR FLIR Systems Inc. 0.1% $54.30 $54.5 $54.5 $53.6 2.6  (-6%) 2
XRX Xerox Corporation 0.1% $27.74 $27.8 $27.8 $28.7 1.1  (18%) -1