Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Algn
@kaggle.rprkh15_sp500_stock_prices.algn

  • 204.59 KB
  • 5396 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Tue Jan 30 2001 00:00:00 GMT+0000 (Coordinated Universal Time)18.12518.187516.2516.875812300
Wed Jan 31 2001 00:00:00 GMT+0000 (Coordinated Universal Time)17.12517.187513.437513.51212700
Thu Feb 01 2001 00:00:00 GMT+0000 (Coordinated Universal Time)13.12514.3751314.1875669100
Fri Feb 02 2001 00:00:00 GMT+0000 (Coordinated Universal Time)1414.562513.7514.125775000
Mon Feb 05 2001 00:00:00 GMT+0000 (Coordinated Universal Time)14.437514.513.87514.125489400
Tue Feb 06 2001 00:00:00 GMT+0000 (Coordinated Universal Time)14.01562514.062513.87514737900
Wed Feb 07 2001 00:00:00 GMT+0000 (Coordinated Universal Time)1414.06251313.06251361000
Thu Feb 08 2001 00:00:00 GMT+0000 (Coordinated Universal Time)13.12513.18751313.0625712000
Fri Feb 09 2001 00:00:00 GMT+0000 (Coordinated Universal Time)13.04687513.062511.875121100800
Mon Feb 12 2001 00:00:00 GMT+0000 (Coordinated Universal Time)12.04687512.12510.937511.0625552000

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