Baselight

Risk Dashboard Data Under ESRB Responsibility - RDE

European Central Bank

@ecb.risk_dashboard_data_under_esrb_responsibility_rde

Table 1
@ecb.risk_dashboard_data_under_esrb_responsibility_rde.table_1

  • 84.97 KB
  • 5286 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

obs_pre_break

OBS PRE BREAK

obs_com

OBS COM

time_format

TIME FORMAT

breaks

BREAKS

collection

COLLECTION

compiling_org

COMPILING ORG

diss_org

DISS ORG

dom_ser_ids

DOM SER IDS

fm_contract_time

FM CONTRACT TIME

fm_coupon_rate

FM COUPON RATE

fm_identifier

FM IDENTIFIER

fm_lot_size

FM LOT SIZE

fm_maturity

FM MATURITY

fm_outs_amount

FM OUTS AMOUNT

fm_put_call

FM PUT CALL

fm_strike_price

FM STRIKE PRICE

publ_mu

PUBL MU

publ_public

PUBL PUBLIC

unit_index_base

UNIT INDEX BASE

compilation

COMPILATION

coverage

COVERAGE

decimals

DECIMALS

source_agency

SOURCE AGENCY

source_pub

SOURCE PUB

title

TITLE

title_compl

TITLE COMPL

unit

UNIT

unit_mult

UNIT MULT

RDE.D.D0.Z0Z.DE.EC.SRCB_COVAR.5PDD0Z0ZDEECSRCB_COVAR5PFri Jan 15 1999 00:00:00 GMT+0000 (Coordinated Universal Time)-0.093586AFP1DV64F0Individual bank contribution to overall systemic risk using CoVaR, 5th percentileEU (changing composition), 5th percentileUNITS
RDE.D.D0.Z0Z.DE.EC.SRCB_COVAR.5PDD0Z0ZDEECSRCB_COVAR5PFri Jan 22 1999 00:00:00 GMT+0000 (Coordinated Universal Time)-0.125901AFP1DV64F0Individual bank contribution to overall systemic risk using CoVaR, 5th percentileEU (changing composition), 5th percentileUNITS
RDE.D.D0.Z0Z.DE.EC.SRCB_COVAR.5PDD0Z0ZDEECSRCB_COVAR5PFri Jan 29 1999 00:00:00 GMT+0000 (Coordinated Universal Time)-0.12147AFP1DV64F0Individual bank contribution to overall systemic risk using CoVaR, 5th percentileEU (changing composition), 5th percentileUNITS
RDE.D.D0.Z0Z.DE.EC.SRCB_COVAR.5PDD0Z0ZDEECSRCB_COVAR5PFri Feb 05 1999 00:00:00 GMT+0000 (Coordinated Universal Time)-0.101802AFP1DV64F0Individual bank contribution to overall systemic risk using CoVaR, 5th percentileEU (changing composition), 5th percentileUNITS
RDE.D.D0.Z0Z.DE.EC.SRCB_COVAR.5PDD0Z0ZDEECSRCB_COVAR5PFri Feb 12 1999 00:00:00 GMT+0000 (Coordinated Universal Time)-0.105209AFP1DV64F0Individual bank contribution to overall systemic risk using CoVaR, 5th percentileEU (changing composition), 5th percentileUNITS
RDE.D.D0.Z0Z.DE.EC.SRCB_COVAR.5PDD0Z0ZDEECSRCB_COVAR5PFri Feb 19 1999 00:00:00 GMT+0000 (Coordinated Universal Time)-0.09589AFP1DV64F0Individual bank contribution to overall systemic risk using CoVaR, 5th percentileEU (changing composition), 5th percentileUNITS
RDE.D.D0.Z0Z.DE.EC.SRCB_COVAR.5PDD0Z0ZDEECSRCB_COVAR5PFri Feb 26 1999 00:00:00 GMT+0000 (Coordinated Universal Time)-0.092656AFP1DV64F0Individual bank contribution to overall systemic risk using CoVaR, 5th percentileEU (changing composition), 5th percentileUNITS
RDE.D.D0.Z0Z.DE.EC.SRCB_COVAR.5PDD0Z0ZDEECSRCB_COVAR5PFri Mar 05 1999 00:00:00 GMT+0000 (Coordinated Universal Time)-0.079774AFP1DV64F0Individual bank contribution to overall systemic risk using CoVaR, 5th percentileEU (changing composition), 5th percentileUNITS
RDE.D.D0.Z0Z.DE.EC.SRCB_COVAR.5PDD0Z0ZDEECSRCB_COVAR5PFri Mar 12 1999 00:00:00 GMT+0000 (Coordinated Universal Time)-0.074396AFP1DV64F0Individual bank contribution to overall systemic risk using CoVaR, 5th percentileEU (changing composition), 5th percentileUNITS
RDE.D.D0.Z0Z.DE.EC.SRCB_COVAR.5PDD0Z0ZDEECSRCB_COVAR5PFri Mar 19 1999 00:00:00 GMT+0000 (Coordinated Universal Time)-0.064357AFP1DV64F0Individual bank contribution to overall systemic risk using CoVaR, 5th percentileEU (changing composition), 5th percentileUNITS

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
);

Share link

Anyone who has the link will be able to view this.