Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Are
@kaggle.rprkh15_sp500_stock_prices.are

  • 310.69 KB
  • 6323 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Wed May 28 1997 00:00:00 GMT+0000 (Coordinated Universal Time)8.4728835310254778.780988386699138.4728835310254778.6269359588623051862700
Thu May 29 1997 00:00:00 GMT+0000 (Coordinated Universal Time)8.6269371969658048.7809896469116218.6269371969658048.780989646911621296800
Fri May 30 1997 00:00:00 GMT+0000 (Coordinated Universal Time)8.6782906055450449.0890972614288318.6782906055450449.03774642944336220400
Mon Jun 02 1997 00:00:00 GMT+0000 (Coordinated Universal Time)9.0890972614288319.1404480934143088.8323431015014659.0377464294433666800
Tue Jun 03 1997 00:00:00 GMT+0000 (Coordinated Universal Time)8.9350407810534479.0890932083129888.8836899719669329.089093208312988180000
Wed Jun 04 1997 00:00:00 GMT+0000 (Coordinated Universal Time)9.140448335920069.140448335920068.9350450025285988.98639583587646599900
Thu Jun 05 1997 00:00:00 GMT+0000 (Coordinated Universal Time)8.8323433358328678.9863958358764658.7296416691371388.986395835876465291600
Fri Jun 06 1997 00:00:00 GMT+0000 (Coordinated Universal Time)8.8323450088500988.8323450088500988.8323450088500988.832345008850098
Mon Jun 09 1997 00:00:00 GMT+0000 (Coordinated Universal Time)8.8323450088500988.8323450088500988.8323450088500988.832345008850098
Tue Jun 10 1997 00:00:00 GMT+0000 (Coordinated Universal Time)8.8323369738699378.9350385665893558.8323369738699378.93503856658935557600

CREATE TABLE are (
  "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.