Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Wec
@kaggle.rprkh15_sp500_stock_prices.wec

  • 463.68 KB
  • 10671 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Mon Mar 17 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.52144222938958520.51492411410864470.518183171749115183600
Tue Mar 18 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.52796065520913960.51492447154289140.524701595306396573800
Wed Mar 19 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.53447854518890380.52470142460617280.5344785451889038164700
Thu Mar 20 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.54751449823379520.53447854264934860.547514498233795287300
Fri Mar 21 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.55729156305976120.55403250455856320.5540325045585632104400
Mon Mar 24 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.55729162141802120.53447854518890380.5344785451889038129600
Tue Mar 25 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.53121965802126980.52470153891629120.5279605984687805299700
Wed Mar 26 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.53773760403138280.52796048344865180.5344785451889038114300
Thu Mar 27 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.53447824507108940.52796018699082790.531219244003295954000
Fri Mar 28 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.52796059846878050.51818347575603090.5279605984687805144000

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