Baselight
Sign In

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Xray
@kaggle.rprkh15_sp500_stock_prices.xray

  • 393.87 KB
  • 8799 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Wed Aug 12 1987 00:00:00 GMT+0000 (Coordinated Universal Time)0.58239450459219020.5563171505928040.556317150592804783600
Thu Aug 13 1987 00:00:00 GMT+0000 (Coordinated Universal Time)0.61716364338186080.59977900981903080.5997790098190308543600
Fri Aug 14 1987 00:00:00 GMT+0000 (Coordinated Universal Time)0.61716364338186080.59977900981903080.5997790098190308348000
Mon Aug 17 1987 00:00:00 GMT+0000 (Coordinated Universal Time)0.63454910061052620.60847175121307370.608471751213073790000
Tue Aug 18 1987 00:00:00 GMT+0000 (Coordinated Universal Time)0.62585626668650310.5910862088203430.591086208820343415200
Wed Aug 19 1987 00:00:00 GMT+0000 (Coordinated Universal Time)0.60847174374918140.57370167970657350.5737016797065735158400
Thu Aug 20 1987 00:00:00 GMT+0000 (Coordinated Universal Time)0.60847174374918140.57370167970657350.573701679706573576800
Fri Aug 21 1987 00:00:00 GMT+0000 (Coordinated Universal Time)0.5997790287841450.57370167970657350.573701679706573544400
Mon Aug 24 1987 00:00:00 GMT+0000 (Coordinated Universal Time)0.59977905600206470.58239442110061650.582394421100616526400
Tue Aug 25 1987 00:00:00 GMT+0000 (Coordinated Universal Time)0.59977905600206470.58239442110061650.582394421100616533600

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