S&P 500 Companies

A full list of Standard & Poor's index constituents current as of Mar 16, 2023.

@kaggle.alexanderxela_sp_500_companies

Table List

1 table(23.76 KB)

Sp500 Constituents

@kaggle.alexanderxela_sp_500_companies.sp500_constituents

23.76 KB
503 rows
6 columns

ticker Ticker	name Name	industry Industry	sub_industry Sub-Industry	headquarters_location Headquarters Location	date_added Date Added
A	Agilent Technologies	Health Care	Health Care Equipment	Santa Clara, California	6/5/2000
AAL	American Airlines Group	Industrials	Airlines	Fort Worth, Texas	3/23/2015
AAP	Advance Auto Parts	Consumer Discretionary	Automotive Retail	Raleigh, North Carolina	7/9/2015
AAPL	Apple Inc.	Information Technology	Technology Hardware, Storage & Peripherals	Cupertino, California	11/30/1982
ABBV	AbbVie	Health Care	Pharmaceuticals	North Chicago, Illinois	12/31/2012
ABC	AmerisourceBergen	Health Care	Health Care Distributors	Conshohocken, Pennsylvania	8/30/2001
ABT	Abbott	Health Care	Health Care Equipment	North Chicago, Illinois	3/31/1964
ACGL	Arch Capital Group	Financials	Reinsurance	Hamilton, Bermuda	11/1/2022
ACN	Accenture	Information Technology	IT Consulting & Other Services	Dublin, Ireland	7/6/2011
ADBE	Adobe Inc.	Information Technology	Application Software	San Jose, California	5/5/1997


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