Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Kdp
@kaggle.rprkh15_sp500_stock_prices.kdp

  • 182.78 KB
  • 3570 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Wed May 07 2008 00:00:00 GMT+0000 (Coordinated Universal Time)2.9537275535401253.02405421907340032.90684281176725272.988890886306762738943400
Thu May 08 2008 00:00:00 GMT+0000 (Coordinated Universal Time)2.9982685618938913.0275714212648492.89981093652242632.97717046737670912468400
Fri May 09 2008 00:00:00 GMT+0000 (Coordinated Universal Time)2.94200788169386532.97717123255125632.9232540647615052.95841741561889659747000
Mon May 12 2008 00:00:00 GMT+0000 (Coordinated Universal Time)2.94317985075023233.14712776561224232.9420077093152472.997097015380867921800
Tue May 13 2008 00:00:00 GMT+0000 (Coordinated Universal Time)2.97482637175067843.0381206592762472.95372849947191173.0357763767242434518800
Wed May 14 2008 00:00:00 GMT+0000 (Coordinated Universal Time)2.98889190351279373.08383311314435772.88340164574849033.06742358207702644295600
Thu May 15 2008 00:00:00 GMT+0000 (Coordinated Universal Time)3.01819513366717953.0955546803732112.9982691762693763.05101442337036133969300
Fri May 16 2008 00:00:00 GMT+0000 (Coordinated Universal Time)3.0310883965728453.13540652338063943.00881815679975873.106103658676147511418200
Mon May 19 2008 00:00:00 GMT+0000 (Coordinated Universal Time)3.06507935489397053.1002429238265513.04398125824704163.0557024478912365645100
Tue May 20 2008 00:00:00 GMT+0000 (Coordinated Universal Time)3.0123352623982773.0404659920498232.93028713324222872.9947533607482918338100

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