Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Kmx
@kaggle.rprkh15_sp500_stock_prices.kmx

  • 235.71 KB
  • 6401 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Tue Feb 04 1997 00:00:00 GMT+0000 (Coordinated Universal Time)111110.312510.562526677600
Wed Feb 05 1997 00:00:00 GMT+0000 (Coordinated Universal Time)10.62510.7510.12510.1256762800
Thu Feb 06 1997 00:00:00 GMT+0000 (Coordinated Universal Time)10.187510.37510.12510.31252238200
Fri Feb 07 1997 00:00:00 GMT+0000 (Coordinated Universal Time)10.2510.312510.2510.251405800
Mon Feb 10 1997 00:00:00 GMT+0000 (Coordinated Universal Time)10.2510.62510.2510.51666800
Tue Feb 11 1997 00:00:00 GMT+0000 (Coordinated Universal Time)10.510.62510.437510.51444200
Wed Feb 12 1997 00:00:00 GMT+0000 (Coordinated Universal Time)10.510.562510.312510.375780000
Thu Feb 13 1997 00:00:00 GMT+0000 (Coordinated Universal Time)10.437510.437510101518600
Fri Feb 14 1997 00:00:00 GMT+0000 (Coordinated Universal Time)10.062510.1251010511600
Tue Feb 18 1997 00:00:00 GMT+0000 (Coordinated Universal Time)10.062510.06251010.0625746000

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

Share link

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