Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Aes
@kaggle.rprkh15_sp500_stock_prices.aes

  • 368.42 KB
  • 7820 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Wed Jun 26 1991 00:00:00 GMT+0000 (Coordinated Universal Time)2.24684497157630372.4219234498754642.24684497157630372.363564014434814516683528
Thu Jun 27 1991 00:00:00 GMT+0000 (Coordinated Universal Time)2.4219235447761792.4802829825035852.34897390366248042.3927438259124766160224
Fri Jun 28 1991 00:00:00 GMT+0000 (Coordinated Universal Time)2.39274451272241742.4511039672012382.3343850582435972.3781549930572512384862
Mon Jul 01 1991 00:00:00 GMT+0000 (Coordinated Universal Time)2.4219235447761792.4219235447761792.36356410704877232.3927438259124761782930
Tue Jul 02 1991 00:00:00 GMT+0000 (Coordinated Universal Time)2.4219241142272952.4219241142272952.3927443885027542.4219241142272951271226
Wed Jul 03 1991 00:00:00 GMT+0000 (Coordinated Universal Time)2.3927438259124762.4219235447761792.33438438818506852.3927438259124761214988
Fri Jul 05 1991 00:00:00 GMT+0000 (Coordinated Universal Time)2.3927437160276492.3927437160276492.3052043914794922.305204391479492230514
Mon Jul 08 1991 00:00:00 GMT+0000 (Coordinated Universal Time)2.3052043914794922.3927437160276492.3052043914794922.305204391479492550020
Tue Jul 09 1991 00:00:00 GMT+0000 (Coordinated Universal Time)2.34897439259150162.50946339567863272.30520497716274872.4802834987640383100506
Wed Jul 10 1991 00:00:00 GMT+0000 (Coordinated Universal Time)2.5094629973853182.6845421791076662.5094629973853182.6845421791076661238472

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

Share link

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