Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Rhi
@kaggle.rprkh15_sp500_stock_prices.rhi

  • 426.47 KB
  • 10671 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Mon Mar 17 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.08802359620864280.0829932838678360.082993283867836360000
Tue Mar 18 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.08676621479660160.08173590153455730.08173590153455731944000
Wed Mar 19 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.08676621479660160.08173590153455730.08173590153455731756800
Thu Mar 20 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.08676621479660160.08173590153455730.08173590153455731324800
Fri Mar 21 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.08550880966450870.08047849684953690.08047849684953691872000
Mon Mar 24 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.08550880966450870.08047849684953690.080478496849536986400
Tue Mar 25 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.08425070515687590.07922111451625820.0792211145162582446400
Wed Mar 26 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.08299329208743570.07796370238065720.0779637023806572388800
Thu Mar 27 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.07796370365800130.07293339073657990.0729333907365799648000
Fri Mar 28 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.07796370365800130.07293339073657990.0729333907365799100800

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

Share link

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