Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Cpt
@kaggle.rprkh15_sp500_stock_prices.cpt

  • 344.21 KB
  • 7296 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Thu Jul 22 1993 00:00:00 GMT+0000 (Coordinated Universal Time)4.7652067308840544.8175716400146484.7390242763187574.8175716400146483159100
Fri Jul 23 1993 00:00:00 GMT+0000 (Coordinated Universal Time)4.8175729731077794.9484852821596214.8175729731077794.869937896728516609900
Mon Jul 26 1993 00:00:00 GMT+0000 (Coordinated Universal Time)4.8699395577986174.8699395577986174.7652096748352054.765209674835205218400
Tue Jul 27 1993 00:00:00 GMT+0000 (Coordinated Universal Time)4.7913921455760584.7913921455760584.7652096748352054.765209674835205183800
Wed Jul 28 1993 00:00:00 GMT+0000 (Coordinated Universal Time)4.7652067308840544.8437540945799454.7652067308840544.817571640014648192900
Thu Jul 29 1993 00:00:00 GMT+0000 (Coordinated Universal Time)4.8175724008695674.8437548595699464.79138994216918954.7913899421691895114100
Fri Jul 30 1993 00:00:00 GMT+0000 (Coordinated Universal Time)4.79138994216918954.79138994216918954.7652074834688114.791389942169189557200
Mon Aug 02 1993 00:00:00 GMT+0000 (Coordinated Universal Time)4.7913921455760584.8175746163169114.7652096748352054.76520967483520579800
Tue Aug 03 1993 00:00:00 GMT+0000 (Coordinated Universal Time)4.7913891854493514.8175716400146484.7652067308840544.817571640014648155100
Wed Aug 04 1993 00:00:00 GMT+0000 (Coordinated Universal Time)4.8175742072028084.8437566757202154.7913917386854024.84375667572021581000

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

Share link

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