Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Mpwr
@kaggle.rprkh15_sp500_stock_prices.mpwr

  • 218.58 KB
  • 4440 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Fri Nov 19 2004 00:00:00 GMT+0000 (Coordinated Universal Time)7.969382502520338.734654196123917.4767933922776428.6554880142211913906200
Mon Nov 22 2004 00:00:00 GMT+0000 (Coordinated Universal Time)8.7082595448687199.6758443115755148.365207419791658.461965560913086728000
Tue Nov 23 2004 00:00:00 GMT+0000 (Coordinated Universal Time)8.3564119295505138.5763175066439487.7054916226835168.25085735321045505800
Wed Nov 24 2004 00:00:00 GMT+0000 (Coordinated Universal Time)8.3564110172594578.7962221234310088.3564110172594578.602705001831055319500
Fri Nov 26 2004 00:00:00 GMT+0000 (Coordinated Universal Time)8.1804899671089658.752244294953928.1365086713808678.62030124664306665600
Mon Nov 29 2004 00:00:00 GMT+0000 (Coordinated Universal Time)8.7962255906820198.8841881821382168.3212294423401288.620301246643066130700
Tue Nov 30 2004 00:00:00 GMT+0000 (Coordinated Universal Time)8.6202974458163328.7874252892456418.1892827832437838.690667152404785194900
Wed Dec 01 2004 00:00:00 GMT+0000 (Coordinated Universal Time)8.3564122045876798.9897405223461988.3564122045876798.787426948547363209800
Thu Dec 02 2004 00:00:00 GMT+0000 (Coordinated Universal Time)8.8226115326650879.67584540808038.7698346638445529.543902397155762337400
Fri Dec 03 2004 00:00:00 GMT+0000 (Coordinated Universal Time)9.6670483162933459.9837128628486149.306403328381539.798992156982422288100

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