Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Cdw
@kaggle.rprkh15_sp500_stock_prices.cdw

  • 118.54 KB
  • 2276 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Thu Jun 27 2013 00:00:00 GMT+0000 (Coordinated Universal Time)16.129735649474417.14470260158396215.89199556411318416.7972373962402348285800
Fri Jun 28 2013 00:00:00 GMT+0000 (Coordinated Universal Time)16.8246561978467117.5287319175555116.80636810911575217.025821685791016717400
Mon Jul 01 2013 00:00:00 GMT+0000 (Coordinated Universal Time)17.05326451410541517.28186055784422616.76980590820312516.769805908203125394200
Tue Jul 02 2013 00:00:00 GMT+0000 (Coordinated Universal Time)16.76979831880970617.95849651067071716.69664768768054617.57445526123047223800
Wed Jul 03 2013 00:00:00 GMT+0000 (Coordinated Universal Time)17.36414887280261617.56531268928731717.07154632371622717.446443557739258103700
Fri Jul 05 2013 00:00:00 GMT+0000 (Coordinated Universal Time)17.19041401179022417.70247017374296316.96181807150552217.57445526123047111800
Mon Jul 08 2013 00:00:00 GMT+0000 (Coordinated Universal Time)17.41901351554998517.81219889232290817.2452818211076517.583602905273438110500
Tue Jul 09 2013 00:00:00 GMT+0000 (Coordinated Universal Time)17.49215974021204518.2145237138424717.4281531590647517.830482482910156206400
Wed Jul 10 2013 00:00:00 GMT+0000 (Coordinated Universal Time)17.80305225133509618.2419578080402917.41901097924849817.464731216430664334900
Thu Jul 11 2013 00:00:00 GMT+0000 (Coordinated Universal Time)17.4190109752957417.967641613016217.4190109752957417.903635025024414108800

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