Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Blk
@kaggle.rprkh15_sp500_stock_prices.blk

  • 286.24 KB
  • 5731 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Fri Oct 01 1999 00:00:00 GMT+0000 (Coordinated Universal Time)9.1363892681830759.2995390765434879.1363892681830759.217964172363283162400
Mon Oct 04 1999 00:00:00 GMT+0000 (Coordinated Universal Time)9.2179617541176929.2179617541176929.136386871337899.13638687133789533400
Tue Oct 05 1999 00:00:00 GMT+0000 (Coordinated Universal Time)9.1363892681830759.217964172363289.1363892681830759.21796417236328270600
Wed Oct 06 1999 00:00:00 GMT+0000 (Coordinated Universal Time)9.217961527720229.707410812377939.217961527720229.70741081237793205400
Thu Oct 07 1999 00:00:00 GMT+0000 (Coordinated Universal Time)9.7074135974445189.7074135974445189.1771767202731769.21796417236328214200
Fri Oct 08 1999 00:00:00 GMT+0000 (Coordinated Universal Time)9.258752339680999.258752339680999.177177429199229.1771774291992265600
Mon Oct 11 1999 00:00:00 GMT+0000 (Coordinated Universal Time)9.177177429199229.2179648844401049.1363899739583349.1771774291992277500
Tue Oct 12 1999 00:00:00 GMT+0000 (Coordinated Universal Time)9.1771767202731769.217964172363289.1363892681830759.2179641723632849200
Wed Oct 13 1999 00:00:00 GMT+0000 (Coordinated Universal Time)9.2179648844401049.3811147054036499.1363899739583349.1771774291992249900
Thu Oct 14 1999 00:00:00 GMT+0000 (Coordinated Universal Time)9.1363852964628739.1771727308220848.6469360841523628.891660690307617430900

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