Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Zbra
@kaggle.rprkh15_sp500_stock_prices.zbra

  • 272.13 KB
  • 7785 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Thu Aug 15 1991 00:00:00 GMT+0000 (Coordinated Universal Time)3.88888907432556154.16666698455810553.88888907432556154.05555582046508810640250
Fri Aug 16 1991 00:00:00 GMT+0000 (Coordinated Universal Time)44.1111111640930183.94444394111633342114550
Mon Aug 19 1991 00:00:00 GMT+0000 (Coordinated Universal Time)3.7222220897674563.83333301544189543.5555560588836673.7777779102325441482750
Tue Aug 20 1991 00:00:00 GMT+0000 (Coordinated Universal Time)3.83333301544189543.83333301544189543.7222220897674563.7222220897674561048500
Wed Aug 21 1991 00:00:00 GMT+0000 (Coordinated Universal Time)3.7777779102325444.0555558204650883.77777791023254441281150
Thu Aug 22 1991 00:00:00 GMT+0000 (Coordinated Universal Time)4.0555558204650884.11111116409301844.111111164093018790650
Fri Aug 23 1991 00:00:00 GMT+0000 (Coordinated Universal Time)4.1111111640930184.166666984558105544.111111164093018800100
Mon Aug 26 1991 00:00:00 GMT+0000 (Coordinated Universal Time)4.0555558204650884.19444417953491244526050
Tue Aug 27 1991 00:00:00 GMT+0000 (Coordinated Universal Time)4.0833330154418954.11111116409301844168750
Wed Aug 28 1991 00:00:00 GMT+0000 (Coordinated Universal Time)4.0555558204650884.111111164093018441263150

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

Share link

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