Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Ajg
@kaggle.rprkh15_sp500_stock_prices.ajg

  • 418.3 KB
  • 9593 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Wed Jun 20 1984 00:00:00 GMT+0000 (Coordinated Universal Time)0.66041350364685060.64940661191940310.64940661191940312004000
Thu Jun 21 1984 00:00:00 GMT+0000 (Coordinated Universal Time)0.64940704379165380.62739324569702150.6273932456970215626400
Fri Jun 22 1984 00:00:00 GMT+0000 (Coordinated Universal Time)0.63840014474433760.62739324569702150.6273932456970215229600
Mon Jun 25 1984 00:00:00 GMT+0000 (Coordinated Universal Time)0.63840015232563020.6163863539695740.616386353969574102400
Tue Jun 26 1984 00:00:00 GMT+0000 (Coordinated Universal Time)0.61638636155561970.60537946224212650.6053794622421265129600
Wed Jun 27 1984 00:00:00 GMT+0000 (Coordinated Universal Time)0.62739325314760210.6163863539695740.616386353969574213600
Thu Jun 28 1984 00:00:00 GMT+0000 (Coordinated Universal Time)0.62739325314760210.6163863539695740.616386353969574212000
Fri Jun 29 1984 00:00:00 GMT+0000 (Coordinated Universal Time)0.66041387360671470.63840007781982420.6384000778198242208000
Mon Jul 02 1984 00:00:00 GMT+0000 (Coordinated Universal Time)0.66041387360671470.63840007781982420.6384000778198242144800
Tue Jul 03 1984 00:00:00 GMT+0000 (Coordinated Universal Time)0.66041387360671470.63840007781982420.638400077819824248000

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