Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Rsg
@kaggle.rprkh15_sp500_stock_prices.rsg

  • 301.07 KB
  • 6047 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Wed Jul 01 1998 00:00:00 GMT+0000 (Coordinated Universal Time)11.05615687533923511.24772479954887810.9193240754744611.16562461853027220818650
Thu Jul 02 1998 00:00:00 GMT+0000 (Coordinated Universal Time)11.19299855876699611.27509878656846411.165630980999811.247731208801273037200
Mon Jul 06 1998 00:00:00 GMT+0000 (Coordinated Universal Time)11.2477261640023511.38455898046621711.16562597302422911.3298263549804691737750
Tue Jul 07 1998 00:00:00 GMT+0000 (Coordinated Universal Time)11.38455759941365611.38455759941365611.16562461853027211.1656246185302721077000
Wed Jul 08 1998 00:00:00 GMT+0000 (Coordinated Universal Time)11.22036363103407611.27509878656846411.165630980999811.247731208801271180500
Thu Jul 09 1998 00:00:00 GMT+0000 (Coordinated Universal Time)11.2203585985099811.35719392047283811.16562597302422911.3298263549804691443900
Fri Jul 10 1998 00:00:00 GMT+0000 (Coordinated Universal Time)11.38455703270569711.57612494737934511.30245685577392611.3024568557739261117350
Mon Jul 13 1998 00:00:00 GMT+0000 (Coordinated Universal Time)11.27509403228759811.30245909301586411.16562627287734911.275094032287598790800
Tue Jul 14 1998 00:00:00 GMT+0000 (Coordinated Universal Time)11.2750914309550511.3298240452830111.19299125671386711.1929912567138671276350
Wed Jul 15 1998 00:00:00 GMT+0000 (Coordinated Universal Time)11.1656256760542711.3845586776733411.1656256760542711.38455867767334863400

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