Name: S&P 500 Companies
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

S&P 500 Companies

This dataset features a full list of S&P 500 companies, including their tickers, names, industry and sub-industry categories, headquarters location and date the company was added to the index. The index constituents are updated regularly using rules published by S&P Dow Jones Indices. Although called the S&P 500, the index contains 503 stocks because it includes two share classes of stock from 3 of its component companies.

Updated 3/16/2023:

SBNY (Signature Bank) and SIVB (SVB Financial Group) were removed from S&P 500 on Mar 15, 2023
BG (Bunge Limited) and PODD (Insulet) were added to S&P 500 on Mar 15, 2023
New column "Founded" - shows what year the company was founded

Tables

Sp500 Constituents

@kaggle.alexanderxela_sp_500_companies.sp500_constituents

24.33 kB
503 rows
6 columns

CREATE TABLE sp500_constituents (
  "ticker" VARCHAR,
  "name" VARCHAR,
  "industry" VARCHAR,
  "sub_industry" VARCHAR,
  "headquarters_location" VARCHAR,
  "date_added" VARCHAR
);