Baselight
Sign In

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Key
@kaggle.rprkh15_sp500_stock_prices.key

  • 424.35 KB
  • 8739 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Thu Nov 05 1987 00:00:00 GMT+0000 (Coordinated Universal Time)1.77693007370652661.78691274030988481.7569646028363391.766947269439697355310
Fri Nov 06 1987 00:00:00 GMT+0000 (Coordinated Universal Time)1.77693007370652661.7968954069132431.76694726943969731.7669472694396973212201
Mon Nov 09 1987 00:00:00 GMT+0000 (Coordinated Universal Time)1.75696434046196171.77692980835062751.71703326702117921.7170332670211792107727
Tue Nov 10 1987 00:00:00 GMT+0000 (Coordinated Universal Time)1.73699926962962261.77693007370652661.7170335234324931.766947269439697361816
Wed Nov 11 1987 00:00:00 GMT+0000 (Coordinated Universal Time)1.73699926962962261.78691274030988481.73699926962962261.766947269439697365793
Thu Nov 12 1987 00:00:00 GMT+0000 (Coordinated Universal Time)1.79689532680475671.87675761971553051.77692999448812671.8667746782302856102305
Fri Nov 13 1987 00:00:00 GMT+0000 (Coordinated Universal Time)1.8468092082501911.8967230896956251.8368265420918761.866774678230285630366
Mon Nov 16 1987 00:00:00 GMT+0000 (Coordinated Universal Time)1.84680954356179841.87675796046465121.8368268755910041.856792211532592853502
Tue Nov 17 1987 00:00:00 GMT+0000 (Coordinated Universal Time)1.8667739287751421.87675686625252911.81686034269548281.826843142509460430004
Wed Nov 18 1987 00:00:00 GMT+0000 (Coordinated Universal Time)1.81685971096201041.81685971096201041.7569632082313521.776928663253784238681

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