Baselight
Sign In

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Mdt
@kaggle.rprkh15_sp500_stock_prices.mdt

  • 560.85 KB
  • 12408 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Wed May 02 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.20073495805263520.20073495805263520.2007349580526352947200
Thu May 03 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.20519543918948990.20073495805263520.20073495805263521497600
Fri May 04 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.21969323980022820.215232178568840.215232178568842316800
Mon May 07 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.21634718633859510.21188668906688690.2118866890668869793600
Tue May 08 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.21857809611823950.21411703526973720.21411703526973721331200
Wed May 09 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.21634718633859510.21188668906688690.21188668906688691049600
Thu May 10 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.21411703373608090.20965655148029320.20965655148029321292800
Fri May 11 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.201850309751170.19738924503326410.19738924503326411100800
Mon May 14 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.18958267681011930.18512217700481410.18512217700481412355200
Tue May 15 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.19850419515231530.19404369592666620.19404369592666621395200

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