Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Lyv
@kaggle.rprkh15_sp500_stock_prices.lyv

  • 155.13 KB
  • 4166 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Wed Dec 21 2005 00:00:00 GMT+0000 (Coordinated Universal Time)1111.05000019073486310.55000019073486310.8500003814697285796900
Thu Dec 22 2005 00:00:00 GMT+0000 (Coordinated Universal Time)10.60000038146972811.11999988555908210.5900001525878910.6000003814697284152500
Fri Dec 23 2005 00:00:00 GMT+0000 (Coordinated Universal Time)10.89999961853027212.77999973297119110.89999961853027211.9499998092651378844700
Tue Dec 27 2005 00:00:00 GMT+0000 (Coordinated Universal Time)12.19999980926513712.78999996185302712.13000011444091812.53324100
Wed Dec 28 2005 00:00:00 GMT+0000 (Coordinated Universal Time)12.251412.2513.3000001907348633187700
Thu Dec 29 2005 00:00:00 GMT+0000 (Coordinated Universal Time)13.80000019073486313.82999992370605613.21000003814697313.2100000381469731092100
Fri Dec 30 2005 00:00:00 GMT+0000 (Coordinated Universal Time)13.64999961853027213.64999961853027212.6599998474121113.1000003814697281208400
Tue Jan 03 2006 00:00:00 GMT+0000 (Coordinated Universal Time)12.89999961853027213.512.810000419616713.51875500
Wed Jan 04 2006 00:00:00 GMT+0000 (Coordinated Universal Time)13.47000026702880913.85000038146972813132342000
Thu Jan 05 2006 00:00:00 GMT+0000 (Coordinated Universal Time)13.30000019073486313.310000419616712.949999809265137132880600

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

Share link

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