Financial Market Data - Yield Curve - YC

European Central Bank

@ecb.financial_market_data_yield_curve_yc

Table List

1 table(138.47 MB)

Table 1

@ecb.financial_market_data_yield_curve_yc.table_1

138.47 MB
11400683 rows
40 columns

key KEY	freq FREQ	ref_area REF AREA	currency CURRENCY	provider_fm PROVIDER FM	instrument_fm INSTRUMENT FM	provider_fm_id PROVIDER FM ID	data_type_fm DATA TYPE FM	time_period TIME PERIOD	obs_value OBS VALUE	obs_status OBS STATUS	obs_conf OBS CONF	time_format TIME FORMAT	collection COLLECTION	decimals DECIMALS	title TITLE	title_compl TITLE COMPL	unit UNIT
YC.B.U2.EUR.4F.G_N_A.SV_C_YM.BETA0	B	U2	EUR	4F	G_N_A	SV_C_YM	BETA0	Mon Sep 06 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	5.410509637960575	A	F	P1D	E	6	Yield curve parameters, Beta 0 - Government bond, nominal, all issuers whose rating is triple A - Euro area (changing composition)	Euro area (changing composition) - Government bond, nominal, all issuers whose rating is triple A - Svensson model - continuous compounding - yield error minimisation - Yield curve parameters, Beta 0 - provided by ECB	PURE_NUMB
YC.B.U2.EUR.4F.G_N_A.SV_C_YM.BETA0	B	U2	EUR	4F	G_N_A	SV_C_YM	BETA0	Tue Sep 07 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	5.391885841067043	A	F	P1D	E	6	Yield curve parameters, Beta 0 - Government bond, nominal, all issuers whose rating is triple A - Euro area (changing composition)	Euro area (changing composition) - Government bond, nominal, all issuers whose rating is triple A - Svensson model - continuous compounding - yield error minimisation - Yield curve parameters, Beta 0 - provided by ECB	PURE_NUMB
YC.B.U2.EUR.4F.G_N_A.SV_C_YM.BETA0	B	U2	EUR	4F	G_N_A	SV_C_YM	BETA0	Wed Sep 08 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	5.385978435404216	A	F	P1D	E	6	Yield curve parameters, Beta 0 - Government bond, nominal, all issuers whose rating is triple A - Euro area (changing composition)	Euro area (changing composition) - Government bond, nominal, all issuers whose rating is triple A - Svensson model - continuous compounding - yield error minimisation - Yield curve parameters, Beta 0 - provided by ECB	PURE_NUMB
YC.B.U2.EUR.4F.G_N_A.SV_C_YM.BETA0	B	U2	EUR	4F	G_N_A	SV_C_YM	BETA0	Thu Sep 09 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	5.377333340400553	A	F	P1D	E	6	Yield curve parameters, Beta 0 - Government bond, nominal, all issuers whose rating is triple A - Euro area (changing composition)	Euro area (changing composition) - Government bond, nominal, all issuers whose rating is triple A - Svensson model - continuous compounding - yield error minimisation - Yield curve parameters, Beta 0 - provided by ECB	PURE_NUMB
YC.B.U2.EUR.4F.G_N_A.SV_C_YM.BETA0	B	U2	EUR	4F	G_N_A	SV_C_YM	BETA0	Fri Sep 10 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	5.355732362114095	A	F	P1D	E	6	Yield curve parameters, Beta 0 - Government bond, nominal, all issuers whose rating is triple A - Euro area (changing composition)	Euro area (changing composition) - Government bond, nominal, all issuers whose rating is triple A - Svensson model - continuous compounding - yield error minimisation - Yield curve parameters, Beta 0 - provided by ECB	PURE_NUMB
YC.B.U2.EUR.4F.G_N_A.SV_C_YM.BETA0	B	U2	EUR	4F	G_N_A	SV_C_YM	BETA0	Mon Sep 13 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	5.365401519510221	A	F	P1D	E	6	Yield curve parameters, Beta 0 - Government bond, nominal, all issuers whose rating is triple A - Euro area (changing composition)	Euro area (changing composition) - Government bond, nominal, all issuers whose rating is triple A - Svensson model - continuous compounding - yield error minimisation - Yield curve parameters, Beta 0 - provided by ECB	PURE_NUMB
YC.B.U2.EUR.4F.G_N_A.SV_C_YM.BETA0	B	U2	EUR	4F	G_N_A	SV_C_YM	BETA0	Tue Sep 14 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	5.367759029559646	A	F	P1D	E	6	Yield curve parameters, Beta 0 - Government bond, nominal, all issuers whose rating is triple A - Euro area (changing composition)	Euro area (changing composition) - Government bond, nominal, all issuers whose rating is triple A - Svensson model - continuous compounding - yield error minimisation - Yield curve parameters, Beta 0 - provided by ECB	PURE_NUMB
YC.B.U2.EUR.4F.G_N_A.SV_C_YM.BETA0	B	U2	EUR	4F	G_N_A	SV_C_YM	BETA0	Wed Sep 15 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	5.358261311810258	A	F	P1D	E	6	Yield curve parameters, Beta 0 - Government bond, nominal, all issuers whose rating is triple A - Euro area (changing composition)	Euro area (changing composition) - Government bond, nominal, all issuers whose rating is triple A - Svensson model - continuous compounding - yield error minimisation - Yield curve parameters, Beta 0 - provided by ECB	PURE_NUMB
YC.B.U2.EUR.4F.G_N_A.SV_C_YM.BETA0	B	U2	EUR	4F	G_N_A	SV_C_YM	BETA0	Thu Sep 16 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	5.3444748927498775	A	F	P1D	E	6	Yield curve parameters, Beta 0 - Government bond, nominal, all issuers whose rating is triple A - Euro area (changing composition)	Euro area (changing composition) - Government bond, nominal, all issuers whose rating is triple A - Svensson model - continuous compounding - yield error minimisation - Yield curve parameters, Beta 0 - provided by ECB	PURE_NUMB
YC.B.U2.EUR.4F.G_N_A.SV_C_YM.BETA0	B	U2	EUR	4F	G_N_A	SV_C_YM	BETA0	Fri Sep 17 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	5.3293815882986575	A	F	P1D	E	6	Yield curve parameters, Beta 0 - Government bond, nominal, all issuers whose rating is triple A - Euro area (changing composition)	Euro area (changing composition) - Government bond, nominal, all issuers whose rating is triple A - Svensson model - continuous compounding - yield error minimisation - Yield curve parameters, Beta 0 - provided by ECB	PURE_NUMB


