Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Jkhy
@kaggle.rprkh15_sp500_stock_prices.jkhy

  • 393.84 KB
  • 9234 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Wed Nov 20 1985 00:00:00 GMT+0000 (Coordinated Universal Time)0.25255706898711360.24796541035175320.24796541035175325373000
Thu Nov 21 1985 00:00:00 GMT+0000 (Coordinated Universal Time)0.24337354462223590.23418958485126490.23418958485126496557400
Fri Nov 22 1985 00:00:00 GMT+0000 (Coordinated Universal Time)0.24337372064506080.23878139257431020.2387813925743103415800
Mon Nov 25 1985 00:00:00 GMT+0000 (Coordinated Universal Time)0.23878121987293920.23418958485126490.2341895848512649626400
Tue Nov 26 1985 00:00:00 GMT+0000 (Coordinated Universal Time)0.23878121987293920.23418958485126490.2341895848512649505800
Wed Nov 27 1985 00:00:00 GMT+0000 (Coordinated Universal Time)0.23878121987293920.23418958485126490.2341895848512649295200
Fri Nov 29 1985 00:00:00 GMT+0000 (Coordinated Universal Time)0.23878121987293920.23418958485126490.2341895848512649338400
Mon Dec 02 1985 00:00:00 GMT+0000 (Coordinated Universal Time)0.2341897311005430.22500574588775630.2250057458877563219600
Tue Dec 03 1985 00:00:00 GMT+0000 (Coordinated Universal Time)0.22959740348338090.22500574588775630.2250057458877563813600
Wed Dec 04 1985 00:00:00 GMT+0000 (Coordinated Universal Time)0.22959740348338090.22500574588775630.2250057458877563248400

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