Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Bkr
@kaggle.rprkh15_sp500_stock_prices.bkr

  • 437.08 KB
  • 8888 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Mon Apr 06 1987 00:00:00 GMT+0000 (Coordinated Universal Time)6.9016262540881266.67459907467733256.76540994644165157000
Tue Apr 07 1987 00:00:00 GMT+0000 (Coordinated Universal Time)6.7654067410363086.7654067410363086.5383796691894536.538379669189453295600
Wed Apr 08 1987 00:00:00 GMT+0000 (Coordinated Universal Time)6.629197769165046.8562250900268566.629197769165046.810819625854492479700
Thu Apr 09 1987 00:00:00 GMT+0000 (Coordinated Universal Time)6.8108156844452546.8108156844452546.4929776191711436.492977619171143850800
Fri Apr 10 1987 00:00:00 GMT+0000 (Coordinated Universal Time)6.492978931295466.6291952725114496.492978931295466.583789825439453224000
Mon Apr 13 1987 00:00:00 GMT+0000 (Coordinated Universal Time)6.5837881074729546.5837881074729546.3567609313531986.402166366577148304700
Tue Apr 14 1987 00:00:00 GMT+0000 (Coordinated Universal Time)6.3567641354346476.3567641354346475.7664931800014295.857304096221924168300
Wed Apr 15 1987 00:00:00 GMT+0000 (Coordinated Universal Time)5.9481129510062086.3567619323730475.9481129510062086.356761932373047414500
Thu Apr 16 1987 00:00:00 GMT+0000 (Coordinated Universal Time)6.447568840450716.5837850835588246.447568840450716.538379669189453229400
Mon Apr 20 1987 00:00:00 GMT+0000 (Coordinated Universal Time)6.5383831077898056.5383831077898056.4475722312927256.447572231292725135800

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