Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Dfs
@kaggle.rprkh15_sp500_stock_prices.dfs

  • 195.22 KB
  • 3796 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Thu Jun 14 2007 00:00:00 GMT+0000 (Coordinated Universal Time)21.7887185801630523.7341398819633221.7887185801630522.3723449707031253279100
Fri Jun 15 2007 00:00:00 GMT+0000 (Coordinated Universal Time)22.9559600873523723.1894099352234922.47349518838422.62912940979004790100
Mon Jun 18 2007 00:00:00 GMT+0000 (Coordinated Universal Time)22.81589754444046423.5006865764355722.80033382002274723.290580749511721591000
Tue Jun 19 2007 00:00:00 GMT+0000 (Coordinated Universal Time)23.34506427636286623.5785143254308123.0337970495258723.111614227294921585100
Wed Jun 20 2007 00:00:00 GMT+0000 (Coordinated Universal Time)23.3761787222590923.4228684092219323.01043863570812723.19719886779785855900
Thu Jun 21 2007 00:00:00 GMT+0000 (Coordinated Universal Time)23.3917521267909124.86249206837868523.04157708107122524.286645889282227842700
Fri Jun 22 2007 00:00:00 GMT+0000 (Coordinated Universal Time)24.5123077534020925.0336792236053724.1232235033480924.667942047119141490700
Mon Jun 25 2007 00:00:00 GMT+0000 (Coordinated Universal Time)24.5123065732110524.9013908045318624.1310042046252824.356672286987305490000
Tue Jun 26 2007 00:00:00 GMT+0000 (Coordinated Universal Time)24.35667200304216424.6290312586393323.53959572048919223.66410255432129853900
Wed Jun 27 2007 00:00:00 GMT+0000 (Coordinated Universal Time)23.81195301497747623.96758580233069623.01043903948583523.0182209014892541127300

CREATE TABLE dfs (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "dividends" DOUBLE,
  "stock_splits" BIGINT
);

Share link

Anyone who has the link will be able to view this.