Baselight
Sign In

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

El
@kaggle.rprkh15_sp500_stock_prices.el

  • 337.87 KB
  • 6707 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Fri Nov 17 1995 00:00:00 GMT+0000 (Coordinated Universal Time)6.2422455912050996.69840969210085656.2182369543158496.626383781433105535659200
Mon Nov 20 1995 00:00:00 GMT+0000 (Coordinated Universal Time)6.6023749516422596.770435404956796.2902626812009896.3862972259521488434000
Tue Nov 21 1995 00:00:00 GMT+0000 (Coordinated Universal Time)6.3382793733443336.3622880073342746.0981930334449276.2662534713745126440000
Wed Nov 22 1995 00:00:00 GMT+0000 (Coordinated Universal Time)6.2422443588427016.5543565767848356.2422443588427016.4583220481872563480800
Fri Nov 24 1995 00:00:00 GMT+0000 (Coordinated Universal Time)6.5063404660925646.6984095573425296.4823318296863186.6984095573425291279200
Mon Nov 27 1995 00:00:00 GMT+0000 (Coordinated Universal Time)6.698409671442856.8424614923340946.6263837609972286.7224183082580572403200
Tue Nov 28 1995 00:00:00 GMT+0000 (Coordinated Universal Time)6.72241832899010656.74642696587935656.5303492338761046.62638378143310551054800
Wed Nov 29 1995 00:00:00 GMT+0000 (Coordinated Universal Time)6.602375124182026.8904787659645086.5783664873668136.7224183082580571331200
Thu Nov 30 1995 00:00:00 GMT+0000 (Coordinated Universal Time)6.79444451184616857.0585395282076816.77043587399512256.9865136146545412426000
Fri Dec 01 1995 00:00:00 GMT+0000 (Coordinated Universal Time)6.9865142355362587.0105228755209196.8664710356129546.914488315582275978400

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