Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Sbny
@kaggle.rprkh15_sp500_stock_prices.sbny

  • 227.74 KB
  • 4608 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Tue Mar 23 2004 00:00:00 GMT+0000 (Coordinated Universal Time)17.36283547221868818.40460617338606417.00619423394994818.273210525512695282200
Wed Mar 24 2004 00:00:00 GMT+0000 (Coordinated Universal Time)18.1418100414029618.30136043474602717.80393819900436718.25443458557129505000
Thu Mar 25 2004 00:00:00 GMT+0000 (Coordinated Universal Time)18.16058731079101618.2450553002915317.9259544044244818.160587310791016209700
Fri Mar 26 2004 00:00:00 GMT+0000 (Coordinated Universal Time)18.2544409333015318.2544409333015317.97288037002510218.19812774658203293200
Mon Mar 29 2004 00:00:00 GMT+0000 (Coordinated Universal Time)18.01980601381266618.3952182661615118.01980601381266618.05734634399414153600
Tue Mar 30 2004 00:00:00 GMT+0000 (Coordinated Universal Time)18.11365871059725718.41399031877021717.8320999536870718.282594680786133124100
Wed Mar 31 2004 00:00:00 GMT+0000 (Coordinated Universal Time)18.3952186879509619.66223663502360718.12304367994050519.652851104736328248400
Thu Apr 01 2004 00:00:00 GMT+0000 (Coordinated Universal Time)19.56838226074285520.36613439897108418.88325469089670220.2253532409668112200
Fri Apr 02 2004 00:00:00 GMT+0000 (Coordinated Universal Time)20.65707906192171720.65707906192171719.7185475377459319.99072074890136792300
Mon Apr 05 2004 00:00:00 GMT+0000 (Coordinated Universal Time)20.08457475730991220.08457475730991219.4276037481622619.65285110473632853900

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