Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Ce
@kaggle.rprkh15_sp500_stock_prices.ce

  • 225.85 KB
  • 4398 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Fri Jan 21 2005 00:00:00 GMT+0000 (Coordinated Universal Time)12.75325775146484412.91267408148087312.35471844673156712.75325775146484422145000
Mon Jan 24 2005 00:00:00 GMT+0000 (Coordinated Universal Time)12.79311107381545112.81702397940989612.75325775146484412.7532577514648443509900
Tue Jan 25 2005 00:00:00 GMT+0000 (Coordinated Universal Time)12.7532513591839812.76122232372019612.3547122542094812.4742736816406232995500
Wed Jan 26 2005 00:00:00 GMT+0000 (Coordinated Universal Time)12.3945704816875412.45833669909859212.35471640576731112.4264535903930661467500
Thu Jan 27 2005 00:00:00 GMT+0000 (Coordinated Universal Time)12.42645439309137412.63369499314083212.03588609618123712.577898979187012858000
Fri Jan 28 2005 00:00:00 GMT+0000 (Coordinated Universal Time)12.59384218160221312.76919968852780612.5779002445392512.753257751464844697300
Mon Jan 31 2005 00:00:00 GMT+0000 (Coordinated Universal Time)12.7931110988952712.9604983977709312.76919971356074912.8568773269653321641900
Tue Feb 01 2005 00:00:00 GMT+0000 (Coordinated Universal Time)12.8568771710422412.9764401774920412.75325762180009512.912673950195312838100
Wed Feb 02 2005 00:00:00 GMT+0000 (Coordinated Universal Time)12.9126739501953113.02426446788789212.88079007639355612.912673950195312759200
Thu Feb 03 2005 00:00:00 GMT+0000 (Coordinated Universal Time)12.9206424035416812.9206424035416812.74528567205358912.76122760772705729500

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