Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Acn
@kaggle.rprkh15_sp500_stock_prices.acn

  • 268.92 KB
  • 5278 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Thu Jul 19 2001 00:00:00 GMT+0000 (Coordinated Universal Time)11.13864978427058711.27880466715688711.06488361212852411.19028568267822434994300
Fri Jul 20 2001 00:00:00 GMT+0000 (Coordinated Universal Time)11.10176814230042711.10176814230042710.91735339144323211.0722618103027349238500
Mon Jul 23 2001 00:00:00 GMT+0000 (Coordinated Universal Time)11.06488513946533211.07226189839505510.73293872597866511.0648851394653327501000
Tue Jul 24 2001 00:00:00 GMT+0000 (Coordinated Universal Time)11.02800308472429211.04275660397029110.84358831506841310.9616136550903323537300
Wed Jul 25 2001 00:00:00 GMT+0000 (Coordinated Universal Time)10.84358703735230711.0280017852783210.80670394706981511.028001785278324208100
Thu Jul 26 2001 00:00:00 GMT+0000 (Coordinated Universal Time)11.02800181887323611.05750815049182710.6960554122924810.696055412292486335300
Fri Jul 27 2001 00:00:00 GMT+0000 (Coordinated Universal Time)10.70343399047851610.76244666374689310.69605723044832910.7034339904785163524000
Mon Jul 30 2001 00:00:00 GMT+0000 (Coordinated Universal Time)10.69605432492281210.90259862525548410.69605432492281210.8435859680175783654300
Tue Jul 31 2001 00:00:00 GMT+0000 (Coordinated Universal Time)10.85096464739614911.07226250296611510.76982240519796711.035379409790041429000
Wed Aug 01 2001 00:00:00 GMT+0000 (Coordinated Universal Time)11.06488350898988811.4337129592895510.99111733753541611.433712959289552087900

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