Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Pru
@kaggle.rprkh15_sp500_stock_prices.pru

  • 265.86 KB
  • 5179 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Thu Dec 13 2001 00:00:00 GMT+0000 (Coordinated Universal Time)16.6133907624638917.12720674709298416.55629985552321816.72757148742675849466000
Fri Dec 14 2001 00:00:00 GMT+0000 (Coordinated Universal Time)17.0701181843516817.1843000139133516.85317401488686816.944519042968759676300
Mon Dec 17 2001 00:00:00 GMT+0000 (Coordinated Universal Time)17.09867269751210717.09867269751210716.78467305437531516.813219070434575110900
Tue Dec 18 2001 00:00:00 GMT+0000 (Coordinated Universal Time)16.8417585282681817.0986671447753916.77895840225112417.098667144775395167700
Wed Dec 19 2001 00:00:00 GMT+0000 (Coordinated Universal Time)17.04157885909742417.23568737964634316.91027047429050617.212850570678713693200
Thu Dec 20 2001 00:00:00 GMT+0000 (Coordinated Universal Time)17.26994431073054417.68670634184724517.19572684736258217.2242717742919923914200
Fri Dec 21 2001 00:00:00 GMT+0000 (Coordinated Universal Time)17.35557613663224817.69241142272949217.2699402868777917.6924114227294923429100
Mon Dec 24 2001 00:00:00 GMT+0000 (Coordinated Universal Time)17.55539499764022417.97786616122210317.55539499764022417.95503044128418976900
Wed Dec 26 2001 00:00:00 GMT+0000 (Coordinated Universal Time)17.9835738191883318.69149958809706317.9835738191883318.3832092285156252456300
Thu Dec 27 2001 00:00:00 GMT+0000 (Coordinated Universal Time)18.3832089502973918.8228076761205917.99499195029346818.7542972564697274447500

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