Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Anss
@kaggle.rprkh15_sp500_stock_prices.anss

  • 241.52 KB
  • 6559 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Thu Jun 20 1996 00:00:00 GMT+0000 (Coordinated Universal Time)33.1252.93752.9687512638800
Fri Jun 21 1996 00:00:00 GMT+0000 (Coordinated Universal Time)3.031253.09375331881200
Mon Jun 24 1996 00:00:00 GMT+0000 (Coordinated Universal Time)3.06253.2187533.218751606000
Tue Jun 25 1996 00:00:00 GMT+0000 (Coordinated Universal Time)3.218753.281253.156253.156251895600
Wed Jun 26 1996 00:00:00 GMT+0000 (Coordinated Universal Time)3.18753.18753.1253.15625399200
Thu Jun 27 1996 00:00:00 GMT+0000 (Coordinated Universal Time)3.18753.343753.156253.25348400
Fri Jun 28 1996 00:00:00 GMT+0000 (Coordinated Universal Time)3.253.343753.253.28125157200
Mon Jul 01 1996 00:00:00 GMT+0000 (Coordinated Universal Time)3.31253.31253.218753.21875117200
Tue Jul 02 1996 00:00:00 GMT+0000 (Coordinated Universal Time)3.218753.253.218753.2585600
Wed Jul 03 1996 00:00:00 GMT+0000 (Coordinated Universal Time)3.18753.406253.18753.40625370400

CREATE TABLE anss (
  "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.