Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Met
@kaggle.rprkh15_sp500_stock_prices.met

  • 287.61 KB
  • 5602 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Wed Apr 05 2000 00:00:00 GMT+0000 (Coordinated Universal Time)7.928814829296928.6123329657197687.8262870210678648.47562980651855577084766
Thu Apr 06 2000 00:00:00 GMT+0000 (Coordinated Universal Time)8.407280698407358.6806876918013328.3389282186783698.50980854034423817167722
Fri Apr 07 2000 00:00:00 GMT+0000 (Coordinated Universal Time)8.407280627587788.5098084686610158.2705768394901338.37310409545898415131516
Mon Apr 10 2000 00:00:00 GMT+0000 (Coordinated Universal Time)8.441456794738778.4756327426543828.3389283658875338.441456794738776324938
Tue Apr 11 2000 00:00:00 GMT+0000 (Coordinated Universal Time)8.3731046940232698.4072812285952268.2364014812575648.2705774307250986087860
Wed Apr 12 2000 00:00:00 GMT+0000 (Coordinated Universal Time)8.3389275167350659.159150183186558.2705762129684488.85156726837158212169885
Thu Apr 13 2000 00:00:00 GMT+0000 (Coordinated Universal Time)8.8857413852510159.4325570048643368.714861686966939.29585266113281211922484
Fri Apr 14 2000 00:00:00 GMT+0000 (Coordinated Universal Time)9.2616810578990489.2958570135574328.6465138560481618.68068981170654310659337
Mon Apr 17 2000 00:00:00 GMT+0000 (Coordinated Universal Time)8.7490395061425988.9882705340301298.7490395061425988.8173913955688483951908
Tue Apr 18 2000 00:00:00 GMT+0000 (Coordinated Universal Time)8.8515673402819738.9199186446038798.4756319484375998.8173913955688486083933

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