Financial Market Data (Other Data) - FM

European Central Bank

@ecb.financial_market_data_other_data_fm

Table List

1 table(376.87 KB)

Table 1

@ecb.financial_market_data_other_data_fm.table_1

376.87 KB
83046 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
FM.A.GB.EUR.4F.CY.EUCRBRDT.HSTA	A	GB	EUR	4F	CY	EUCRBRDT	HSTA	2000	31.03595407953341	A	F	P1Y	A	4	Bloomberg European Dated Brent Forties Oseberg Ekofisk (BFOE) Crude Oil Spot Price - Historical close, average of observations through period	United Kingdom - Commodity - Bloomberg European Dated Brent Forties Oseberg Ekofisk (BFOE) Crude Oil Spot Price - Historical close, average of observations through period - Euro, provided by ECB	PCPA
FM.A.GB.EUR.4F.CY.EUCRBRDT.HSTA	A	GB	EUR	4F	CY	EUCRBRDT	HSTA	2001	27.260107870645378	A	F	P1Y	A	4	Bloomberg European Dated Brent Forties Oseberg Ekofisk (BFOE) Crude Oil Spot Price - Historical close, average of observations through period	United Kingdom - Commodity - Bloomberg European Dated Brent Forties Oseberg Ekofisk (BFOE) Crude Oil Spot Price - Historical close, average of observations through period - Euro, provided by ECB	PCPA
FM.A.GB.EUR.4F.CY.EUCRBRDT.HSTA	A	GB	EUR	4F	CY	EUCRBRDT	HSTA	2002	26.40711511539092	A	F	P1Y	A	4	Bloomberg European Dated Brent Forties Oseberg Ekofisk (BFOE) Crude Oil Spot Price - Historical close, average of observations through period	United Kingdom - Commodity - Bloomberg European Dated Brent Forties Oseberg Ekofisk (BFOE) Crude Oil Spot Price - Historical close, average of observations through period - Euro, provided by ECB	PCPA
FM.A.GB.EUR.4F.CY.EUCRBRDT.HSTA	A	GB	EUR	4F	CY	EUCRBRDT	HSTA	2003	25.56281530869249	A	F	P1Y	A	4	Bloomberg European Dated Brent Forties Oseberg Ekofisk (BFOE) Crude Oil Spot Price - Historical close, average of observations through period	United Kingdom - Commodity - Bloomberg European Dated Brent Forties Oseberg Ekofisk (BFOE) Crude Oil Spot Price - Historical close, average of observations through period - Euro, provided by ECB	PCPA
FM.A.GB.EUR.4F.CY.EUCRBRDT.HSTA	A	GB	EUR	4F	CY	EUCRBRDT	HSTA	2004	30.82263474409733	A	F	P1Y	A	4	Bloomberg European Dated Brent Forties Oseberg Ekofisk (BFOE) Crude Oil Spot Price - Historical close, average of observations through period	United Kingdom - Commodity - Bloomberg European Dated Brent Forties Oseberg Ekofisk (BFOE) Crude Oil Spot Price - Historical close, average of observations through period - Euro, provided by ECB	PCPA
FM.A.GB.EUR.4F.CY.EUCRBRDT.HSTA	A	GB	EUR	4F	CY	EUCRBRDT	HSTA	2005	43.97634212862992	A	F	P1Y	A	4	Bloomberg European Dated Brent Forties Oseberg Ekofisk (BFOE) Crude Oil Spot Price - Historical close, average of observations through period	United Kingdom - Commodity - Bloomberg European Dated Brent Forties Oseberg Ekofisk (BFOE) Crude Oil Spot Price - Historical close, average of observations through period - Euro, provided by ECB	PCPA
FM.A.GB.EUR.4F.CY.EUCRBRDT.HSTA	A	GB	EUR	4F	CY	EUCRBRDT	HSTA	2006	52.07623729004762	A	F	P1Y	A	4	Bloomberg European Dated Brent Forties Oseberg Ekofisk (BFOE) Crude Oil Spot Price - Historical close, average of observations through period	United Kingdom - Commodity - Bloomberg European Dated Brent Forties Oseberg Ekofisk (BFOE) Crude Oil Spot Price - Historical close, average of observations through period - Euro, provided by ECB	PCPA
FM.A.GB.EUR.4F.CY.EUCRBRDT.HSTA	A	GB	EUR	4F	CY	EUCRBRDT	HSTA	2007	52.792345663180605	A	F	P1Y	A	4	Bloomberg European Dated Brent Forties Oseberg Ekofisk (BFOE) Crude Oil Spot Price - Historical close, average of observations through period	United Kingdom - Commodity - Bloomberg European Dated Brent Forties Oseberg Ekofisk (BFOE) Crude Oil Spot Price - Historical close, average of observations through period - Euro, provided by ECB	PCPA
FM.A.GB.EUR.4F.CY.EUCRBRDT.HSTA	A	GB	EUR	4F	CY	EUCRBRDT	HSTA	2008	65.49719323648519	A	F	P1Y	A	4	Bloomberg European Dated Brent Forties Oseberg Ekofisk (BFOE) Crude Oil Spot Price - Historical close, average of observations through period	United Kingdom - Commodity - Bloomberg European Dated Brent Forties Oseberg Ekofisk (BFOE) Crude Oil Spot Price - Historical close, average of observations through period - Euro, provided by ECB	PCPA
FM.A.GB.EUR.4F.CY.EUCRBRDT.HSTA	A	GB	EUR	4F	CY	EUCRBRDT	HSTA	2009	44.15522483656299	A	F	P1Y	A	4	Bloomberg European Dated Brent Forties Oseberg Ekofisk (BFOE) Crude Oil Spot Price - Historical close, average of observations through period	United Kingdom - Commodity - Bloomberg European Dated Brent Forties Oseberg Ekofisk (BFOE) Crude Oil Spot Price - Historical close, average of observations through period - Euro, provided by ECB	PCPA


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" VARCHAR,
  "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" DOUBLE,
  "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
);