Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Frt
@kaggle.rprkh15_sp500_stock_prices.frt

  • 476.79 KB
  • 12407 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Thu May 03 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.57034719145896680.59121355018066460.56339168548583980.5633916854858398300
Fri May 04 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.57034748792648320.59816920788539830.57034748792648320.5703474879264832600
Mon May 07 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.57034748792648320.59816920788539830.57034748792648320.57034748792648321500
Tue May 08 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.57730281352996830.60512469149207530.57730281352996830.5773028135299683300
Wed May 09 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.57730281352996830.60512469149207530.57730281352996830.57730281352996839300
Thu May 10 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.57730281352996830.60512469149207530.57730281352996830.5773028135299683600
Fri May 11 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.5773028383173290.59816920788539830.57034748792648320.5703474879264832300
Mon May 14 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.57034755962220170.58425842135032860.55643653869628910.5564365386962891600
Tue May 15 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.55643653869628910.58425842135032860.55643653869628910.5564365386962891300
Wed May 16 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.56339168548583980.59121355018066460.56339168548583980.5633916854858398300

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