New York Stock Exchange

S&P 500 companies historical prices with fundamental data

@kaggle.dgawlik_nyse

Table List

4 tables(26.49 MB)

Fundamentals

Prices Split Adjusted

Prices

Securities

Securities

@kaggle.dgawlik_nyse.securities

28.9 KB
505 rows
8 columns

ticker_symbol Ticker Symbol	security Security	sec_filings SEC Filings	gics_sector GICS Sector	gics_sub_industry GICS Sub Industry	address_of_headquarters Address Of Headquarters	date_first_added Date First Added	cik CIK
MMM	3M Company	reports	Industrials	Industrial Conglomerates	St. Paul, Minnesota		66740
ABT	Abbott Laboratories	reports	Health Care	Health Care Equipment	North Chicago, Illinois	Tue Mar 31 1964 00:00:00 GMT+0000 (Coordinated Universal Time)	1800
ABBV	AbbVie	reports	Health Care	Pharmaceuticals	North Chicago, Illinois	Mon Dec 31 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	1551152
ACN	Accenture plc	reports	Information Technology	IT Consulting & Other Services	Dublin, Ireland	Wed Jul 06 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	1467373
ATVI	Activision Blizzard	reports	Information Technology	Home Entertainment Software	Santa Monica, California	Mon Aug 31 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	718877
AYI	Acuity Brands Inc	reports	Industrials	Electrical Components & Equipment	Atlanta, Georgia	Tue May 03 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	1144215
ADBE	Adobe Systems Inc	reports	Information Technology	Application Software	San Jose, California	Mon May 05 1997 00:00:00 GMT+0000 (Coordinated Universal Time)	796343
AAP	Advance Auto Parts	reports	Consumer Discretionary	Automotive Retail	Roanoke, Virginia	Thu Jul 09 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	1158449
AES	AES Corp	reports	Utilities	Independent Power Producers & Energy Traders	Arlington, Virginia		874761
AET	Aetna Inc	reports	Health Care	Managed Health Care	Hartford, Connecticut	Wed Jun 30 1976 00:00:00 GMT+0000 (Coordinated Universal Time)	1122304


CREATE TABLE securities (
  "ticker_symbol" VARCHAR,
  "security" VARCHAR,
  "sec_filings" VARCHAR,
  "gics_sector" VARCHAR,
  "gics_sub_industry" VARCHAR,
  "address_of_headquarters" VARCHAR,
  "date_first_added" TIMESTAMP,
  "cik" BIGINT
);