Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Tsn
@kaggle.rprkh15_sp500_stock_prices.tsn

  • 463.19 KB
  • 10671 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Mon Mar 17 1980 00:00:00 GMT+0000 (Coordinated Universal Time)1.57796585426268641.42016935348510741.420169353485107410800
Tue Mar 18 1980 00:00:00 GMT+0000 (Coordinated Universal Time)1.57796585426268641.42016935348510741.42016935348510748100
Wed Mar 19 1980 00:00:00 GMT+0000 (Coordinated Universal Time)1.57796585426268641.42016935348510741.42016935348510743150
Thu Mar 20 1980 00:00:00 GMT+0000 (Coordinated Universal Time)1.57796585426268641.42016935348510741.42016935348510749900
Fri Mar 21 1980 00:00:00 GMT+0000 (Coordinated Universal Time)1.49906718539401231.34127080440521241.34127080440521249900
Mon Mar 24 1980 00:00:00 GMT+0000 (Coordinated Universal Time)1.4596187562658611.30182158946990971.301821589469909724300
Tue Mar 25 1980 00:00:00 GMT+0000 (Coordinated Universal Time)1.4596187562658611.30182158946990971.301821589469909721150
Wed Mar 26 1980 00:00:00 GMT+0000 (Coordinated Universal Time)1.4596187562658611.30182158946990971.3018215894699097900
Thu Mar 27 1980 00:00:00 GMT+0000 (Coordinated Universal Time)1.38071886772187341.22292256355285641.222922563552856422950
Fri Mar 28 1980 00:00:00 GMT+0000 (Coordinated Universal Time)1.4201688544213161.26237249374389651.26237249374389656750

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