Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Tel
@kaggle.rprkh15_sp500_stock_prices.tel

  • 194.47 KB
  • 3796 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Thu Jun 14 2007 00:00:00 GMT+0000 (Coordinated Universal Time)27.1005187006580928.75584645136529427.1005187006580928.455543518066406662600
Fri Jun 15 2007 00:00:00 GMT+0000 (Coordinated Universal Time)28.63867118286439628.63867118286439628.0160924678702728.418937683105471150000
Mon Jun 18 2007 00:00:00 GMT+0000 (Coordinated Universal Time)28.6020368411352728.63865860933948327.21039009094238327.210390090942383853600
Tue Jun 19 2007 00:00:00 GMT+0000 (Coordinated Universal Time)27.21039030768760427.6132353492664826.4413191989639526.880788803100582951000
Wed Jun 20 2007 00:00:00 GMT+0000 (Coordinated Universal Time)26.97601486852253726.97601486852253725.8773447547278426.331460952758791721800
Thu Jun 21 2007 00:00:00 GMT+0000 (Coordinated Universal Time)26.3680756619720926.88078880310058226.1849640254306226.880788803100582537700
Fri Jun 22 2007 00:00:00 GMT+0000 (Coordinated Universal Time)27.1005310802820928.93164804516601826.95404116427882728.5288028717041250300
Mon Jun 25 2007 00:00:00 GMT+0000 (Coordinated Universal Time)28.6386670252889629.29787022292993428.0160884006767528.74853515625203200
Tue Jun 26 2007 00:00:00 GMT+0000 (Coordinated Universal Time)28.7924843699195329.15138173295712728.71191477583193628.93164825439453119600
Wed Jun 27 2007 00:00:00 GMT+0000 (Coordinated Universal Time)28.93164775056659729.15138122530265428.56542436131891429.11475944519043270700

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