Name: Macro Economic Indicators Data
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Macro Economic Indicators Data

Stock market data used in the book, Irrational Exuberance [Princeton University Press 2000, Broadway Books 2001, 2nd ed., 2005].This data set consists of monthly stock price, dividends, and earnings data and the consumer price index (to allow conversion to real values), all starting January 1871. Monthly dividend and earnings data are computed from the S&P four-quarter totals for the quarter since 1926, with linear interpolation to monthly figures. Dividend and earnings data before 1926 are interpolated from annual data.

Tables

Ie Data

@kaggle.cid007_macro_economic_indicators_data.ie_data

170.05 KB
2450 rows
25 columns


CREATE TABLE ie_data (
  "date" DOUBLE,
  "s_p_comp" DOUBLE,
  "dividend" DOUBLE,
  "earnings" DOUBLE,
  "n__consumer_price_index_cpi" DOUBLE,
  "date_fraction" DOUBLE,
  "long_interest_rate_gs10" DOUBLE,
  "real_price" DOUBLE,
  "real_dividend" DOUBLE,
  "n__real_total_return_price" DOUBLE,
  "real_earnings" DOUBLE,
  "n__real_tr_scaled_earnings" DOUBLE,
  "cyclically_adjusted_price_earnings_ratio_p_e10_or_cape" DOUBLE,
  "unnamed_13" VARCHAR,
  "cyclically_adjusted_total_return_price_earnings_ratio__7f7a5dba" DOUBLE,
  "excess_cape_yield" VARCHAR,
  "monthly_total_bond_returns" DOUBLE,
  "real_total_bond_returns" DOUBLE,
  "n_10_year_annualized_stock_real_return" VARCHAR,
  "n_10_year_annualized_bonds_real_return" VARCHAR,
  "real_10_year_excess_annualized_returns" VARCHAR,
  "unnamed_21" VARCHAR,
  "unnamed_22" VARCHAR,
  "unnamed_23" VARCHAR,
  "unnamed_24" VARCHAR
);