Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Vrsn
@kaggle.rprkh15_sp500_stock_prices.vrsn

  • 292.7 KB
  • 6152 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Fri Jan 30 1998 00:00:00 GMT+0000 (Coordinated Universal Time)4.4049712676627975.5725540133083574.3518993246789075.413338184356689518256800
Mon Feb 02 1998 00:00:00 GMT+0000 (Coordinated Universal Time)5.8113775503250857.9077192237300255.6256257564790786.58092069625854510127200
Tue Feb 03 1998 00:00:00 GMT+0000 (Coordinated Universal Time)7.0054965019226077.4566080190918676.7932087291370747.0054965019226076244800
Wed Feb 04 1998 00:00:00 GMT+0000 (Coordinated Universal Time)6.9789608401272147.0320327856795136.4747773573803816.7136011123657232106800
Thu Feb 05 1998 00:00:00 GMT+0000 (Coordinated Universal Time)6.8462803378426957.0054961596529916.47477675361867366.488044738769531890800
Fri Feb 06 1998 00:00:00 GMT+0000 (Coordinated Universal Time)6.5145813435182456.5543853028472775.83791403492475.9175219535827642846800
Mon Feb 09 1998 00:00:00 GMT+0000 (Coordinated Universal Time)5.8379139282085275.9440578178123195.439874342194315.7317700386047361944800
Tue Feb 10 1998 00:00:00 GMT+0000 (Coordinated Universal Time)5.6786977563585556.2624891144888745.5460179022380285.9440574645996091001200
Wed Feb 11 1998 00:00:00 GMT+0000 (Coordinated Universal Time)5.970593660819436.3155612945556645.86444977351597356.315561294555664842400
Thu Feb 12 1998 00:00:00 GMT+0000 (Coordinated Universal Time)6.2890254905424926.7136010510854456.1828816004067546.6074571609497071111600

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

Share link

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