Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Evrg
@kaggle.rprkh15_sp500_stock_prices.evrg

  • 477.21 KB
  • 12457 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Wed Feb 21 1973 00:00:00 GMT+0000 (Coordinated Universal Time)1.8738968275380481.84725374468205651.856134772300723000
Thu Feb 22 1973 00:00:00 GMT+0000 (Coordinated Universal Time)1.84725301622768481.82949096799472691.8383719921112061200
Fri Feb 23 1973 00:00:00 GMT+0000 (Coordinated Universal Time)1.82949062149123361.793966531753541.793966531753545000
Mon Feb 26 1973 00:00:00 GMT+0000 (Coordinated Universal Time)1.82949166995723081.81172961490910241.82061064243316653000
Tue Feb 27 1973 00:00:00 GMT+0000 (Coordinated Universal Time)1.82061064243316651.8028485873850381.82061064243316652800
Wed Feb 28 1973 00:00:00 GMT+0000 (Coordinated Universal Time)1.82024860382080081.80222634041663431.820248603820800824000.185
Thu Mar 01 1973 00:00:00 GMT+0000 (Coordinated Universal Time)1.82024822662125761.8112370967864991.8112370967864991200
Fri Mar 02 1973 00:00:00 GMT+0000 (Coordinated Universal Time)1.80222721874411331.77519381046295171.77519381046295173200
Mon Mar 05 1973 00:00:00 GMT+0000 (Coordinated Universal Time)1.7932158564076281.76618245153716111.78420472145080578600
Tue Mar 06 1973 00:00:00 GMT+0000 (Coordinated Universal Time)1.78420472145080571.76618245153716111.78420472145080571800

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