Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Jci
@kaggle.rprkh15_sp500_stock_prices.jci

  • 438.64 KB
  • 8767 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Mon Sep 28 1987 00:00:00 GMT+0000 (Coordinated Universal Time)3.35052408983139443.3661081374109033.3037726323368733.3193566799163823531062
Tue Sep 29 1987 00:00:00 GMT+0000 (Coordinated Universal Time)3.3193567762682953.3505241870880133.30377272823642353.3505241870880127289708
Wed Sep 30 1987 00:00:00 GMT+0000 (Coordinated Universal Time)3.35052408983139443.35052408983139443.3037726323368733.319356679916382191346
Thu Oct 01 1987 00:00:00 GMT+0000 (Coordinated Universal Time)3.3193553103756983.36610674858093263.30377126922604573.3661067485809326680853
Fri Oct 02 1987 00:00:00 GMT+0000 (Coordinated Universal Time)3.3661082948986183.39727616310119633.3661082948986183.3972761631011963111042
Mon Oct 05 1987 00:00:00 GMT+0000 (Coordinated Universal Time)3.397275612477763.4440270645822293.3661077493268053.4128592014312744760388
Tue Oct 06 1987 00:00:00 GMT+0000 (Coordinated Universal Time)3.41285965231556883.41285965231556883.27260527747268533.3037726879119877240143
Wed Oct 07 1987 00:00:00 GMT+0000 (Coordinated Universal Time)3.3037732249012173.3037732249012173.1635190556763513.1791024208068848828781
Thu Oct 08 1987 00:00:00 GMT+0000 (Coordinated Universal Time)3.1791022733260683.2726056575775153.1323508096150433.272605657577514280487
Fri Oct 09 1987 00:00:00 GMT+0000 (Coordinated Universal Time)3.2726053174167063.3972761027689523.2726053174167063.3505241870880127249364

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