Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Rmd
@kaggle.rprkh15_sp500_stock_prices.rmd

  • 323.28 KB
  • 6825 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Fri Jun 02 1995 00:00:00 GMT+0000 (Coordinated Universal Time)0.64338650814322540.64338650814322540.56296319462532220.576367080211639414915200
Mon Jun 05 1995 00:00:00 GMT+0000 (Coordinated Universal Time)0.57636706567392120.58306941735215170.54620852839245960.54955929517745974787200
Tue Jun 06 1995 00:00:00 GMT+0000 (Coordinated Universal Time)0.56296318042569040.5696655321039210.54955929517745970.54955929517745974769600
Wed Jun 07 1995 00:00:00 GMT+0000 (Coordinated Universal Time)0.54955929517745970.54955929517745970.52275152468099830.54955929517745974793600
Thu Jun 08 1995 00:00:00 GMT+0000 (Coordinated Universal Time)0.5495593759748670.60317492485046390.53615548875596790.60317492485046397235200
Fri Jun 09 1995 00:00:00 GMT+0000 (Coordinated Universal Time)0.60317492485046390.6165788120693630.58977103763156460.60317492485046394771200
Mon Jun 12 1995 00:00:00 GMT+0000 (Coordinated Universal Time)0.61657863855361940.61657863855361940.58977087165998380.61657863855361944409600
Tue Jun 13 1995 00:00:00 GMT+0000 (Coordinated Universal Time)0.61657905578613280.61657905578613280.58977127075195310.58977127075195312212800
Wed Jun 14 1995 00:00:00 GMT+0000 (Coordinated Universal Time)0.6031751632690430.6031751632690430.58977127075195310.58977127075195314632000
Thu Jun 15 1995 00:00:00 GMT+0000 (Coordinated Universal Time)0.60317500757336210.60317500757336210.58977111851617630.5931218862533569896000

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