Dataset: Crash 1929, 1987, 2008 Vs. 2020

About this Dataset

Crash 1929, 1987, 2008 Vs. 2020

Context

Due to the current situation of the markets, I have decided to analyse the current crash (covid-19 coronavirus) with previous historical crashes (2008, 1987, 1929)

Content

S&P500 data has been obtained through Yahoo's rest api service.
DOW historical data has been obtained throught Macrotrends ( https://www.macrotrends.net/ )

Acknowledgements

We wouldn't be here without the help of others. If you owe any attributions or thanks, include them here along with any citations of past research.

Inspiration

Your data will be in front of the world's largest data science community. What questions do you want to see answered?

Tables

Dow 1929

@kaggle.cristiangarrido_sp_500_daily_crash_1987_vs_crash_2020.dow_1929

14.12 KB
846 rows
2 columns


CREATE TABLE dow_1929 (
  "date" TIMESTAMP,
  "n__value" DOUBLE
);

Sp500–1987

@kaggle.cristiangarrido_sp_500_daily_crash_1987_vs_crash_2020.sp500_1987

8.31 KB
64 rows
7 columns


CREATE TABLE sp500_1987 (
  "date" TIMESTAMP,
  "high" DOUBLE,
  "low" DOUBLE,
  "open" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "adj_close" DOUBLE
);

Sp500–2008

@kaggle.cristiangarrido_sp_500_daily_crash_1987_vs_crash_2020.sp500_2008

9.47 KB
85 rows
7 columns


CREATE TABLE sp500_2008 (
  "date" TIMESTAMP,
  "high" DOUBLE,
  "low" DOUBLE,
  "open" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "adj_close" DOUBLE
);

Sp500–2020

@kaggle.cristiangarrido_sp_500_daily_crash_1987_vs_crash_2020.sp500_2020

9.54 KB
87 rows
7 columns


CREATE TABLE sp500_2020 (
  "date" TIMESTAMP,
  "high" DOUBLE,
  "low" DOUBLE,
  "open" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "adj_close" DOUBLE
);