Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Fast
@kaggle.rprkh15_sp500_stock_prices.fast

  • 404.23 KB
  • 8793 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Thu Aug 20 1987 00:00:00 GMT+0000 (Coordinated Universal Time)0.04300496022948480.04171489179134360.041714891791343666969600
Fri Aug 21 1987 00:00:00 GMT+0000 (Coordinated Universal Time)0.04214491060121520.0412848666310310.04128486663103117932800
Mon Aug 24 1987 00:00:00 GMT+0000 (Coordinated Universal Time)0.04257493577625790.04171489179134360.04171489179134368889600
Tue Aug 25 1987 00:00:00 GMT+0000 (Coordinated Universal Time)0.04515507600664520.04386500269174570.043865002691745720774400
Wed Aug 26 1987 00:00:00 GMT+0000 (Coordinated Universal Time)0.04558510393402120.0442950353026390.04429503530263925593600
Thu Aug 27 1987 00:00:00 GMT+0000 (Coordinated Universal Time)0.04558509319827310.04472504928708070.04472504928708072630400
Fri Aug 28 1987 00:00:00 GMT+0000 (Coordinated Universal Time)0.04644580151726860.04472504928708070.04472504928708077180800
Mon Aug 31 1987 00:00:00 GMT+0000 (Coordinated Universal Time)0.04601511761463890.04472504928708070.04472504928708074435200
Tue Sep 01 1987 00:00:00 GMT+0000 (Coordinated Universal Time)0.04601511761463890.04472504928708070.04472504928708073321600
Wed Sep 02 1987 00:00:00 GMT+0000 (Coordinated Universal Time)0.04515508034269840.04257493838667860.04257493838667867372800

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