Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Wy
@kaggle.rprkh15_sp500_stock_prices.wy

  • 585.43 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)1.41199820822547741.44948488885093841.38388319775638171.430741548538208116700
Fri May 04 1973 00:00:00 GMT+0000 (Coordinated Universal Time)1.46822824737471461.49634325819253291.46822824737471461.4744762182235718256800
Mon May 07 1973 00:00:00 GMT+0000 (Coordinated Universal Time)1.47447607195942171.47759977107330781.46510440261646061.46822810173034755800
Tue May 08 1973 00:00:00 GMT+0000 (Coordinated Universal Time)1.4682281017303471.4682281017303471.45573273327349951.46822810173034780100
Wed May 09 1973 00:00:00 GMT+0000 (Coordinated Universal Time)1.46822824737471461.48384788849617771.46510454795096571.474476218223571866900
Thu May 10 1973 00:00:00 GMT+0000 (Coordinated Universal Time)1.4744764037402671.4744764037402671.4557330608367921.45573306083679261800
Fri May 11 1973 00:00:00 GMT+0000 (Coordinated Universal Time)1.4557326449523041.4557326449523041.4182459698548251.436989307403564576500
Mon May 14 1973 00:00:00 GMT+0000 (Coordinated Universal Time)1.4182455393049941.4182455393049941.399502207446341.415121555328369146200
Tue May 15 1973 00:00:00 GMT+0000 (Coordinated Universal Time)1.41512219361115781.4307415485382081.39950283868410751.43074154853820890300
Wed May 16 1973 00:00:00 GMT+0000 (Coordinated Universal Time)1.43074166117209891.44636130332946781.43074166117209891.446361303329467839900

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