Baselight
Sign In

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Vrsk
@kaggle.rprkh15_sp500_stock_prices.vrsk

  • 161.95 KB
  • 3212 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Wed Oct 07 2009 00:00:00 GMT+0000 (Coordinated Universal Time)26.38698156745802228.31225325521320725.8103770063049126.60198593139648463739500
Thu Oct 08 2009 00:00:00 GMT+0000 (Coordinated Universal Time)26.70949640906926.8169995526980625.89834090070307225.9960708618164066906700
Fri Oct 09 2009 00:00:00 GMT+0000 (Coordinated Universal Time)26.2208451561598926.8658602083884725.78106131871143725.800607681274413361300
Mon Oct 12 2009 00:00:00 GMT+0000 (Coordinated Universal Time)26.67040310770140427.26655227437316525.50742059114023525.6540145874023447177000
Tue Oct 13 2009 00:00:00 GMT+0000 (Coordinated Universal Time)26.06447578343566826.641080382061825.93742816558883726.572669982910163296000
Wed Oct 14 2009 00:00:00 GMT+0000 (Coordinated Universal Time)26.63131068174528727.5988333048463726.38698673053661327.354509353637693222400
Thu Oct 15 2009 00:00:00 GMT+0000 (Coordinated Universal Time)27.63792437077585628.14611674207486327.1199569542868927.66724205017093181300
Fri Oct 16 2009 00:00:00 GMT+0000 (Coordinated Universal Time)27.8040626905869827.9506566689819726.9244950921298927.9213371276855473974100
Mon Oct 19 2009 00:00:00 GMT+0000 (Coordinated Universal Time)27.8724773344665828.23407574530838826.87563514709472326.8756351470947271892100
Tue Oct 20 2009 00:00:00 GMT+0000 (Coordinated Universal Time)26.875635088989127.4620129546485426.729041088585227.422920227050783387000

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