Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Dvn
@kaggle.rprkh15_sp500_stock_prices.dvn

  • 405.83 KB
  • 9319 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Mon Jul 22 1985 00:00:00 GMT+0000 (Coordinated Universal Time)3.84319233894348143.58697951634724933.843192338943481459400
Tue Jul 23 1985 00:00:00 GMT+0000 (Coordinated Universal Time)3.97129875024159773.8004902018441093.843192338943481420800
Wed Jul 24 1985 00:00:00 GMT+0000 (Coordinated Universal Time)3.8004869439385163.6723806424574423.75778484344482432600
Thu Jul 25 1985 00:00:00 GMT+0000 (Coordinated Universal Time)3.8004901409149173.7577880045001433.80049014091491716600
Fri Jul 26 1985 00:00:00 GMT+0000 (Coordinated Universal Time)3.8004869439385163.7150827429511333.75778484344482410400
Mon Jul 29 1985 00:00:00 GMT+0000 (Coordinated Universal Time)3.7577873975381083.6296810089856733.7150852680206325000
Tue Jul 30 1985 00:00:00 GMT+0000 (Coordinated Universal Time)3.7150851987129033.67238306999206543.672383069992065410400
Wed Jul 31 1985 00:00:00 GMT+0000 (Coordinated Universal Time)3.67238306999206543.6296809412712283.672383069992065412800
Thu Aug 01 1985 00:00:00 GMT+0000 (Coordinated Universal Time)3.67238306999206543.5442766838295523.672383069992065431800
Fri Aug 02 1985 00:00:00 GMT+0000 (Coordinated Universal Time)3.6296795947211133.54427536896296943.58697748184204113000

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

Share link

Anyone who has the link will be able to view this.