Baselight
Sign In

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Mpc
@kaggle.rprkh15_sp500_stock_prices.mpc

  • 145.3 KB
  • 2780 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Fri Jun 24 2011 00:00:00 GMT+0000 (Coordinated Universal Time)13.81761307684367213.96024704625636513.1365385254018413.2827377319335941675400
Mon Jun 27 2011 00:00:00 GMT+0000 (Coordinated Universal Time)13.08304992905234313.53234596274081813.04739211823948413.425371170043944895200
Tue Jun 28 2011 00:00:00 GMT+0000 (Coordinated Universal Time)13.6714124657592814.25977582881732913.4431992263514713.7997827529907244151800
Wed Jun 29 2011 00:00:00 GMT+0000 (Coordinated Universal Time)13.90675628396884614.60922620333909313.79978150768224214.2883005142211913695200
Thu Jun 30 2011 00:00:00 GMT+0000 (Coordinated Universal Time)14.50225550615316714.97651238458928614.32753029007777314.762562751770023025600
Fri Jul 01 2011 00:00:00 GMT+0000 (Coordinated Universal Time)14.69124133858673516.91275651138763814.61992436232861615.047824859619148334200
Tue Jul 05 2011 00:00:00 GMT+0000 (Coordinated Universal Time)15.05139064788818415.33309196628895614.85170473935759515.05139064788818411823000
Wed Jul 06 2011 00:00:00 GMT+0000 (Coordinated Universal Time)14.8338843859022515.06566438203724814.62349990580189614.93729400634765610983000
Thu Jul 07 2011 00:00:00 GMT+0000 (Coordinated Universal Time)15.0442600047878315.42580430765463514.87310005810295414.8980607986450216707600
Fri Jul 08 2011 00:00:00 GMT+0000 (Coordinated Universal Time)14.54861605958753615.19046650804923514.44877304945720414.76613235473632816417000

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