Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Trow
@kaggle.rprkh15_sp500_stock_prices.trow

  • 427.28 KB
  • 9144 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Wed Apr 02 1986 00:00:00 GMT+0000 (Coordinated Universal Time)0.37996894676060380.37092174102822340.372731447219848640921600
Thu Apr 03 1986 00:00:00 GMT+0000 (Coordinated Universal Time)0.43786894933395290.37273145253780530.41977497935295120761600
Fri Apr 04 1986 00:00:00 GMT+0000 (Coordinated Universal Time)0.43424997864098380.41615645040190370.41977497935295110419200
Mon Apr 07 1986 00:00:00 GMT+0000 (Coordinated Universal Time)0.41977504575461670.40530004417687120.4125375449657446387200
Tue Apr 08 1986 00:00:00 GMT+0000 (Coordinated Universal Time)0.423393950045920.40168145111387090.4197749793529512768000
Wed Apr 09 1986 00:00:00 GMT+0000 (Coordinated Universal Time)0.43063144398986920.41977497379658580.42701247334480282454400
Thu Apr 10 1986 00:00:00 GMT+0000 (Coordinated Universal Time)0.45596233346769880.42701234404117820.44872483611106875267200
Fri Apr 11 1986 00:00:00 GMT+0000 (Coordinated Universal Time)0.46320012211799620.45234409012688560.46320012211799622464000
Mon Apr 14 1986 00:00:00 GMT+0000 (Coordinated Universal Time)0.48129406571388250.45958156143525690.48129406571388242601600
Tue Apr 15 1986 00:00:00 GMT+0000 (Coordinated Universal Time)0.48853160576612960.47405660176923780.4849126338958741648000

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