SP500 Csv

S&P 500 5 year monthly prices and returns 20211204

@kaggle.wmcginn_sp500_csv

Tickerlist

@kaggle.wmcginn_sp500_csv.tickerlist

unnamed_0 Unnamed: 0	name Name	ticker Ticker	sector Sector
1	Apple Inc.	AAPL	Information Technology
2	Microsoft Corporation	MSFT	Information Technology
3	Amazon.com Inc.	AMZN	Consumer Discretionary
4	Facebook Inc. Class A	FB	Communication Services
5	Alphabet Inc. Class A	GOOGL	Communication Services
6	Alphabet Inc. Class C	GOOG	Communication Services
7	Tesla Inc	TSLA	Consumer Discretionary
8	NVIDIA Corporation	NVDA	Information Technology
9	Berkshire Hathaway Inc. Class B	BRK-B	Financials
10	JPMorgan Chase & Co.	JPM	Financials


CREATE TABLE tickerlist (
  "unnamed_0" BIGINT,
  "name" VARCHAR,
  "ticker" VARCHAR,
  "sector" VARCHAR
);