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

174.14 kB
2,450 rows
25 columns

CREATE TABLE ie_data (
  "date" DOUBLE,
  "s_p_comp" DOUBLE  -- S\u0026P Comp.,
  "dividend" DOUBLE,
  "earnings" DOUBLE,
  "n__consumer_price_index_cpi" DOUBLE  -- Consumer Price Index CPI,
  "date_fraction" DOUBLE,
  "long_interest_rate_gs10" DOUBLE,
  "real_price" DOUBLE,
  "real_dividend" DOUBLE,
  "n__real_total_return_price" DOUBLE  -- Real Total Return Price,
  "real_earnings" DOUBLE,
  "n__real_tr_scaled_earnings" DOUBLE  -- Real TR Scaled Earnings,
  "cyclically_adjusted_price_earnings_ratio_p_e10_or_cape" DOUBLE,
  "unnamed_13" VARCHAR  -- Unnamed: 13,
  "cyclically_adjusted_total_return_price_earnings_ratio__7f7a5dba" DOUBLE  -- Cyclically Adjusted Total Return Price Earnings Ratio TR P/E10 Or TR CAPE,
  "excess_cape_yield" VARCHAR,
  "monthly_total_bond_returns" DOUBLE,
  "real_total_bond_returns" DOUBLE,
  "n_10_year_annualized_stock_real_return" VARCHAR  -- 10 Year Annualized Stock Real Return,
  "n_10_year_annualized_bonds_real_return" VARCHAR  -- 10 Year Annualized Bonds Real Return,
  "real_10_year_excess_annualized_returns" VARCHAR,
  "unnamed_21" VARCHAR  -- Unnamed: 21,
  "unnamed_22" VARCHAR  -- Unnamed: 22,
  "unnamed_23" VARCHAR  -- Unnamed: 23,
  "unnamed_24" VARCHAR  -- Unnamed: 24
);