EDHEC Investment Management Datasets

date Date	world_equities World Equities	us_treasuries US Treasuries	bond_risk_premium Bond Risk Premium	inflation_protection Inflation Protection	currency_protection Currency Protection	regime_5 Regime-5	regime_7 Regime-7	us_equities US Equities	real_estate Real Estate	commodities Commodities	corp_bonds Corp Bonds
Tue Jan 01 1985 00:00:00 GMT+0000 (Coordinated Universal Time)	0.028511	0.0315	0.006408	-0.016265	0.030292	1	1	0.081301	0.056605	0.021351	0.048963
Fri Feb 01 1985 00:00:00 GMT+0000 (Coordinated Universal Time)	-0.009204	-0.044692	0.057381	0.006362	0.010258	1	1	0.030075	0.016448	-0.015217	-0.042029
Fri Mar 01 1985 00:00:00 GMT+0000 (Coordinated Universal Time)	0.075134	0.028719	-0.024396	-0.002848	-0.020739	1	1	-0.007299	-0.006716	0.037171	0.032666
Mon Apr 01 1985 00:00:00 GMT+0000 (Coordinated Universal Time)	-0.002459	0.023084	-0.004869	0.003089	0.008187	1	1	-0.012255	0.000906	-0.035116	0.037125
Wed May 01 1985 00:00:00 GMT+0000 (Coordinated Universal Time)	0.040245	0.08678	-0.044417	0.004077	-0.002219	1	1	0.064516	0.027241	0.004351	0.104199
Sat Jun 01 1985 00:00:00 GMT+0000 (Coordinated Universal Time)	0.022419	0.014284	-0.001572	0.02761	-0.017278	1	1	0.020979	0.023207	-0.046275	0.012482
Mon Jul 01 1985 00:00:00 GMT+0000 (Coordinated Universal Time)	0.04848	-0.014958	0.023357	-0.010178	0.000007	1	1	0.004566	0.009221	-0.00624	-0.006449
Thu Aug 01 1985 00:00:00 GMT+0000 (Coordinated Universal Time)	0.027709	0.021934	-0.001815	0.016312	0.011122	1	1	-0.009091	-0.054684	0.014064	0.037397
Sun Sep 01 1985 00:00:00 GMT+0000 (Coordinated Universal Time)	0.048713	0.002172	0.007427	-0.004868	-0.034424	1	1	-0.027523	-0.031145	0.060092	0.000941
Tue Oct 01 1985 00:00:00 GMT+0000 (Coordinated Universal Time)	0.058439	0.033903	-0.03134	0.026578	-0.007977	1	1	0.037736	0.031415	0.075345	0.03784


CREATE TABLE data_oct2018_v2 (
  "date" TIMESTAMP,
  "world_equities" DOUBLE,
  "us_treasuries" DOUBLE,
  "bond_risk_premium" DOUBLE,
  "inflation_protection" DOUBLE,
  "currency_protection" DOUBLE,
  "regime_5" BIGINT,
  "regime_7" BIGINT,
  "us_equities" DOUBLE,
  "real_estate" DOUBLE,
  "commodities" DOUBLE,
  "corp_bonds" DOUBLE
);