Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Dg
@kaggle.rprkh15_sp500_stock_prices.dg

  • 163.63 KB
  • 3185 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Fri Nov 13 2009 00:00:00 GMT+0000 (Coordinated Universal Time)20.34392441898030821.36112099268347520.11274345967371221.01897239685058222079100
Mon Nov 16 2009 00:00:00 GMT+0000 (Coordinated Universal Time)21.1761709760312921.3611164093017620.4641333508414821.361116409301762080000
Tue Nov 17 2009 00:00:00 GMT+0000 (Coordinated Universal Time)21.29638609685523721.42584684224748420.80628193194540621.3056335449218751328000
Wed Nov 18 2009 00:00:00 GMT+0000 (Coordinated Universal Time)21.26865027547866721.28714517728410320.80628831296826320.852523803710938918300
Thu Nov 19 2009 00:00:00 GMT+0000 (Coordinated Universal Time)20.59359906295760521.39810776615320.59359906295760521.148433685302731031500
Fri Nov 20 2009 00:00:00 GMT+0000 (Coordinated Universal Time)20.8062879066038521.57380867882995520.8062879066038521.4628410339355471080900
Mon Nov 23 2009 00:00:00 GMT+0000 (Coordinated Universal Time)21.9159488546422122.17487031999626321.4350921850272421.63853073120117741100
Tue Nov 24 2009 00:00:00 GMT+0000 (Coordinated Universal Time)21.8234812591391821.8697167419919221.4998275878581621.73100852966309633100
Wed Nov 25 2009 00:00:00 GMT+0000 (Coordinated Universal Time)21.26864652241893722.00842482638613621.2593990731480221.95294189453125362600
Fri Nov 27 2009 00:00:00 GMT+0000 (Coordinated Universal Time)21.02821776031766321.54606256392466821.02821776031766321.4073543548584141400

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