Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Vici
@kaggle.rprkh15_sp500_stock_prices.vici

  • 61.63 KB
  • 1139 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Tue Jan 02 2018 00:00:00 GMT+0000 (Coordinated Universal Time)15.8109823234333716.28531209470692815.77145547076589515.890037536621094427900
Wed Jan 03 2018 00:00:00 GMT+0000 (Coordinated Universal Time)16.20626017181653816.28531540105455415.8109855334795515.93747329711914231300
Thu Jan 04 2018 00:00:00 GMT+0000 (Coordinated Universal Time)15.92956591212912616.2062584308111215.8900390556829515.969094276428224447800
Fri Jan 05 2018 00:00:00 GMT+0000 (Coordinated Universal Time)15.96909427642822415.96909427642822415.92956591212912615.96909427642822478300
Mon Jan 08 2018 00:00:00 GMT+0000 (Coordinated Universal Time)15.96909427642822415.96909427642822415.85051069138385115.96909427642822459200
Tue Jan 09 2018 00:00:00 GMT+0000 (Coordinated Universal Time)15.96909511741375615.97699928283691215.81098466759658715.976999282836914224700
Wed Jan 10 2018 00:00:00 GMT+0000 (Coordinated Universal Time)15.7319312846949315.96909698718973115.7319312846949315.810986518859863367500
Thu Jan 11 2018 00:00:00 GMT+0000 (Coordinated Universal Time)15.81098651885986315.81098651885986315.6924044215390515.81098651885986337800
Fri Jan 12 2018 00:00:00 GMT+0000 (Coordinated Universal Time)15.8109862328356515.8109862328356515.4157115770147615.8030805587768551109300
Tue Jan 16 2018 00:00:00 GMT+0000 (Coordinated Universal Time)16.20626156829124318.17472925588764516.20626156829124316.9968109130859382005000

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