Open Market Operations - OMO

European Central Bank

@ecb.open_market_operations_omo

Table List

1 table(22.01 KB)

Table 1

@ecb.open_market_operations_omo.table_1

22.01 KB
228 rows
32 columns

key KEY	freq FREQ	ref_area REF AREA	omo_type OMO TYPE	operation_cat OPERATION CAT	operation_subcat OPERATION SUBCAT	data_type DATA TYPE	tender_ref TENDER REF	currency CURRENCY	time_period TIME PERIOD	obs_value OBS VALUE	obs_status OBS STATUS	obs_conf OBS CONF	time_format TIME FORMAT	maturity_date MATURITY DATE	allotted_amount ALLOTTED AMOUNT	settlement_date SETTLEMENT DATE	collection COLLECTION	decimals DECIMALS	title TITLE	title_compl TITLE COMPL	unit UNIT	unit_mult UNIT MULT
OMO.B.U2.T.LTRO._Z.O.20210155.EUR	B	U2	T	LTRO	_Z	O	20210155	EUR	Thu Nov 07 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	29160	A	F	P1D	Wed Dec 18 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	51975	Wed Dec 22 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	E	2	Outstanding amounts of Tender ID 20210155 (Longer-term refinancing operations)	Tender, Longer-term refinancing operations, Not applicable, Tender ID 20210155, Euro, Outstanding amounts	EUR	6
OMO.B.U2.T.LTRO._Z.O.20210155.EUR	B	U2	T	LTRO	_Z	O	20210155	EUR	Fri Nov 08 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	29160	A	F	P1D	Wed Dec 18 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	51975	Wed Dec 22 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	E	2	Outstanding amounts of Tender ID 20210155 (Longer-term refinancing operations)	Tender, Longer-term refinancing operations, Not applicable, Tender ID 20210155, Euro, Outstanding amounts	EUR	6
OMO.B.U2.T.LTRO._Z.O.20210155.EUR	B	U2	T	LTRO	_Z	O	20210155	EUR	Mon Nov 11 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	29160	A	F	P1D	Wed Dec 18 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	51975	Wed Dec 22 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	E	2	Outstanding amounts of Tender ID 20210155 (Longer-term refinancing operations)	Tender, Longer-term refinancing operations, Not applicable, Tender ID 20210155, Euro, Outstanding amounts	EUR	6
OMO.B.U2.T.LTRO._Z.O.20210155.EUR	B	U2	T	LTRO	_Z	O	20210155	EUR	Tue Nov 12 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	29160	A	F	P1D	Wed Dec 18 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	51975	Wed Dec 22 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	E	2	Outstanding amounts of Tender ID 20210155 (Longer-term refinancing operations)	Tender, Longer-term refinancing operations, Not applicable, Tender ID 20210155, Euro, Outstanding amounts	EUR	6
OMO.B.U2.T.LTRO._Z.O.20210155.EUR	B	U2	T	LTRO	_Z	O	20210155	EUR	Wed Nov 13 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	29160	A	F	P1D	Wed Dec 18 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	51975	Wed Dec 22 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	E	2	Outstanding amounts of Tender ID 20210155 (Longer-term refinancing operations)	Tender, Longer-term refinancing operations, Not applicable, Tender ID 20210155, Euro, Outstanding amounts	EUR	6
OMO.B.U2.T.LTRO._Z.O.20210155.EUR	B	U2	T	LTRO	_Z	O	20210155	EUR	Thu Nov 14 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	29160	A	F	P1D	Wed Dec 18 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	51975	Wed Dec 22 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	E	2	Outstanding amounts of Tender ID 20210155 (Longer-term refinancing operations)	Tender, Longer-term refinancing operations, Not applicable, Tender ID 20210155, Euro, Outstanding amounts	EUR	6
OMO.B.U2.T.LTRO._Z.O.20210155.EUR	B	U2	T	LTRO	_Z	O	20210155	EUR	Fri Nov 15 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	29160	A	F	P1D	Wed Dec 18 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	51975	Wed Dec 22 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	E	2	Outstanding amounts of Tender ID 20210155 (Longer-term refinancing operations)	Tender, Longer-term refinancing operations, Not applicable, Tender ID 20210155, Euro, Outstanding amounts	EUR	6
OMO.B.U2.T.LTRO._Z.O.20210155.EUR	B	U2	T	LTRO	_Z	O	20210155	EUR	Mon Nov 18 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	29160	A	F	P1D	Wed Dec 18 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	51975	Wed Dec 22 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	E	2	Outstanding amounts of Tender ID 20210155 (Longer-term refinancing operations)	Tender, Longer-term refinancing operations, Not applicable, Tender ID 20210155, Euro, Outstanding amounts	EUR	6
OMO.B.U2.T.LTRO._Z.O.20210155.EUR	B	U2	T	LTRO	_Z	O	20210155	EUR	Tue Nov 19 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	29160	A	F	P1D	Wed Dec 18 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	51975	Wed Dec 22 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	E	2	Outstanding amounts of Tender ID 20210155 (Longer-term refinancing operations)	Tender, Longer-term refinancing operations, Not applicable, Tender ID 20210155, Euro, Outstanding amounts	EUR	6
OMO.B.U2.T.LTRO._Z.O.20210155.EUR	B	U2	T	LTRO	_Z	O	20210155	EUR	Wed Nov 20 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	29160	A	F	P1D	Wed Dec 18 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	51975	Wed Dec 22 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	E	2	Outstanding amounts of Tender ID 20210155 (Longer-term refinancing operations)	Tender, Longer-term refinancing operations, Not applicable, Tender ID 20210155, Euro, Outstanding amounts	EUR	6


CREATE TABLE table_1 (
  "key" VARCHAR,
  "freq" VARCHAR,
  "ref_area" VARCHAR,
  "omo_type" VARCHAR,
  "operation_cat" VARCHAR,
  "operation_subcat" VARCHAR,
  "data_type" VARCHAR,
  "tender_ref" BIGINT,
  "currency" VARCHAR,
  "time_period" TIMESTAMP,
  "obs_value" BIGINT,
  "obs_status" VARCHAR,
  "obs_conf" VARCHAR,
  "obs_pre_break" VARCHAR,
  "obs_com" VARCHAR,
  "time_format" VARCHAR,
  "maturity_date" TIMESTAMP,
  "allotted_amount" BIGINT,
  "settlement_date" TIMESTAMP,
  "breaks" VARCHAR,
  "collection" VARCHAR,
  "compiling_org" VARCHAR,
  "diss_org" VARCHAR,
  "agg_equn" VARCHAR,
  "compilation" VARCHAR,
  "coverage" VARCHAR,
  "decimals" BIGINT,
  "source_agency" VARCHAR,
  "title" VARCHAR,
  "title_compl" VARCHAR,
  "unit" VARCHAR,
  "unit_mult" DOUBLE
);