Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Pnw
@kaggle.rprkh15_sp500_stock_prices.pnw

  • 477.72 KB
  • 12457 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Wed Feb 21 1973 00:00:00 GMT+0000 (Coordinated Universal Time)5.0467713265445644.9352404684993814.9910058975219734300
Thu Feb 22 1973 00:00:00 GMT+0000 (Coordinated Universal Time)5.0188884735107424.9352403322855645.0188884735107424000
Fri Feb 23 1973 00:00:00 GMT+0000 (Coordinated Universal Time)5.0188861109993674.9073553085327154.9073553085327153500
Mon Feb 26 1973 00:00:00 GMT+0000 (Coordinated Universal Time)4.9352419934953974.8515938241141194.8794765472412112200
Tue Feb 27 1973 00:00:00 GMT+0000 (Coordinated Universal Time)4.8794760260471084.7958278656005864.7958278656005866400
Wed Feb 28 1973 00:00:00 GMT+0000 (Coordinated Universal Time)4.8515926813114594.79582724819293654.8237099647521972200
Thu Mar 01 1973 00:00:00 GMT+0000 (Coordinated Universal Time)4.8794753978707214.79582724819293654.8237099647521976200
Fri Mar 02 1973 00:00:00 GMT+0000 (Coordinated Universal Time)4.8794766952251564.8237112472797264.8515939712524413100
Mon Mar 05 1973 00:00:00 GMT+0000 (Coordinated Universal Time)4.9073591577001364.5727664878569454.628531932830810527800
Tue Mar 06 1973 00:00:00 GMT+0000 (Coordinated Universal Time)4.7121794694911944.6564140319824224.6564140319824227900

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