Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Gs
@kaggle.rprkh15_sp500_stock_prices.gs

  • 301.54 KB
  • 5836 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Tue May 04 1999 00:00:00 GMT+0000 (Coordinated Universal Time)57.5067028093083958.4525367370930752.9666999559419453.25045013427734422320900
Wed May 05 1999 00:00:00 GMT+0000 (Coordinated Universal Time)52.8721616375942252.8721616375942250.1292409086313752.304660797119147565700
Thu May 06 1999 00:00:00 GMT+0000 (Coordinated Universal Time)51.45338531185315452.4938030295560650.7440095952375351.406093597412112905700
Fri May 07 1999 00:00:00 GMT+0000 (Coordinated Universal Time)51.4060772353842956.6554558675164550.507534947001356.087955474853524862300
Mon May 10 1999 00:00:00 GMT+0000 (Coordinated Universal Time)55.520446919003655.6150303038741353.1558622972402453.486904144287112589400
Tue May 11 1999 00:00:00 GMT+0000 (Coordinated Universal Time)52.96671909568584653.8652616517733752.5883853878595253.439636230468751839800
Wed May 12 1999 00:00:00 GMT+0000 (Coordinated Universal Time)53.7233607493290356.655445578957952.3046100253150655.6150283813476562659300
Thu May 13 1999 00:00:00 GMT+0000 (Coordinated Universal Time)55.425866065933456.939200292989654.8583657307873255.378574371337891142900
Fri May 14 1999 00:00:00 GMT+0000 (Coordinated Universal Time)53.9125559697274454.6692234219341352.2573459180252753.108596801757812058400
Mon May 17 1999 00:00:00 GMT+0000 (Coordinated Universal Time)52.30464143179804653.1558923773426851.4533904862534151.9263076782226562075000

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