S&P 500 Companies

One row per current S&P 500 company: ticker, name, GICS sector and sub-industry, headquarters, date added to the index, SEC CIK, and year founded.

S&P 500 Companies is a free dataset by Aethereal with 503 rows and 8 columns, updated daily at 01:15 UTC and available as CSV and Parquet at https://dataset.aethereal.top/datasets/sp500-companies.

Load it in Python

import pandas as pd

df = pd.read_csv("https://dataset.aethereal.top/files/sp500-companies.csv")
# or, faster for large files (needs pyarrow):
# df = pd.read_parquet("https://dataset.aethereal.top/files/sp500-companies.parquet")

print(df.head())

Questions about this dataset

What is in the S&P 500 Companies dataset?

One row per current S&P 500 company: ticker, name, GICS sector and sub-industry, headquarters, date added to the index, SEC CIK, and year founded. It has 8 columns: ticker, name, sector, industry, headquarters, date_added, cik, founded.

How often is S&P 500 Companies updated?

Daily at 01:15 UTC. It currently has 503 rows and was last updated on 2026-10-21.

How do I download S&P 500 Companies?

Download it for free, without an account, as CSV from https://dataset.aethereal.top/files/sp500-companies.csv or as Parquet from https://dataset.aethereal.top/files/sp500-companies.parquet. AI assistants can also query it through the MCP server at https://dataset.aethereal.top/mcp.

Can I use S&P 500 Companies in my project?

License: CC0 1.0. Public domain.

How to cite

Aethereal (2026). S&P 500 Companies [Data set]. Aethereal Data. https://dataset.aethereal.top/datasets/sp500-companies. Accessed 2026-10-21.

Columns

NameTypeDescription
tickerstringTicker.
namestringCompany.
sectorstringGICS sector.
industrystringGICS sub-industry.
headquartersstringHeadquarters location.
date_addeddateDate added to the index.
cikstringSEC Central Index Key.
foundedstringYear founded.

More Stocks datasets

IDX Stock Features

120 IDX stocks with returns, volatility, moving averages, RSI, drawdown, beta to IHSG, liquidity, and USD prices.

IDX Stock Prices

Daily OHLCV for 120 of the most traded stocks on the Indonesia Stock Exchange.

S&P 500 Stock Prices

Daily OHLCV for every current S&P 500 company since 2015.

Preview latest 20 rows

tickernamesectorindustryheadquartersdate_addedcikfounded
MMM3MIndustrialsIndustrial ConglomeratesSaint Paul, Minnesota1957-03-04667401902
AOSA. O. SmithIndustrialsBuilding ProductsMilwaukee, Wisconsin2017-07-26911421916
ABTAbbott LaboratoriesHealth CareHealth Care EquipmentNorth Chicago, Illinois1957-03-0418001888
ABBVAbbVieHealth CareBiotechnologyNorth Chicago, Illinois2012-12-3115511522013 (1888)
ACNAccentureInformation TechnologyIT Consulting & Other ServicesDublin, Ireland2011-07-0614673731989
ADBEAdobe Inc.Information TechnologyApplication SoftwareSan Jose, California1997-05-057963431982
AMDAdvanced Micro DevicesInformation TechnologySemiconductorsSanta Clara, California2017-03-2024881969
AESAES CorporationUtilitiesIndependent Power Producers & Energy TradersArlington, Virginia1998-10-028747611981
AFLAflacFinancialsLife & Health InsuranceColumbus, Georgia1999-05-2849771955
AAgilent TechnologiesHealth CareLife Sciences Tools & ServicesSanta Clara, California2000-06-0510908721999
APDAir ProductsMaterialsIndustrial GasesUpper Macungie Township, Pennsylvania1985-04-3029691940
ABNBAirbnbConsumer DiscretionaryHotels, Resorts & Cruise LinesSan Francisco, California2023-09-1815597202008
AKAMAkamai TechnologiesInformation TechnologyInternet Services & InfrastructureCambridge, Massachusetts2007-07-1210862221998
ALBAlbemarle CorporationMaterialsSpecialty ChemicalsCharlotte, North Carolina2016-07-019159131994
AREAlexandria Real Estate EquitiesReal EstateOffice REITsPasadena, California2017-03-2010354431994
ALGNAlign TechnologyHealth CareHealth Care SuppliesTempe, Arizona2017-06-1910971491997
ALLEAllegionIndustrialsBuilding ProductsDublin, Ireland2013-12-0215792411908
LNTAlliant EnergyUtilitiesElectric UtilitiesMadison, Wisconsin2016-07-013525411917
ALLAllstateFinancialsProperty & Casualty InsuranceNorthbrook, Illinois1995-07-138990511931
GOOGLAlphabet Inc. (Class A)Communication ServicesInteractive Media & ServicesMountain View, California2006-04-0316520441998