Foreign Exchange Intervention - FXI

European Central Bank

@ecb.foreign_exchange_intervention_fxi

Table List

1 table(268.69 KB)

Table 1

@ecb.foreign_exchange_intervention_fxi.table_1

268.69 KB
106656 rows
25 columns

key KEY	freq FREQ	ref_area REF AREA	fxs_op_type FXS OP TYPE	data_type_fxs DATA TYPE FXS	market_trans MARKET TRANS	currency_p_h CURRENCY P H	currency_s CURRENCY S	series_denom SERIES DENOM	time_period TIME PERIOD	obs_status OBS STATUS	obs_conf OBS CONF	time_format TIME FORMAT	collection COLLECTION	title_compl TITLE COMPL	unit UNIT	unit_mult UNIT MULT
FXI.D.4F.21.200.A.EUR.JPY.E	D	4F	21	200	A	EUR	JPY	E	Fri Sep 01 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	A	F	P1D	S	European Central Bank (ECB)- Unilateral intervention- Aggregate gross flows - all- CURRENCY PURCHASEDHELD Euro- CURRENCY SOLD Japanese yen- DENOMNATED IN Euro	EUR	6
FXI.D.4F.21.200.A.EUR.JPY.E	D	4F	21	200	A	EUR	JPY	E	Sat Sep 02 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	A	F	P1D	S	European Central Bank (ECB)- Unilateral intervention- Aggregate gross flows - all- CURRENCY PURCHASEDHELD Euro- CURRENCY SOLD Japanese yen- DENOMNATED IN Euro	EUR	6
FXI.D.4F.21.200.A.EUR.JPY.E	D	4F	21	200	A	EUR	JPY	E	Sun Sep 03 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	A	F	P1D	S	European Central Bank (ECB)- Unilateral intervention- Aggregate gross flows - all- CURRENCY PURCHASEDHELD Euro- CURRENCY SOLD Japanese yen- DENOMNATED IN Euro	EUR	6
FXI.D.4F.21.200.A.EUR.JPY.E	D	4F	21	200	A	EUR	JPY	E	Mon Sep 04 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	A	F	P1D	S	European Central Bank (ECB)- Unilateral intervention- Aggregate gross flows - all- CURRENCY PURCHASEDHELD Euro- CURRENCY SOLD Japanese yen- DENOMNATED IN Euro	EUR	6
FXI.D.4F.21.200.A.EUR.JPY.E	D	4F	21	200	A	EUR	JPY	E	Tue Sep 05 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	A	F	P1D	S	European Central Bank (ECB)- Unilateral intervention- Aggregate gross flows - all- CURRENCY PURCHASEDHELD Euro- CURRENCY SOLD Japanese yen- DENOMNATED IN Euro	EUR	6
FXI.D.4F.21.200.A.EUR.JPY.E	D	4F	21	200	A	EUR	JPY	E	Wed Sep 06 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	A	F	P1D	S	European Central Bank (ECB)- Unilateral intervention- Aggregate gross flows - all- CURRENCY PURCHASEDHELD Euro- CURRENCY SOLD Japanese yen- DENOMNATED IN Euro	EUR	6
FXI.D.4F.21.200.A.EUR.JPY.E	D	4F	21	200	A	EUR	JPY	E	Thu Sep 07 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	A	F	P1D	S	European Central Bank (ECB)- Unilateral intervention- Aggregate gross flows - all- CURRENCY PURCHASEDHELD Euro- CURRENCY SOLD Japanese yen- DENOMNATED IN Euro	EUR	6
FXI.D.4F.21.200.A.EUR.JPY.E	D	4F	21	200	A	EUR	JPY	E	Fri Sep 08 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	A	F	P1D	S	European Central Bank (ECB)- Unilateral intervention- Aggregate gross flows - all- CURRENCY PURCHASEDHELD Euro- CURRENCY SOLD Japanese yen- DENOMNATED IN Euro	EUR	6
FXI.D.4F.21.200.A.EUR.JPY.E	D	4F	21	200	A	EUR	JPY	E	Sat Sep 09 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	A	F	P1D	S	European Central Bank (ECB)- Unilateral intervention- Aggregate gross flows - all- CURRENCY PURCHASEDHELD Euro- CURRENCY SOLD Japanese yen- DENOMNATED IN Euro	EUR	6
FXI.D.4F.21.200.A.EUR.JPY.E	D	4F	21	200	A	EUR	JPY	E	Sun Sep 10 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	A	F	P1D	S	European Central Bank (ECB)- Unilateral intervention- Aggregate gross flows - all- CURRENCY PURCHASEDHELD Euro- CURRENCY SOLD Japanese yen- DENOMNATED IN Euro	EUR	6


CREATE TABLE table_1 (
  "key" VARCHAR,
  "freq" VARCHAR,
  "ref_area" VARCHAR,
  "fxs_op_type" BIGINT,
  "data_type_fxs" BIGINT,
  "market_trans" VARCHAR,
  "currency_p_h" VARCHAR,
  "currency_s" VARCHAR,
  "series_denom" VARCHAR,
  "time_period" TIMESTAMP,
  "obs_value" BIGINT,
  "obs_status" VARCHAR,
  "obs_conf" VARCHAR,
  "obs_pre_break" VARCHAR,
  "obs_com" VARCHAR,
  "time_format" VARCHAR,
  "collection" VARCHAR,
  "compiling_org" VARCHAR,
  "diss_org" VARCHAR,
  "decimals" BIGINT,
  "source_agency" VARCHAR,
  "title" VARCHAR,
  "title_compl" VARCHAR,
  "unit" VARCHAR,
  "unit_mult" BIGINT
);