S&P 500 Stocks (daily Updated)

Stock and company data on all members of the popular financial index.

@kaggle.andrewmvd_sp_500_stocks

Table List

3 tables(15.91 MB)

Sp500 Companies

Sp500 Index

Sp500 Stocks

Sp500 Companies

@kaggle.andrewmvd_sp_500_stocks.sp500_companies

406.95 KB
502 rows
16 columns

exchange Exchange	symbol Symbol	shortname Shortname	longname Longname	sector Sector	industry Industry	currentprice Currentprice	marketcap Marketcap	ebitda Ebitda	revenuegrowth Revenuegrowth	city City	state State	country Country	fulltimeemployees Fulltimeemployees	longbusinesssummary Longbusinesssummary	weight Weight
NMS	AAPL	Apple Inc.	Apple Inc.	Technology	Consumer Electronics	254.49	3846819807232	134660997120	0.061	Cupertino	CA	United States	164000	Apple Inc. designs, manufactures, and markets smartphones, personal computers, tablets, wearables, and accessories worldwide. The company offers iPhone, a line of smartphones; Mac, a line of personal computers; iPad, a line of multi-purpose tablets; and wearables, home, and accessories comprising Ai…	0.0692091524397274
NMS	NVDA	NVIDIA Corporation	NVIDIA Corporation	Technology	Semiconductors	134.7	3298803056640	61184000000	1.224	Santa Clara	CA	United States	29600	NVIDIA Corporation provides graphics and compute and networking solutions in the United States, Taiwan, China, Hong Kong, and internationally. The Graphics segment offers GeForce GPUs for gaming and PCs, the GeForce NOW game streaming service and related infrastructure, and solutions for gaming plat…	0.0593496381573215
NMS	MSFT	Microsoft Corporation	Microsoft Corporation	Technology	Software - Infrastructure	436.6	3246068596736	136551997440	0.16	Redmond	WA	United States	228000	Microsoft Corporation develops and supports software, services, devices and solutions worldwide. The Productivity and Business Processes segment offers office, exchange, SharePoint, Microsoft Teams, office 365 Security and Compliance, Microsoft viva, and Microsoft 365 copilot; and office consumer se…	0.0584008785436112
NMS	AMZN	Amazon.com, Inc.	Amazon.com, Inc.	Consumer Cyclical	Internet Retail	224.92	2365033807872	111583002624	0.11	Seattle	WA	United States	1551000	Amazon.com, Inc. engages in the retail sale of consumer products, advertising, and subscriptions service through online and physical stores in North America and internationally. The company operates through three segments: North America, International, and Amazon Web Services (AWS). It also manufact…	0.0425499486683522
NMS	GOOGL	Alphabet Inc.	Alphabet Inc.	Communication Services	Internet Content & Information	191.41	2351625142272	123469996032	0.151	Mountain View	CA	United States	181269	Alphabet Inc. offers various products and platforms in the United States, Europe, the Middle East, Africa, the Asia-Pacific, Canada, and Latin America. It operates through Google Services, Google Cloud, and Other Bets segments. The Google Services segment provides products and services, including ad…	0.0423087098196338
NMS	GOOG	Alphabet Inc.	Alphabet Inc.	Communication Services	Internet Content & Information	192.96	2351623045120	123469996032	0.151	Mountain View	CA	United States	181269	Alphabet Inc. offers various products and platforms in the United States, Europe, the Middle East, Africa, the Asia-Pacific, Canada, and Latin America. It operates through Google Services, Google Cloud, and Other Bets segments. The Google Services segment provides products and services, including ad…	0.0423086720892176
NMS	META	Meta Platforms, Inc.	Meta Platforms, Inc.	Communication Services	Internet Content & Information	585.25	1477457739776	79208996864	0.189	Menlo Park	CA	United States	72404	Meta Platforms, Inc. engages in the development of products that enable people to connect and share with friends and family through mobile devices, personal computers, virtual reality headsets, and wearables worldwide. It operates in two segments, Family of Apps and Reality Labs. The Family of Apps …	0.0265813329085953
NMS	TSLA	Tesla, Inc.	Tesla, Inc.	Consumer Cyclical	Auto Manufacturers	421.06	1351627833344	13244000256	0.078	Austin	TX	United States	140473	Tesla, Inc. designs, develops, manufactures, leases, and sells electric vehicles, and energy generation and storage systems in the United States, China, and internationally. The company operates in two segments, Automotive, and Energy Generation and Storage. The Automotive segment offers electric ve…	0.0243174937863789
NMS	AVGO	Broadcom Inc.	Broadcom Inc.	Technology	Semiconductors	220.79	1031217348608	22958000128	0.164	Palo Alto	CA	United States	20000	Broadcom Inc. designs, develops, and supplies various semiconductor devices with a focus on complex digital and mixed signal complementary metal oxide semiconductor based devices and analog III-V based products worldwide. The company operates in two segments, Semiconductor Solutions and Infrastructu…	0.0185529040232474
NYQ	BRK-B	Berkshire Hathaway Inc. New	Berkshire Hathaway Inc.	Financial Services	Insurance - Diversified	453.2	978776031232	149547008000	-0.002	Omaha	NE	United States	396500	Berkshire Hathaway Inc., through its subsidiaries, engages in the insurance, freight rail transportation, and utility businesses worldwide. The company provides property, casualty, life, accident, and health insurance and reinsurance; and operates railroad systems in North America. It also generates…	0.0176094184142796


CREATE TABLE sp500_companies (
  "exchange" VARCHAR,
  "symbol" VARCHAR,
  "shortname" VARCHAR,
  "longname" VARCHAR,
  "sector" VARCHAR,
  "industry" VARCHAR,
  "currentprice" DOUBLE,
  "marketcap" BIGINT,
  "ebitda" DOUBLE,
  "revenuegrowth" DOUBLE,
  "city" VARCHAR,
  "state" VARCHAR,
  "country" VARCHAR,
  "fulltimeemployees" DOUBLE,
  "longbusinesssummary" VARCHAR,
  "weight" DOUBLE
);