Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Bkng
@kaggle.rprkh15_sp500_stock_prices.bkng

  • 239.84 KB
  • 5859 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Wed Mar 31 1999 00:00:00 GMT+0000 (Coordinated Universal Time)451.5517.5438497.251322933
Thu Apr 01 1999 00:00:00 GMT+0000 (Coordinated Universal Time)550.5552475.5483483233
Mon Apr 05 1999 00:00:00 GMT+0000 (Coordinated Universal Time)501504435450.75324917
Tue Apr 06 1999 00:00:00 GMT+0000 (Coordinated Universal Time)452.25484.125420474353900
Wed Apr 07 1999 00:00:00 GMT+0000 (Coordinated Universal Time)480.75487.5442.5447156617
Thu Apr 08 1999 00:00:00 GMT+0000 (Coordinated Universal Time)447450.75423.75435147767
Fri Apr 09 1999 00:00:00 GMT+0000 (Coordinated Universal Time)432456406.5444141933
Mon Apr 12 1999 00:00:00 GMT+0000 (Coordinated Universal Time)420.75475.5414459.375182833
Tue Apr 13 1999 00:00:00 GMT+0000 (Coordinated Universal Time)472.5515.25463.5489240033
Wed Apr 14 1999 00:00:00 GMT+0000 (Coordinated Universal Time)554.25595.5510558.75627933

CREATE TABLE bkng (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "dividends" BIGINT,
  "stock_splits" DOUBLE
);

Share link

Anyone who has the link will be able to view this.