Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Mos
@kaggle.rprkh15_sp500_stock_prices.mos

  • 427.33 KB
  • 8684 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Tue Jan 26 1988 00:00:00 GMT+0000 (Coordinated Universal Time)7.3026371002197277.4613900806592857.1438841197801677.3026371002197277244600
Wed Jan 27 1988 00:00:00 GMT+0000 (Coordinated Universal Time)7.3423271468191447.8582744598388677.2629506371238027.8582744598388673652400
Thu Jan 28 1988 00:00:00 GMT+0000 (Coordinated Universal Time)7.7788989223651037.9773402214050297.6995224027491337.9773402214050292180000
Fri Jan 29 1988 00:00:00 GMT+0000 (Coordinated Universal Time)7.89796300810210557.9773395207463477.5407687012030157.7788982391357421335400
Mon Feb 01 1988 00:00:00 GMT+0000 (Coordinated Universal Time)7.6995203892389947.7788968880971277.5804556409517937.620143890380859488800
Tue Feb 02 1988 00:00:00 GMT+0000 (Coordinated Universal Time)7.6201438903808597.6201438903808597.5010791420936587.620143890380859476800
Wed Feb 03 1988 00:00:00 GMT+0000 (Coordinated Universal Time)7.6201440870147398.0170265915467567.6201440870147397.6995205879211431284600
Thu Feb 04 1988 00:00:00 GMT+0000 (Coordinated Universal Time)7.699519234865457.8185839653015147.6598309913867627.818583965301514328000
Fri Feb 05 1988 00:00:00 GMT+0000 (Coordinated Universal Time)7.7788979501435257.8979627146865387.7788979501435257.858274459838867403600
Mon Feb 08 1988 00:00:00 GMT+0000 (Coordinated Universal Time)7.6995203892389947.6995203892389947.5407673915227257.620143890380859143400

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