Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Pg
@kaggle.rprkh15_sp500_stock_prices.pg

  • 709.79 KB
  • 15236 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Tue Jan 02 1962 00:00:00 GMT+0000 (Coordinated Universal Time)0.27343696759338510.26973190424694060.2712140381336212192000
Wed Jan 03 1962 00:00:00 GMT+0000 (Coordinated Universal Time)0.27121410595935160.26602690742900230.2682500183582306428800
Thu Jan 04 1962 00:00:00 GMT+0000 (Coordinated Universal Time)0.2689911302279930.26380392909049990.2638039290904999326400
Fri Jan 05 1962 00:00:00 GMT+0000 (Coordinated Universal Time)0.26454492810808620.25861674943387890.2619513273239136544000
Mon Jan 08 1962 00:00:00 GMT+0000 (Coordinated Universal Time)0.2604693203410360.25194754260917040.25491163134574891523200
Tue Jan 09 1962 00:00:00 GMT+0000 (Coordinated Universal Time)0.25861674337894640.25342972284569940.2545411884784698499200
Wed Jan 10 1962 00:00:00 GMT+0000 (Coordinated Universal Time)0.25713478724080120.25305905145775780.2552821636199951300800
Thu Jan 11 1962 00:00:00 GMT+0000 (Coordinated Universal Time)0.25713474312658760.25491163134574890.2549116313457489371200
Fri Jan 12 1962 00:00:00 GMT+0000 (Coordinated Universal Time)0.25861684156383130.25491177380096830.2563939094543457390400
Mon Jan 15 1962 00:00:00 GMT+0000 (Coordinated Universal Time)0.25713474312658760.25342967743426920.2549116313457489281600

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