Baselight
Sign In

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Mhk
@kaggle.rprkh15_sp500_stock_prices.mhk

  • 270.53 KB
  • 7626 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Wed Apr 01 1992 00:00:00 GMT+0000 (Coordinated Universal Time)6.666666984558105576.66666698455810556.8333330154418954215825
Thu Apr 02 1992 00:00:00 GMT+0000 (Coordinated Universal Time)6.83333301544189576.7777781486511236.777778148651123439875
Fri Apr 03 1992 00:00:00 GMT+0000 (Coordinated Universal Time)6.7777781486511236.8888888359069826.7777781486511236.777778148651123553275
Mon Apr 06 1992 00:00:00 GMT+0000 (Coordinated Universal Time)6.7777781486511236.8888888359069826.7777781486511236.777778148651123389250
Tue Apr 07 1992 00:00:00 GMT+0000 (Coordinated Universal Time)6.77777814865112376.7777781486511236.777778148651123497250
Wed Apr 08 1992 00:00:00 GMT+0000 (Coordinated Universal Time)6.7777781486511236.7777781486511236.4444441795349126.444444179534912220950
Thu Apr 09 1992 00:00:00 GMT+0000 (Coordinated Universal Time)6.4444441795349126.7777781486511236.4444441795349126.777778148651123284850
Fri Apr 10 1992 00:00:00 GMT+0000 (Coordinated Universal Time)6.66666698455810556.7777781486511236.5555558204650886.777778148651123114300
Mon Apr 13 1992 00:00:00 GMT+0000 (Coordinated Universal Time)6.66666698455810556.7777781486511236.66666698455810556.72222185134887738475
Tue Apr 14 1992 00:00:00 GMT+0000 (Coordinated Universal Time)6.66666698455810556.8888888359069826.66666698455810556.888888835906982263250

CREATE TABLE mhk (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "dividends" BIGINT,
  "stock_splits" DOUBLE
);