Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Gild
@kaggle.rprkh15_sp500_stock_prices.gild

  • 365.77 KB
  • 7675 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Wed Jan 22 1992 00:00:00 GMT+0000 (Coordinated Universal Time)0.42440671212969940.53512140866369640.42440671212969940.4982165098190307168022400
Thu Jan 23 1992 00:00:00 GMT+0000 (Coordinated Universal Time)0.51666854186491530.55972462910300570.49821646935718240.541271805763244638368000
Fri Jan 24 1992 00:00:00 GMT+0000 (Coordinated Universal Time)0.54742318391799930.57202645621021760.52897035428269350.547423183917999312044800
Mon Jan 27 1992 00:00:00 GMT+0000 (Coordinated Universal Time)0.57202634504058860.59047842025756840.54742307752985650.590478420257568410716800
Tue Jan 28 1992 00:00:00 GMT+0000 (Coordinated Universal Time)0.5843279285969750.59662956129552110.55972466319988290.57817673683166519913600
Wed Jan 29 1992 00:00:00 GMT+0000 (Coordinated Universal Time)0.55972458357527330.57817665458212350.53512132167816160.535121321678161613238400
Thu Jan 30 1992 00:00:00 GMT+0000 (Coordinated Universal Time)0.54127198610550320.54742317954556850.47976380586624140.479763805866241410848000
Fri Jan 31 1992 00:00:00 GMT+0000 (Coordinated Universal Time)0.49206542403224420.51051825284957890.47976378843143810.51051825284957892496000
Mon Feb 03 1992 00:00:00 GMT+0000 (Coordinated Universal Time)0.5166686279017750.5166686279017750.49821655232135970.50436699390411382320000
Tue Feb 04 1992 00:00:00 GMT+0000 (Coordinated Universal Time)0.510518059781050.53512132167816160.510518059781050.53512132167816162499200

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