Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Nlok
@kaggle.rprkh15_sp500_stock_prices.nlok

  • 381.83 KB
  • 8327 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Fri Jun 23 1989 00:00:00 GMT+0000 (Coordinated Universal Time)0.28423497663891830.26609231855558310.278187423944473223190400
Mon Jun 26 1989 00:00:00 GMT+0000 (Coordinated Universal Time)0.30237755605152680.27818735156740460.29633000493049627321600
Tue Jun 27 1989 00:00:00 GMT+0000 (Coordinated Universal Time)0.296330044878290.28423494100570680.28423494100570683054400
Wed Jun 28 1989 00:00:00 GMT+0000 (Coordinated Universal Time)0.29633008202780850.27818742394447320.27818742394447322972800
Thu Jun 29 1989 00:00:00 GMT+0000 (Coordinated Universal Time)0.2842349516020880.27213984727859490.2721398472785949977600
Fri Jun 30 1989 00:00:00 GMT+0000 (Coordinated Universal Time)0.2842349516020880.27213984727859490.27213984727859491406400
Mon Jul 03 1989 00:00:00 GMT+0000 (Coordinated Universal Time)0.28423494100570680.27213983713312350.284234941005706894400
Wed Jul 05 1989 00:00:00 GMT+0000 (Coordinated Universal Time)0.27213984727859490.27213984727859490.2721398472785949137600
Thu Jul 06 1989 00:00:00 GMT+0000 (Coordinated Universal Time)0.28423497663891830.27213987125002820.2781874239444732161600
Fri Jul 07 1989 00:00:00 GMT+0000 (Coordinated Universal Time)0.28423496788765340.27213986287115750.28121137619018551040000

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