Baselight
Sign In

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Exr
@kaggle.rprkh15_sp500_stock_prices.exr

  • 229.07 KB
  • 4508 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Mon Aug 16 2004 00:00:00 GMT+0000 (Coordinated Universal Time)5.9747562408447265.989095528188195.9747562408447265.974756240844727188800
Tue Aug 17 2004 00:00:00 GMT+0000 (Coordinated Universal Time)5.9747585244836625.9938777335284945.9747585244836625.979538440704346153600
Wed Aug 18 2004 00:00:00 GMT+0000 (Coordinated Universal Time)5.9747585244836626.0464554444423065.9747585244836625.979538440704346149800
Thu Aug 19 2004 00:00:00 GMT+0000 (Coordinated Universal Time)5.974757351531445.9986564721051275.974757351531445.989096641540527126900
Fri Aug 20 2004 00:00:00 GMT+0000 (Coordinated Universal Time)5.9890954904865876.0177745208307055.9747562032333895.998655319213867144900
Mon Aug 23 2004 00:00:00 GMT+0000 (Coordinated Universal Time)5.9986553192138676.0177745208307055.9747562032333895.99865531921386764400
Tue Aug 24 2004 00:00:00 GMT+0000 (Coordinated Universal Time)5.9986579084024346.2089692169638965.9986579084024346.204189300537109382900
Wed Aug 25 2004 00:00:00 GMT+0000 (Coordinated Universal Time)6.0942509541144746.2567643858248926.0942509541144746.213746070861816500200
Thu Aug 26 2004 00:00:00 GMT+0000 (Coordinated Universal Time)6.23764600494042656.4288380345217346.1898477696262226.395379543304443435200
Fri Aug 27 2004 00:00:00 GMT+0000 (Coordinated Universal Time)6.4049386594873476.5148744139572366.3141225630450366.428837776184082694300

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