CREATE TABLE table_1 (
  "key" VARCHAR,
  "freq" VARCHAR,
  "ref_area" VARCHAR,
  "currency" VARCHAR,
  "provider_fm" VARCHAR,
  "instrument_fm" VARCHAR,
  "provider_fm_id" VARCHAR,
  "data_type_fm" VARCHAR,
  "time_period" TIMESTAMP,
  "obs_value" DOUBLE,
  "obs_status" VARCHAR,
  "obs_conf" VARCHAR,
  "obs_pre_break" VARCHAR,
  "obs_com" VARCHAR,
  "time_format" VARCHAR,
  "breaks" VARCHAR,
  "collection" VARCHAR,
  "compiling_org" VARCHAR,
  "diss_org" VARCHAR,
  "dom_ser_ids" VARCHAR,
  "fm_contract_time" VARCHAR,
  "fm_coupon_rate" VARCHAR,
  "fm_identifier" VARCHAR,
  "fm_lot_size" VARCHAR,
  "fm_maturity" VARCHAR,
  "fm_outs_amount" VARCHAR,
  "fm_put_call" VARCHAR,
  "fm_strike_price" VARCHAR,
  "publ_mu" VARCHAR,
  "publ_public" VARCHAR,
  "unit_index_base" VARCHAR,
  "compilation" VARCHAR,
  "coverage" VARCHAR,
  "decimals" BIGINT,
  "source_agency" VARCHAR,
  "source_pub" VARCHAR,
  "title" VARCHAR,
  "title_compl" VARCHAR,
  "unit" VARCHAR,
  "unit_mult" BIGINT
);