Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Ess
@kaggle.rprkh15_sp500_stock_prices.ess

  • 332.57 KB
  • 7075 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Tue Jun 07 1994 00:00:00 GMT+0000 (Coordinated Universal Time)6.0613082885742196.2197738647460936.0613082885742196.1405410766601561595400
Wed Jun 08 1994 00:00:00 GMT+0000 (Coordinated Universal Time)6.14053848501923756.14053848501923756.0613057303738286.100922107696533162400
Thu Jun 09 1994 00:00:00 GMT+0000 (Coordinated Universal Time)6.1009221076965336.1009221076965336.0613057303738286.10092210769653376200
Fri Jun 10 1994 00:00:00 GMT+0000 (Coordinated Universal Time)6.1009238187004536.1009238187004536.0216910418342146.061307430267334110500
Mon Jun 13 1994 00:00:00 GMT+0000 (Coordinated Universal Time)6.0613074302673346.0613074302673346.0216910418342146.06130743026733451200
Tue Jun 14 1994 00:00:00 GMT+0000 (Coordinated Universal Time)6.0613057303738286.1009221076965336.0613057303738286.10092210769653328100
Wed Jun 15 1994 00:00:00 GMT+0000 (Coordinated Universal Time)6.1009221076965336.1801548623419436.0613057303738286.10092210769653396700
Thu Jun 16 1994 00:00:00 GMT+0000 (Coordinated Universal Time)6.1009238187004536.1009238187004536.0613074302673346.06130743026733419800
Fri Jun 17 1994 00:00:00 GMT+0000 (Coordinated Universal Time)6.0613067526566356.1009231366609276.0216903686523446.02169036865234456000
Mon Jun 20 1994 00:00:00 GMT+0000 (Coordinated Universal Time)6.0216910418342146.0613074302673346.0216910418342146.06130743026733443500

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