Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Sre
@kaggle.rprkh15_sp500_stock_prices.sre

  • 305.4 KB
  • 6049 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Mon Jun 29 1998 00:00:00 GMT+0000 (Coordinated Universal Time)11.71238482285380811.97150838088154311.58282304383993611.8419466018676766307500
Tue Jun 30 1998 00:00:00 GMT+0000 (Coordinated Universal Time)11.79012666123636811.79012666123636811.5050906320636211.531002998352051537600
Wed Jul 01 1998 00:00:00 GMT+0000 (Coordinated Universal Time)11.50508390520720211.60873330975861811.2459603938286611.55690860748291593100
Thu Jul 02 1998 00:00:00 GMT+0000 (Coordinated Universal Time)11.50508219286227511.50508219286227511.29778341461250311.479169845581056563600
Mon Jul 06 1998 00:00:00 GMT+0000 (Coordinated Universal Time)11.479169382994211.479169382994211.24595826686113611.271870613098145616800
Tue Jul 07 1998 00:00:00 GMT+0000 (Coordinated Universal Time)11.2718764849127611.2977888446481911.16822704597103111.220051765441896623500
Wed Jul 08 1998 00:00:00 GMT+0000 (Coordinated Universal Time)11.22005438367161111.29779148101806611.1941420178894611.297791481018066392300
Thu Jul 09 1998 00:00:00 GMT+0000 (Coordinated Universal Time)11.24596036805046911.27187271912892711.09048626157972411.194135665893556293100
Fri Jul 10 1998 00:00:00 GMT+0000 (Coordinated Universal Time)11.19413566589355611.19413566589355610.90909980403052311.194135665893556384300
Mon Jul 13 1998 00:00:00 GMT+0000 (Coordinated Universal Time)11.09048544417980211.16822249168573610.9090989999992911.14231014251709385500

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