Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Foxa
@kaggle.rprkh15_sp500_stock_prices.foxa

  • 46.56 KB
  • 841 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Tue Mar 12 2019 00:00:00 GMT+0000 (Coordinated Universal Time)36.2765655517578136.2765655517578136.2765655517578136.2765655517578110000
Wed Mar 13 2019 00:00:00 GMT+0000 (Coordinated Universal Time)37.2312083694170138.090391557693736.94481518722041437.9471931457519520477400
Thu Mar 14 2019 00:00:00 GMT+0000 (Coordinated Universal Time)37.9471979290089139.5223660921710137.9471979290089138.806381225585946248600
Fri Mar 15 2019 00:00:00 GMT+0000 (Coordinated Universal Time)39.5032787794848239.97105359133118439.36962883324300639.808765411376957107300
Mon Mar 18 2019 00:00:00 GMT+0000 (Coordinated Universal Time)40.04742707014817440.04742707014817439.1882436418966239.808765411376954020900
Tue Mar 19 2019 00:00:00 GMT+0000 (Coordinated Universal Time)39.6655661726483539.80876462174581638.0331213330388438.5104446411132810118500
Wed Mar 20 2019 00:00:00 GMT+0000 (Coordinated Universal Time)38.653641904235138.9591285206947436.5056870838039336.8684501647949215683200
Thu Mar 21 2019 00:00:00 GMT+0000 (Coordinated Universal Time)37.2312124017122138.2526838352447236.9925507837525238.2049522399902412751700
Fri Mar 22 2019 00:00:00 GMT+0000 (Coordinated Universal Time)38.1190382674726638.1763183733354435.9806283238691636.9639167785644510898000
Mon Mar 25 2019 00:00:00 GMT+0000 (Coordinated Universal Time)37.1262045015350437.19302947005845535.69423464742581635.7419662475585949338900

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