Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Pool
@kaggle.rprkh15_sp500_stock_prices.pool

  • 318.49 KB
  • 6732 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Fri Oct 13 1995 00:00:00 GMT+0000 (Coordinated Universal Time)0.70383411645889280.75410748130827830.70383411645889280.70383411645889286328631
Mon Oct 16 1995 00:00:00 GMT+0000 (Coordinated Universal Time)0.73734947789119080.73734947789119080.70383414279195230.7122131586074829993263
Tue Oct 17 1995 00:00:00 GMT+0000 (Coordinated Universal Time)0.70383411645889280.73734945030419750.70383411645889280.7038341164588928276792
Wed Oct 18 1995 00:00:00 GMT+0000 (Coordinated Universal Time)0.67031788825988770.70383394195846750.65355981590043060.67031788825988775322839
Thu Oct 19 1995 00:00:00 GMT+0000 (Coordinated Universal Time)0.67869693040847780.6870759441877410.67031791662921460.67869693040847781140202
Fri Oct 20 1995 00:00:00 GMT+0000 (Coordinated Universal Time)0.6870760854548120.73734945030419750.67031805445073130.7038341164588928681159
Mon Oct 23 1995 00:00:00 GMT+0000 (Coordinated Universal Time)0.70383390852296990.70383390852296990.68707588246976690.6954548954963684961369
Tue Oct 24 1995 00:00:00 GMT+0000 (Coordinated Universal Time)0.69545498668230010.72059207456816780.68707597255706790.6870759725570679419175
Wed Oct 25 1995 00:00:00 GMT+0000 (Coordinated Universal Time)0.72059207456816780.72059207456816780.68707597255706790.6870759725570679613955
Thu Oct 26 1995 00:00:00 GMT+0000 (Coordinated Universal Time)0.6870759441877410.72059204481496310.67869693040847780.6786969304084778199336

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