Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Sjm
@kaggle.rprkh15_sp500_stock_prices.sjm

  • 315.6 KB
  • 6973 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Mon Oct 31 1994 00:00:00 GMT+0000 (Coordinated Universal Time)12.32432769474230512.78566616459896812.32432769474230512.5220441818237332800
Tue Nov 01 1994 00:00:00 GMT+0000 (Coordinated Universal Time)12.52203910746038912.52203910746038912.32432270050048812.32432270050048813200
Wed Nov 02 1994 00:00:00 GMT+0000 (Coordinated Universal Time)12.32432769474230512.5220441818237312.25842219904849612.522044181823737000
Thu Nov 03 1994 00:00:00 GMT+0000 (Coordinated Universal Time)12.52204410613529412.58794960143074212.45613861083984412.4561386108398445400
Fri Nov 04 1994 00:00:00 GMT+0000 (Coordinated Universal Time)12.4561402501286712.52204575409760412.1925182342529312.192518234252939800
Mon Nov 07 1994 00:00:00 GMT+0000 (Coordinated Universal Time)12.1925135581724112.25841903686523412.12660807947958812.2584190368652347200
Tue Nov 08 1994 00:00:00 GMT+0000 (Coordinated Universal Time)12.25842656259951412.25842656259951412.12661552429199212.1266155242919922200
Wed Nov 09 1994 00:00:00 GMT+0000 (Coordinated Universal Time)12.1925182342529312.25842373822186512.1925182342529312.192518234252935600
Thu Nov 10 1994 00:00:00 GMT+0000 (Coordinated Universal Time)12.1925182342529312.1925182342529312.12661273028399712.1925182342529382800
Fri Nov 11 1994 00:00:00 GMT+0000 (Coordinated Universal Time)12.1925182342529312.25842373822186512.12661273028399712.1925182342529316400

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