Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Nrg
@kaggle.rprkh15_sp500_stock_prices.nrg

  • 238.03 KB
  • 4684 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Tue Dec 02 2003 00:00:00 GMT+0000 (Coordinated Universal Time)7.82702740755948157.9300146102905277.82702740755948157.930014610290527160000
Wed Dec 03 2003 00:00:00 GMT+0000 (Coordinated Universal Time)8.0330028533935558.0330028533935558.0330028533935558.033002853393555300000
Thu Dec 04 2003 00:00:00 GMT+0000 (Coordinated Universal Time)8.3419637680053718.3419637680053718.3419637680053718.34196376800537150000
Fri Dec 05 2003 00:00:00 GMT+0000 (Coordinated Universal Time)8.3419637680053718.3419637680053718.3419637680053718.341963768005371
Mon Dec 08 2003 00:00:00 GMT+0000 (Coordinated Universal Time)8.6509252653533268.9804840087890628.6509252653533268.980484008789062954000
Tue Dec 09 2003 00:00:00 GMT+0000 (Coordinated Universal Time)8.9804843367222069.371836046356598.9804843367222069.1164274215698243014200
Wed Dec 10 2003 00:00:00 GMT+0000 (Coordinated Universal Time)9.1658602714538559.4748218536376969.1658602714538559.2688474655151372994600
Thu Dec 11 2003 00:00:00 GMT+0000 (Coordinated Universal Time)9.371833072426369.4748202490464279.3223988819276129.433625221252442203200
Fri Dec 12 2003 00:00:00 GMT+0000 (Coordinated Universal Time)9.4748226664483689.4954197927356029.441866792950799.454225540161133709000
Mon Dec 15 2003 00:00:00 GMT+0000 (Coordinated Universal Time)9.4336259655607499.4336259655607499.2276515960693369.2276515960693361287000

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