Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Ms
@kaggle.rprkh15_sp500_stock_prices.ms

  • 376.79 KB
  • 7400 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Tue Feb 23 1993 00:00:00 GMT+0000 (Coordinated Universal Time)4.0339983047977574.0970295283102223.8606624401384783.90793585777282740594800
Wed Feb 24 1993 00:00:00 GMT+0000 (Coordinated Universal Time)3.9709684484145224.0655153162339153.9236950145048254.0182418823242199426400
Thu Feb 25 1993 00:00:00 GMT+0000 (Coordinated Universal Time)4.0339982189894634.1127872467041024.0182404134465364.1127872467041025229200
Fri Feb 26 1993 00:00:00 GMT+0000 (Coordinated Universal Time)4.1127862822334724.1758174896240234.04975507484292054.1758174896240232761200
Mon Mar 01 1993 00:00:00 GMT+0000 (Coordinated Universal Time)4.1285448409616954.144302645698194.0339980125427254.0339980125427253014400
Tue Mar 02 1993 00:00:00 GMT+0000 (Coordinated Universal Time)4.0655142853015284.1600611291457494.04975647799415754.1443033218383793022800
Wed Mar 03 1993 00:00:00 GMT+0000 (Coordinated Universal Time)4.1285448074340824.191576025868194.0970291982170284.1285448074340822808800
Thu Mar 04 1993 00:00:00 GMT+0000 (Coordinated Universal Time)4.1127872467041024.1600606633328844.1127872467041024.1127872467041021783600
Fri Mar 05 1993 00:00:00 GMT+0000 (Coordinated Universal Time)4.0970301090326524.2073347658143014.0339988765859964.1915769577026373868800
Mon Mar 08 1993 00:00:00 GMT+0000 (Coordinated Universal Time)4.1600596877763864.1915752914716614.128544084081114.1758174896240232516000

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