Baselight
Sign In

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Mrk
@kaggle.rprkh15_sp500_stock_prices.mrk

  • 722.08 KB
  • 15236 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Tue Jan 02 1962 00:00:00 GMT+0000 (Coordinated Universal Time)0.07169865145128990.07100068014482370.0713995993137359633830
Wed Jan 03 1962 00:00:00 GMT+0000 (Coordinated Universal Time)0.07139959637117710.06780969535185630.06840798258781436564672
Thu Jan 04 1962 00:00:00 GMT+0000 (Coordinated Universal Time)0.06900626313492530.06741077504711630.06771000474691391199750
Fri Jan 05 1962 00:00:00 GMT+0000 (Coordinated Universal Time)0.06741072693663110.065017402329310.0654163211584091520646
Mon Jan 08 1962 00:00:00 GMT+0000 (Coordinated Universal Time)0.06601461220081390.06521695741108370.06561569869518281380845
Tue Jan 09 1962 00:00:00 GMT+0000 (Coordinated Universal Time)0.06671283456341550.0658153118903490.06591499596834181177114
Wed Jan 10 1962 00:00:00 GMT+0000 (Coordinated Universal Time)0.06741077465413830.0661143332882030.0670118555426597882835
Thu Jan 11 1962 00:00:00 GMT+0000 (Coordinated Universal Time)0.06741078744477580.06641358096960790.0672114193439483588557
Fri Jan 12 1962 00:00:00 GMT+0000 (Coordinated Universal Time)0.0678096883836910.06701185554265970.0670118555426597407462
Mon Jan 15 1962 00:00:00 GMT+0000 (Coordinated Universal Time)0.06741080297741040.06621422812570310.0664135962724685792288

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