Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Fds
@kaggle.rprkh15_sp500_stock_prices.fds

  • 319.33 KB
  • 6553 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Fri Jun 28 1996 00:00:00 GMT+0000 (Coordinated Universal Time)3.2981120175848763.6546648335570743.27582717968199733.5655262470245367850250
Mon Jul 01 1996 00:00:00 GMT+0000 (Coordinated Universal Time)3.5209580896376993.6100963127026553.5209580896376993.5878114700317383663750
Tue Jul 02 1996 00:00:00 GMT+0000 (Coordinated Universal Time)3.54324256020963053.6992341472869333.54324256020963053.6546652317047121340100
Wed Jul 03 1996 00:00:00 GMT+0000 (Coordinated Universal Time)3.6769483806401693.6769483806401693.54324166757760353.610095024108887660600
Fri Jul 05 1996 00:00:00 GMT+0000 (Coordinated Universal Time)3.54324245452880863.54324245452880863.45410424348347523.5432424545288086502650
Mon Jul 08 1996 00:00:00 GMT+0000 (Coordinated Universal Time)3.565525937733813.565525937733813.2981117314909343.3203961849212646584550
Tue Jul 09 1996 00:00:00 GMT+0000 (Coordinated Universal Time)3.3426821740381793.38725071373448743.29811286926269583.2981128692626958238500
Wed Jul 10 1996 00:00:00 GMT+0000 (Coordinated Universal Time)3.29811258042663763.3203970395929983.164404869079593.16440486907959520200
Thu Jul 11 1996 00:00:00 GMT+0000 (Coordinated Universal Time)3.119836330171283.119836330171282.9638439685438523.0752668380737305192600
Fri Jul 12 1996 00:00:00 GMT+0000 (Coordinated Universal Time)3.07526622303100353.1198357062148093.07526622303100353.09755086898803749500

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