Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Wrk
@kaggle.rprkh15_sp500_stock_prices.wrk

  • 93.21 KB
  • 1775 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Wed Jun 24 2015 00:00:00 GMT+0000 (Coordinated Universal Time)45.8741072192482545.8741072192482545.823497772216845.82349777221683663
Thu Jun 25 2015 00:00:00 GMT+0000 (Coordinated Universal Time)45.4764753001726145.4764753001726144.7534790039062544.753479003906254107
Fri Jun 26 2015 00:00:00 GMT+0000 (Coordinated Universal Time)44.7534790039062544.7534790039062544.7534790039062544.75347900390625111
Mon Jun 29 2015 00:00:00 GMT+0000 (Coordinated Universal Time)44.0449330939011744.0449330939011743.9581718444824243.95817184448242333
Tue Jun 30 2015 00:00:00 GMT+0000 (Coordinated Universal Time)44.3413665603540944.39197602182604643.6183703178888344.030479431152342015023
Wed Jul 01 2015 00:00:00 GMT+0000 (Coordinated Universal Time)43.91479871341914545.1149711608886743.83526781241242545.11497116088867213545
Thu Jul 02 2015 00:00:00 GMT+0000 (Coordinated Universal Time)45.5487677779298546.9947601142656445.1149676281350846.987529754638671936776
Mon Jul 06 2015 00:00:00 GMT+0000 (Coordinated Universal Time)47.0815229430575348.0069600885433845.54154190218450546.091018676757812322244
Tue Jul 07 2015 00:00:00 GMT+0000 (Coordinated Universal Time)46.2066982911131346.26453811266990444.4931977865306445.165584564208983388636
Wed Jul 08 2015 00:00:00 GMT+0000 (Coordinated Universal Time)45.1872689667214946.1994642323769943.01828042365297543.1701087951660164200195

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