Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Crm
@kaggle.rprkh15_sp500_stock_prices.crm

  • 195.42 KB
  • 4545 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Wed Jun 23 2004 00:00:00 GMT+0000 (Coordinated Universal Time)3.754.3249998092651373.68754.30000019073486343574400
Thu Jun 24 2004 00:00:00 GMT+0000 (Coordinated Universal Time)4.3874998092651374.4225001335144044.1254.1900000572204598887200
Fri Jun 25 2004 00:00:00 GMT+0000 (Coordinated Universal Time)4.1275000572204594.18753.9474999904632573.9500000476837166710000
Mon Jun 28 2004 00:00:00 GMT+0000 (Coordinated Universal Time)44.0524997711181643.85999989509582542270800
Tue Jun 29 2004 00:00:00 GMT+0000 (Coordinated Universal Time)44.1750001907348633.95749998092651374.0999999046325682112000
Wed Jun 30 2004 00:00:00 GMT+0000 (Coordinated Universal Time)4.0999999046325684.2350001335144044.0075001716613774.0174999237060552087600
Thu Jul 01 2004 00:00:00 GMT+0000 (Coordinated Universal Time)4.0199999809265144.0500001907348633.9749999046325684.0075001716613771754800
Fri Jul 02 2004 00:00:00 GMT+0000 (Coordinated Universal Time)4.0250000953674324.2449998855590824.0124998092651374.244999885559082993200
Tue Jul 06 2004 00:00:00 GMT+0000 (Coordinated Universal Time)4.2325000762939454.254.1199998855590824.251216800
Wed Jul 07 2004 00:00:00 GMT+0000 (Coordinated Universal Time)4.2249999046325684.2249999046325684.0124998092651374.0774998664855961787600

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

Share link

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