Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Regn
@kaggle.rprkh15_sp500_stock_prices.regn

  • 264.86 KB
  • 7880 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Tue Apr 02 1991 00:00:00 GMT+0000 (Coordinated Universal Time)2223.2520.7521.1252294100
Wed Apr 03 1991 00:00:00 GMT+0000 (Coordinated Universal Time)21.2521.251718.251716100
Thu Apr 04 1991 00:00:00 GMT+0000 (Coordinated Universal Time)18.2519.517.7518810600
Fri Apr 05 1991 00:00:00 GMT+0000 (Coordinated Universal Time)18.518.517.7517.75238200
Mon Apr 08 1991 00:00:00 GMT+0000 (Coordinated Universal Time)181817.517.625200100
Tue Apr 09 1991 00:00:00 GMT+0000 (Coordinated Universal Time)18181616319000
Wed Apr 10 1991 00:00:00 GMT+0000 (Coordinated Universal Time)1616.2515.515.875582100
Thu Apr 11 1991 00:00:00 GMT+0000 (Coordinated Universal Time)1616.514.7514.75319400
Fri Apr 12 1991 00:00:00 GMT+0000 (Coordinated Universal Time)14.7516.514.7516.25329700
Mon Apr 15 1991 00:00:00 GMT+0000 (Coordinated Universal Time)16.516.751616.125171400

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

Share link

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