Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Ups
@kaggle.rprkh15_sp500_stock_prices.ups

  • 292.48 KB
  • 5703 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Wed Nov 10 1999 00:00:00 GMT+0000 (Coordinated Universal Time)36.9647616431826739.9859200467120236.6804173228504938.812999725341880793700
Thu Nov 11 1999 00:00:00 GMT+0000 (Coordinated Universal Time)39.0973558425903343.7534954929351839.0973558425903342.6516609191894528309000
Fri Nov 12 1999 00:00:00 GMT+0000 (Coordinated Universal Time)43.2203399441766443.5757703713491439.3816913307135940.09255218505859414768100
Mon Nov 15 1999 00:00:00 GMT+0000 (Coordinated Universal Time)40.0925696829090940.3058280322862738.27987371320309539.239536285400398675100
Tue Nov 16 1999 00:00:00 GMT+0000 (Coordinated Universal Time)38.5997383811257138.6708244554924236.9647586706912937.5334472656256978600
Wed Nov 17 1999 00:00:00 GMT+0000 (Coordinated Universal Time)37.2846510438927938.7774588073279637.0358497499869238.493114471435555806900
Thu Nov 18 1999 00:00:00 GMT+0000 (Coordinated Universal Time)38.6353010776242939.2039899619315537.6045524748173937.7111816406254718700
Fri Nov 19 1999 00:00:00 GMT+0000 (Coordinated Universal Time)37.711206439825237.711206439825236.5382848446185836.964801788330085091100
Mon Nov 22 1999 00:00:00 GMT+0000 (Coordinated Universal Time)36.4316251962491836.5382543431650334.69001579662360535.898479461669924785400
Tue Nov 23 1999 00:00:00 GMT+0000 (Coordinated Universal Time)36.0406353872153338.10213129693770635.96954932136283437.640071868896482832200

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

Share link

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