Baselight
Sign In

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Aee
@kaggle.rprkh15_sp500_stock_prices.aee

  • 311.1 KB
  • 6171 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Fri Jan 02 1998 00:00:00 GMT+0000 (Coordinated Universal Time)13.14794739215043213.16705778080181412.95684350563661813.090616226196287444000
Mon Jan 05 1998 00:00:00 GMT+0000 (Coordinated Universal Time)13.1670659696354613.1861763701719412.86129956105176212.995072364807127564300
Tue Jan 06 1998 00:00:00 GMT+0000 (Coordinated Universal Time)12.8804013978189512.89951178564954212.76573907083539812.803959846496582253600
Wed Jan 07 1998 00:00:00 GMT+0000 (Coordinated Universal Time)12.80396289136036412.80396289136036412.49819661335772712.689300537109377358100
Thu Jan 08 1998 00:00:00 GMT+0000 (Coordinated Universal Time)12.7084134337378712.7084134337378712.45997828390540212.536419868469238325100
Fri Jan 09 1998 00:00:00 GMT+0000 (Coordinated Universal Time)12.51730549371494812.78485095464931112.51730549371494812.651078224182127306600
Mon Jan 12 1998 00:00:00 GMT+0000 (Coordinated Universal Time)12.57464213285617712.78485651501638512.53642133609977312.765746116638184268300
Tue Jan 13 1998 00:00:00 GMT+0000 (Coordinated Universal Time)12.76575046499030812.76575046499030812.59375682100091812.670198440551758193300
Wed Jan 14 1998 00:00:00 GMT+0000 (Coordinated Universal Time)12.6701899485154612.6701899485154612.57463798811941712.612858772277832139500
Thu Jan 15 1998 00:00:00 GMT+0000 (Coordinated Universal Time)12.59374884524086712.59374884524086712.30709295346755612.32620334625244155400

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