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 Stocks

@kaggle.andrewmvd_sp_500_stocks.sp500_stocks

15.47 MB
1891536 rows
8 columns

date Date	symbol Symbol	adj_close Adj Close	close Close	high High	low Low	open Open	volume Volume
Mon Jan 04 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	MMM
Tue Jan 05 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	MMM
Wed Jan 06 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	MMM
Thu Jan 07 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	MMM
Fri Jan 08 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	MMM
Mon Jan 11 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	MMM
Tue Jan 12 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	MMM
Wed Jan 13 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	MMM
Thu Jan 14 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	MMM
Fri Jan 15 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	MMM


CREATE TABLE sp500_stocks (
  "date" TIMESTAMP,
  "symbol" VARCHAR,
  "adj_close" DOUBLE,
  "close" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "open" DOUBLE,
  "volume" DOUBLE
);