NEWSheetSteps AI now turns entire websites into clean spreadsheet columnsExplore web scraping  →
← All data sets
COMPANY RESEARCH · FREE SPREADSHEET

S&P 500 Companies and SPY Holdings

Current constituent holdings of the State Street SPDR S&P 500 ETF Trust, including ticker, identifier, portfolio weight, and source workbook.

504verified rowsJuly 28, 2026last checkedMonthlyrefresh schedule
#OrderCompanyTickerIdentifierPortfolio weightCurrencyOfficial holdings workbookHoldings dateChecked
011APPLE INCAAPL0378331007.760026USDOpen source ↗2026-07-272026-07-28
022NVIDIA CORPNVDA67066G1047.464046USDOpen source ↗2026-07-272026-07-28
033MICROSOFT CORPMSFT5949181044.532705USDOpen source ↗2026-07-272026-07-28
044AMAZON.COM INCAMZN0231351063.552029USDOpen source ↗2026-07-272026-07-28
055ALPHABET INC CL AGOOGL02079K3053.002782USDOpen source ↗2026-07-272026-07-28
066BROADCOM INCAVGO11135F1012.845695USDOpen source ↗2026-07-272026-07-28
077ALPHABET INC CL CGOOG02079K1072.420427USDOpen source ↗2026-07-272026-07-28
088META PLATFORMS INC CLASS AMETA30303M1022.045081USDOpen source ↗2026-07-272026-07-28
099MICRON TECHNOLOGY INCMU5951121031.592229USDOpen source ↗2026-07-272026-07-28
1010JPMORGAN CHASE + COJPM46625H1001.497046USDOpen source ↗2026-07-272026-07-28
1111ELI LILLY + COLLY5324571081.485834USDOpen source ↗2026-07-272026-07-28
1212BERKSHIRE HATHAWAY INC CL BBRK.B0846707021.429655USDOpen source ↗2026-07-272026-07-28
1313TESLA INCTSLA88160R1011.365409USDOpen source ↗2026-07-272026-07-28
1414ADVANCED MICRO DEVICESAMD0079031071.265885USDOpen source ↗2026-07-272026-07-28
1515EXXONMOBIL HOLDINGS CORPXOM30233Q1081.005852USDOpen source ↗2026-07-272026-07-28
1616JOHNSON + JOHNSONJNJ4781601041.004208USDOpen source ↗2026-07-272026-07-28
1717VISA INC CLASS A SHARESV92826C8390.943414USDOpen source ↗2026-07-272026-07-28
1818WALMART INCWMT9311421030.768049USDOpen source ↗2026-07-272026-07-28
1919ABBVIE INCABBV00287Y1090.712048USDOpen source ↗2026-07-272026-07-28
2020CISCO SYSTEMS INCCSCO17275R1020.709463USDOpen source ↗2026-07-272026-07-28
2121MASTERCARD INC AMA57636Q1040.697931USDOpen source ↗2026-07-272026-07-28
2222INTEL CORPINTC4581401000.679357USDOpen source ↗2026-07-272026-07-28
2323COSTCO WHOLESALE CORPCOST22160K1050.661824USDOpen source ↗2026-07-272026-07-28
2424APPLIED MATERIALS INCAMAT0382221050.643490USDOpen source ↗2026-07-272026-07-28
2525BANK OF AMERICA CORPBAC0605051040.635885USDOpen source ↗2026-07-272026-07-28
2626CATERPILLAR INCCAT1491231010.630993USDOpen source ↗2026-07-272026-07-28
2727UNITEDHEALTH GROUP INCUNH91324P1020.594552USDOpen source ↗2026-07-272026-07-28
2828GENERAL ELECTRICGE3696043010.591447USDOpen source ↗2026-07-272026-07-28
2929LAM RESEARCH CORPLRCX5128073060.572079USDOpen source ↗2026-07-272026-07-28
3030CHEVRON CORPCVX1667641000.557577USDOpen source ↗2026-07-272026-07-28
3131PROCTER + GAMBLE CO/THEPG7427181090.542538USDOpen source ↗2026-07-272026-07-28
3232HOME DEPOT INCHD4370761020.524744USDOpen source ↗2026-07-272026-07-28
3333COCA COLA CO/THEKO1912161000.510286USDOpen source ↗2026-07-272026-07-28
3434MERCK + CO. INC.MRK58933Y1050.506425USDOpen source ↗2026-07-272026-07-28
3535GOLDMAN SACHS GROUP INCGS38141G1040.484743USDOpen source ↗2026-07-272026-07-28
3636PHILIP MORRIS INTERNATIONALPM7181721090.478189USDOpen source ↗2026-07-272026-07-28
3737PALANTIR TECHNOLOGIES INC APLTR69608A1080.473382USDOpen source ↗2026-07-272026-07-28
3838NETFLIX INCNFLX64110L1060.464685USDOpen source ↗2026-07-272026-07-28
3939RTX CORPRTX75513E1010.461248USDOpen source ↗2026-07-272026-07-28
4040GE VERNOVA INCGEV36828A1010.419791USDOpen source ↗2026-07-272026-07-28
4141WELLS FARGO + COWFC9497461010.418781USDOpen source ↗2026-07-272026-07-28
4242KLA CORPKLAC4824801000.416754USDOpen source ↗2026-07-272026-07-28
4343PALO ALTO NETWORKS INCPANW6974351050.403544USDOpen source ↗2026-07-272026-07-28
4444MORGAN STANLEYMS6174464480.403323USDOpen source ↗2026-07-272026-07-28
4545TEXAS INSTRUMENTS INCTXN8825081040.398851USDOpen source ↗2026-07-272026-07-28
4646LINDE PLCLING549501030.367594USDOpen source ↗2026-07-272026-07-28
4747CITIGROUP INCC1729674240.355977USDOpen source ↗2026-07-272026-07-28
4848THERMO FISHER SCIENTIFIC INCTMO8835561020.326140USDOpen source ↗2026-07-272026-07-28
4949ORACLE CORPORCL68389X1050.318916USDOpen source ↗2026-07-272026-07-28
5050INTL BUSINESS MACHINES CORPIBM4592001010.318769USDOpen source ↗2026-07-272026-07-28
5151AMGEN INCAMGN0311621000.318231USDOpen source ↗2026-07-272026-07-28
5252VERIZON COMMUNICATIONS INCVZ92343V1040.309937USDOpen source ↗2026-07-272026-07-28
5353MCDONALD S CORPMCD5801351010.301672USDOpen source ↗2026-07-272026-07-28
5454PEPSICO INCPEP7134481080.299698USDOpen source ↗2026-07-272026-07-28
5555SANDISK CORPSNDK80004C2000.296741USDOpen source ↗2026-07-272026-07-28
5656NEXTERA ENERGY INCNEE65339F1010.290570USDOpen source ↗2026-07-272026-07-28
5757AMPHENOL CORP CL AAPH0320951010.288075USDOpen source ↗2026-07-272026-07-28
5858CROWDSTRIKE HOLDINGS INC ACRWD22788C1050.287679USDOpen source ↗2026-07-272026-07-28
5959SEAGATE TECHNOLOGY HOLDINGSSTXG7997R1030.287265USDOpen source ↗2026-07-272026-07-28
6060ABBOTT LABORATORIESABT0028241000.285484USDOpen source ↗2026-07-272026-07-28
6161ANALOG DEVICES INCADI0326541050.284798USDOpen source ↗2026-07-272026-07-28
6262QUALCOMM INCQCOM7475251030.281134USDOpen source ↗2026-07-272026-07-28
6363AMERICAN EXPRESS COAXP0258161090.279978USDOpen source ↗2026-07-272026-07-28
6464UNION PACIFIC CORPUNP9078181080.278738USDOpen source ↗2026-07-272026-07-28
6565ARISTA NETWORKS INCANET0404132050.276565USDOpen source ↗2026-07-272026-07-28
6666WELLTOWER INCWELL95040Q1040.274986USDOpen source ↗2026-07-272026-07-28
6767TJX COMPANIES INCTJX8725401090.271258USDOpen source ↗2026-07-272026-07-28
6868WESTERN DIGITAL CORPWDC9581021050.269127USDOpen source ↗2026-07-272026-07-28
6969SCHWAB (CHARLES) CORPSCHW8085131050.267148USDOpen source ↗2026-07-272026-07-28
7070AT+T INCT00206R1020.266160USDOpen source ↗2026-07-272026-07-28
7171WALT DISNEY CO/THEDIS2546871060.263261USDOpen source ↗2026-07-272026-07-28
7272BOEING CO/THEBA0970231050.261533USDOpen source ↗2026-07-272026-07-28
7373MARVELL TECHNOLOGY INCMRVL5738741040.259722USDOpen source ↗2026-07-272026-07-28
7474GILEAD SCIENCES INCGILD3755581030.254195USDOpen source ↗2026-07-272026-07-28
7575DEERE + CODE2441991050.246314USDOpen source ↗2026-07-272026-07-28
7676EATON CORP PLCETNG291831030.242806USDOpen source ↗2026-07-272026-07-28
7777BLACKROCK INCBLK09290D1010.240574USDOpen source ↗2026-07-272026-07-28
7878BOOKING HOLDINGS INCBKNG09857L1080.227038USDOpen source ↗2026-07-272026-07-28
7979SALESFORCE INCCRM79466L3020.222762USDOpen source ↗2026-07-272026-07-28
8080CONOCOPHILLIPSCOP20825C1040.220876USDOpen source ↗2026-07-272026-07-28
8181PFIZER INCPFE7170811030.220496USDOpen source ↗2026-07-272026-07-28
8282UBER TECHNOLOGIES INCUBER90353T1000.217704USDOpen source ↗2026-07-272026-07-28
8383PROLOGIS INCPLD74340W1030.215255USDOpen source ↗2026-07-272026-07-28
8484CVS HEALTH CORPCVS1266501000.214291USDOpen source ↗2026-07-272026-07-28
8585S+P GLOBAL INCSPGI78409V1040.209201USDOpen source ↗2026-07-272026-07-28
8686CHUBB LTDCBH1467J1040.203073USDOpen source ↗2026-07-272026-07-28
8787CAPITAL ONE FINANCIAL CORPCOF14040H1050.202118USDOpen source ↗2026-07-272026-07-28
8888BRISTOL MYERS SQUIBB COBMY1101221080.200389USDOpen source ↗2026-07-272026-07-28
8989INTUITIVE SURGICAL INCISRG46120E6020.198223USDOpen source ↗2026-07-272026-07-28
9090PROGRESSIVE CORPPGR7433151030.197774USDOpen source ↗2026-07-272026-07-28
9191PARKER HANNIFIN CORPPH7010941040.195260USDOpen source ↗2026-07-272026-07-28
9292DANAHER CORPDHR2358511020.194160USDOpen source ↗2026-07-272026-07-28
9393DELL TECHNOLOGIES CDELL24703L2020.193736USDOpen source ↗2026-07-272026-07-28
9494ALTRIA GROUP INCMO02209S1030.190931USDOpen source ↗2026-07-272026-07-28
9595VERTEX PHARMACEUTICALS INCVRTX92532F1000.190695USDOpen source ↗2026-07-272026-07-28
9696LOWE S COS INCLOW5486611070.185863USDOpen source ↗2026-07-272026-07-28
9797STARBUCKS CORPSBUX8552441090.185300USDOpen source ↗2026-07-272026-07-28
9898LOCKHEED MARTIN CORPLMT5398301090.184331USDOpen source ↗2026-07-272026-07-28
9999STRYKER CORPSYK8636671010.182249USDOpen source ↗2026-07-272026-07-28
100100HOWMET AEROSPACE INCHWM4432011080.180718USDOpen source ↗2026-07-272026-07-28
SOURCE STANDARD

What counts as verified?

Official State Street SPDR S&P 500 ETF daily holdings workbook. Third-party list posts can help discover candidates, but they do not qualify as the final source for a retained row.

USE IT IN GOOGLE SHEETS

Paste without cleanup

Choose Copy to spreadsheet, select cell A1 in Google Sheets, and paste. Column headers and filtered rows are included automatically.