Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Ptc
@kaggle.rprkh15_sp500_stock_prices.ptc

  • 269.08 KB
  • 8210 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Fri Dec 08 1989 00:00:00 GMT+0000 (Coordinated Universal Time)1.84895801544189431.6406251.822916984558105226329920
Mon Dec 11 1989 00:00:00 GMT+0000 (Coordinated Universal Time)1.8751.718751.77083301544189433155520
Tue Dec 12 1989 00:00:00 GMT+0000 (Coordinated Universal Time)1.82291698455810521.77083301544189431.77083301544189431175040
Wed Dec 13 1989 00:00:00 GMT+0000 (Coordinated Universal Time)1.7968751.718751.718751050240
Thu Dec 14 1989 00:00:00 GMT+0000 (Coordinated Universal Time)1.82291698455810521.69270801544189431.82291698455810521039680
Fri Dec 15 1989 00:00:00 GMT+0000 (Coordinated Universal Time)1.8751.74479198455810571.8229169845581052665280
Mon Dec 18 1989 00:00:00 GMT+0000 (Coordinated Universal Time)1.82291698455810521.718751.7447919845581057496320
Tue Dec 19 1989 00:00:00 GMT+0000 (Coordinated Universal Time)1.7968751.718751.7578129768371582412800
Wed Dec 20 1989 00:00:00 GMT+0000 (Coordinated Universal Time)1.77083301544189431.74479198455810571.7578129768371582198720
Thu Dec 21 1989 00:00:00 GMT+0000 (Coordinated Universal Time)1.84895801544189431.74479198455810571.8489580154418943567360

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