Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Kim
@kaggle.rprkh15_sp500_stock_prices.kim

  • 367.2 KB
  • 7715 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Fri Nov 22 1991 00:00:00 GMT+0000 (Coordinated Universal Time)0.91234028339385980.9180423887530560.90663827591816280.912340283393866522750
Mon Nov 25 1991 00:00:00 GMT+0000 (Coordinated Universal Time)0.91234028339385980.91234028339385980.90663827591816280.91234028339386868950
Tue Nov 26 1991 00:00:00 GMT+0000 (Coordinated Universal Time)0.91234028339385980.91234028339385980.91234028339385980.91234028339386165150
Wed Nov 27 1991 00:00:00 GMT+0000 (Coordinated Universal Time)0.91234028339385980.91234028339385980.90663827591816280.9123402833938693600
Fri Nov 29 1991 00:00:00 GMT+0000 (Coordinated Universal Time)0.91234028339385980.91234028339385980.90663827591816280.91234028339386151650
Mon Dec 02 1991 00:00:00 GMT+0000 (Coordinated Universal Time)0.912340511978970.912340511978970.90093629840327440.906638503074646420300
Tue Dec 03 1991 00:00:00 GMT+0000 (Coordinated Universal Time)0.9066385030746460.912340511978970.90093629840327440.906638503074646154800
Wed Dec 04 1991 00:00:00 GMT+0000 (Coordinated Universal Time)0.912340511978970.912340511978970.9066385030746460.906638503074646189450
Thu Dec 05 1991 00:00:00 GMT+0000 (Coordinated Universal Time)0.9066385030746460.9066385030746460.9066385030746460.906638503074646173700
Fri Dec 06 1991 00:00:00 GMT+0000 (Coordinated Universal Time)0.90663845025745720.90663845025745720.9009362459182740.900936245918274270450

CREATE TABLE kim (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "dividends" DOUBLE,
  "stock_splits" DOUBLE
);

Share link

Anyone who has the link will be able to view this.