Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Wat
@kaggle.rprkh15_sp500_stock_prices.wat

  • 254.19 KB
  • 6707 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Fri Nov 17 1995 00:00:00 GMT+0000 (Coordinated Universal Time)3.753.81253.753.7812512706000
Mon Nov 20 1995 00:00:00 GMT+0000 (Coordinated Universal Time)3.753.781253.753.751213200
Tue Nov 21 1995 00:00:00 GMT+0000 (Coordinated Universal Time)3.753.781253.753.75909600
Wed Nov 22 1995 00:00:00 GMT+0000 (Coordinated Universal Time)3.753.781253.753.751314800
Fri Nov 24 1995 00:00:00 GMT+0000 (Coordinated Universal Time)3.753.781253.753.75275200
Mon Nov 27 1995 00:00:00 GMT+0000 (Coordinated Universal Time)3.753.781253.753.751011600
Tue Nov 28 1995 00:00:00 GMT+0000 (Coordinated Universal Time)3.6253.6253.31253.531253952000
Wed Nov 29 1995 00:00:00 GMT+0000 (Coordinated Universal Time)3.53.56253.343753.4375708400
Thu Nov 30 1995 00:00:00 GMT+0000 (Coordinated Universal Time)3.43753.753.406253.68751346000
Fri Dec 01 1995 00:00:00 GMT+0000 (Coordinated Universal Time)3.68753.68753.531253.5625790800

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