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% $208.88 $197.1 $197.1 $191.8 1.8  (-13%) 3
MSFT Microsoft Corporation 11.8% $109.67 $107.2 $107.2 $103.2 1.4  (-2%) 4
FB Facebook Inc. Class A 6.9% $183.09 $194.4 $194.4 $195.4 0.7  (15%) -1
GOOG Alphabet Inc. Class C 5.1% $1,249.10 $1,219.9 $1,219.9 $1,167.9 1.5  (10%) 3
GOOGL Alphabet Inc. Class A 5.0% $1,264.46 $1,233.5 $1,233.5 $1,180.9 1.2  (18%) 3
INTC Intel Corporation 4.0% $50.14 $50.8 $50.8 $52.2 3.3  (-0%) -2
V Visa Inc. Class A 3.7% $140.01 $140.0 $140.0 $136.3 3.9  (10%) 3
CSCO Cisco Systems Inc. 3.5% $43.78 $42.7 $42.7 $43.1 2.0  (-5%) -1
VZ Verizon Communications Inc. 3.2% $53.01 $51.7 $51.7 $50.2 2.6  (-3%) 4
T AT&T Inc. 3.2% $32.49 $31.7 $31.7 $32.2 1.8  (5%) -0
MA Mastercard Incorporated Class A 2.8% $203.60 $205.0 $205.0 $201.1 1.8  (2%) 3
ORCL Oracle Corporation 2.3% $48.54 $48.5 $48.5 $47.0 2.5  (10%) 2
NVDA NVIDIA Corporation 2.2% $256.46 $251.7 $251.7 $252.9 1.5  (-4%) 2
IBM International Business Machines Corporation 2.0% $144.77 $145.8 $145.8 $144.0 3.1  (12%) 1
ADBE Adobe Systems Incorporated 1.8% $253.80 $255.5 $255.5 $251.3 1.4  (-8%) 2
TXN Texas Instruments Incorporated 1.7% $114.34 $114.0 $114.0 $113.5 3.3  (21%) 2
AVGO Broadcom Inc. 1.5% $216.58 $215.4 $215.4 $239.1 1.3  (69%) -2
ACN Accenture Plc Class A 1.5% $160.64 $164.0 $164.0 $162.6 3.6  (-6%) 0
CRM salesforce.com inc. 1.4% $145.82 $145.1 $145.1 $139.9 2.4  (-25%) 2
PYPL PayPal Holdings Inc 1.3% $87.17 $87.3 $87.3 $85.5 1.6  (19%) 3
QCOM QUALCOMM Incorporated 1.2% $65.08 $61.6 $61.6 $59.6 1.3  (7%) 4
ADP Automatic Data Processing Inc. 0.9% $138.37 $136.8 $136.8 $136.1 2.0  (-10%) 3
AMAT Applied Materials Inc. 0.9% $49.16 $47.6 $47.6 $48.2 1.4  (-4%) 1
MU Micron Technology Inc. 0.9% $52.26 $54.3 $54.3 $55.9 1.5  (-4%) -0
ATVI Activision Blizzard Inc. 0.9% $70.50 $76.4 $76.4 $75.9 1.7  (-10%) -2
CTSH Cognizant Technology Solutions Corporation Class A 0.8% $76.26 $80.8 $80.8 $79.5 3.9  (-17%) -2
INTU Intuit Inc. 0.7% $211.19 $212.2 $212.2 $208.7 2.4  (-7%) 3
EA Electronic Arts Inc. 0.6% $127.82 $138.8 $138.8 $139.9 1.1  (10%) -1
HPQ HP Inc. 0.6% $24.08 $23.4 $23.4 $23.3 3.5  (-21%) 4
EBAY eBay Inc. 0.6% $34.15 $34.8 $34.8 $36.9 1.4  (-6%) -1
ADI Analog Devices Inc. 0.5% $97.74 $97.5 $97.5 $98.3 3.8  (-2%) 0
FIS Fidelity National Information Services Inc. 0.5% $106.95 $107.1 $107.1 $106.6 2.5  (-10%) 1
TEL TE Connectivity Ltd. 0.5% $93.65 $93.0 $93.0 $93.9 1.7  (-14%) -2
LRCX Lam Research Corporation 0.5% $184.49 $180.8 $180.8 $181.1 4.3  (-1%) 1
DXC DXC Technology Co. 0.5% $87.25 $86.7 $86.7 $84.8 3.2  (-26%) 2
RHT Red Hat Inc. 0.5% $144.72 $145.5 $145.5 $152.0 4.1  (3%) -2
FISV Fiserv Inc. 0.5% $78.64 $76.9 $76.9 $75.8 2.7  (-18%) 3
ADSK Autodesk Inc. 0.5% $135.11 $134.0 $134.0 $134.4 4.4  (3%) 1
HPE Hewlett Packard Enterprise Co. 0.4% $16.11 $15.7 $15.7 $15.5 3.3  (-13%) 1
APH Amphenol Corporation Class A 0.4% $94.32 $91.6 $91.6 $90.0 2.7  (-24%) 4
GLW Corning Inc 0.4% $33.09 $31.3 $31.3 $29.4 3.9  (11%) 4
WDC Western Digital Corporation 0.4% $66.11 $73.4 $73.4 $77.9 1.9  (0%) -2
MCHP Microchip Technology Incorporated 0.3% $98.08 $94.9 $94.9 $96.4 18.8  (3%) 4
PAYX Paychex Inc. 0.3% $71.25 $70.5 $70.5 $69.3 4.2  (-6%) 3
NTAP NetApp Inc. 0.3% $82.59 $81.3 $81.3 $78.2 4.5  (-9%) 4
CTL CenturyLink Inc. 0.3% $20.97 $19.0 $19.0 $18.7 12.0  (-6%) 4
GPN Global Payments Inc. 0.3% $116.61 $116.9 $116.9 $115.4 5.5  (-7%) 3
MSI Motorola Solutions Inc. 0.3% $121.45 $121.5 $121.5 $117.5 5.3  (9%) 4
SYMC Symantec Corporation 0.3% $19.23 $20.6 $20.6 $20.9 2.0  (-6%) -1
SWKS Skyworks Solutions Inc. 0.3% $94.33 $97.0 $97.0 $98.5 2.8  (-3%) -1
XLNX Xilinx Inc. 0.3% $73.43 $70.6 $70.6 $69.1 1.9  (5%) 3
KLAC KLA-Tencor Corporation 0.3% $116.77 $110.3 $110.3 $109.8 3.3  (-4%) 4
STX Seagate Technology PLC 0.3% $51.02 $55.8 $55.8 $56.9 6.6  (3%) 0
TSS Total System Services Inc. 0.2% $93.49 $91.8 $91.8 $88.6 3.3  (23%) 4
CTXS Citrix Systems Inc. 0.2% $111.18 $110.2 $110.2 $108.0 5.8  (-7%) 5
ANSS ANSYS Inc. 0.2% $172.01 $176.0 $176.0 $175.0 2.8  (-14%) 1
SNPS Synopsys Inc. 0.2% $93.42 $91.8 $91.8 $89.9 2.2  (17%) 3
AKAM Akamai Technologies Inc. 0.2% $76.84 $77.3 $77.3 $77.5 5.1  (12%) 1
TTWO Take-Two Interactive Software Inc. 0.2% $125.20 $123.5 $123.5 $119.7 1.3  (-25%) 2
CDNS Cadence Design Systems Inc. 0.2% $45.33 $45.2 $45.2 $44.5 3.1  (-6%) 2
IT Gartner Inc. 0.2% $139.66 $138.3 $138.3 $136.9 15.7  (-2%) 3
CA CA Inc. 0.2% $43.36 $44.0 $44.0 $39.4 1.9  (5%) 4
FFIV F5 Networks Inc. 0.2% $179.91 $174.9 $174.9 $175.8 5.6  (6%) 1
VRSN VeriSign Inc. 0.2% $153.35 $149.7 $149.7 $143.1 3.7  (-12%) 4
ADS Alliance Data Systems Corporation 0.2% $230.61 $230.2 $230.2 $229.7 2.6  (-7%) 2
QRVO Qorvo Inc. 0.2% $85.51 $82.9 $82.9 $82.0 6.4  (-5%) 4
AMD Advanced Micro Devices Inc. 0.1% $19.10 $17.8 $17.8 $16.4 1.9  (4%) 4
WU Western Union Company 0.1% $18.92 $20.0 $20.0 $20.4 11.4  (-5%) 1
IPGP IPG Photonics Corporation 0.1% $164.64 $212.6 $212.6 $226.5 2.5  (-10%) -2
JNPR Juniper Networks Inc. 0.1% $26.94 $27.3 $27.3 $27.3 3.9  (-2%) 0
FLIR FLIR Systems Inc. 0.1% $59.60 $56.3 $56.3 $54.7 2.1  (-21%) 4
XRX Xerox Corporation 0.1% $26.35 $25.5 $25.5 $26.0 2.3  (3%) 2