Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Gnrc
@kaggle.rprkh15_sp500_stock_prices.gnrc

  • 138.27 KB
  • 3125 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Thu Feb 11 2010 00:00:00 GMT+0000 (Coordinated Universal Time)8.5660568003662588.7307886619117638.1707000812961738.4606285095214849627100
Fri Feb 12 2010 00:00:00 GMT+0000 (Coordinated Universal Time)8.4079152466348528.8362178802490238.4079152466348528.836217880249023884000
Tue Feb 16 2010 00:00:00 GMT+0000 (Coordinated Universal Time)8.8296277898722188.8428066408205488.506753482464558.7769136428833166900
Wed Feb 17 2010 00:00:00 GMT+0000 (Coordinated Universal Time)8.7110216220799569.2249848899986878.6978427706040328.7637357711792400400
Thu Feb 18 2010 00:00:00 GMT+0000 (Coordinated Universal Time)8.6319503177631178.6648961893405868.4672184462668918.585824966430664402300
Fri Feb 19 2010 00:00:00 GMT+0000 (Coordinated Universal Time)8.56605733867918.7176103591918958.5001643385591418.717610359191895325600
Mon Feb 22 2010 00:00:00 GMT+0000 (Coordinated Universal Time)8.7505573963962049.0273070084444788.6055937926774028.625361442565918189900
Tue Feb 23 2010 00:00:00 GMT+0000 (Coordinated Universal Time)8.5990043933548778.7637362758773768.5726473172873688.6121826171875110000
Wed Feb 24 2010 00:00:00 GMT+0000 (Coordinated Universal Time)8.5660572919289128.5990037918090828.5133431434815268.59900379180908236800
Thu Feb 25 2010 00:00:00 GMT+0000 (Coordinated Universal Time)8.5660572278291138.6978425979614268.5594678022219448.697842597961426192600

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

Share link

Anyone who has the link will be able to view this.