Name: Euro/Ecu Exchange Rates - Monthly Data
Creator: Eurostat
License: https://ec.europa.eu/eurostat/statistics-explained/index.php?title=Copyright/licence_policy

About this Dataset

Euro/Ecu Exchange Rates - Monthly Data

This Eurostat dataset contains data on euro/ecu exchange rates - monthly data, as collected and published by the Statistical Office of the European Union.

Tables included:

raw: Original table as downloaded from Eurostat.
tidy: A cleaned and transformed version of the raw table, where time period values appear as rows instead of columns (unpivoted format).

Last updated: 2025-10-10T11:00:00+0200

Tables

Euro/Ecu Exchange Rates - Monthly Data - Raw

@eurostat.ei_mfrt_m.raw

319.58 kB
36 rows
325 columns

CREATE TABLE raw (
  "freq" VARCHAR,
  "s_adj" VARCHAR,
  "indic" VARCHAR,
  "currency" VARCHAR,
  "n_1999_01" DOUBLE  -- 1999-01,
  "n_1999_02" DOUBLE  -- 1999-02,
  "n_1999_03" DOUBLE  -- 1999-03,
  "n_1999_04" DOUBLE  -- 1999-04,
  "n_1999_05" DOUBLE  -- 1999-05,
  "n_1999_06" DOUBLE  -- 1999-06,
  "n_1999_07" DOUBLE  -- 1999-07,
  "n_1999_08" DOUBLE  -- 1999-08,
  "n_1999_09" DOUBLE  -- 1999-09,
  "n_1999_10" DOUBLE  -- 1999-10,
  "n_1999_11" DOUBLE  -- 1999-11,
  "n_1999_12" DOUBLE  -- 1999-12,
  "n_2000_01" DOUBLE  -- 2000-01,
  "n_2000_02" DOUBLE  -- 2000-02,
  "n_2000_03" DOUBLE  -- 2000-03,
  "n_2000_04" DOUBLE  -- 2000-04,
  "n_2000_05" DOUBLE  -- 2000-05,
  "n_2000_06" DOUBLE  -- 2000-06,
  "n_2000_07" DOUBLE  -- 2000-07,
  "n_2000_08" DOUBLE  -- 2000-08,
  "n_2000_09" DOUBLE  -- 2000-09,
  "n_2000_10" DOUBLE  -- 2000-10,
  "n_2000_11" DOUBLE  -- 2000-11,
  "n_2000_12" DOUBLE  -- 2000-12,
  "n_2001_01" DOUBLE  -- 2001-01,
  "n_2001_02" DOUBLE  -- 2001-02,
  "n_2001_03" DOUBLE  -- 2001-03,
  "n_2001_04" DOUBLE  -- 2001-04,
  "n_2001_05" DOUBLE  -- 2001-05,
  "n_2001_06" DOUBLE  -- 2001-06,
  "n_2001_07" DOUBLE  -- 2001-07,
  "n_2001_08" DOUBLE  -- 2001-08,
  "n_2001_09" DOUBLE  -- 2001-09,
  "n_2001_10" DOUBLE  -- 2001-10,
  "n_2001_11" DOUBLE  -- 2001-11,
  "n_2001_12" DOUBLE  -- 2001-12,
  "n_2002_01" DOUBLE  -- 2002-01,
  "n_2002_02" DOUBLE  -- 2002-02,
  "n_2002_03" DOUBLE  -- 2002-03,
  "n_2002_04" DOUBLE  -- 2002-04,
  "n_2002_05" DOUBLE  -- 2002-05,
  "n_2002_06" DOUBLE  -- 2002-06,
  "n_2002_07" DOUBLE  -- 2002-07,
  "n_2002_08" DOUBLE  -- 2002-08,
  "n_2002_09" DOUBLE  -- 2002-09,
  "n_2002_10" DOUBLE  -- 2002-10,
  "n_2002_11" DOUBLE  -- 2002-11,
  "n_2002_12" DOUBLE  -- 2002-12,
  "n_2003_01" DOUBLE  -- 2003-01,
  "n_2003_02" DOUBLE  -- 2003-02,
  "n_2003_03" DOUBLE  -- 2003-03,
  "n_2003_04" DOUBLE  -- 2003-04,
  "n_2003_05" DOUBLE  -- 2003-05,
  "n_2003_06" DOUBLE  -- 2003-06,
  "n_2003_07" DOUBLE  -- 2003-07,
  "n_2003_08" DOUBLE  -- 2003-08,
  "n_2003_09" DOUBLE  -- 2003-09,
  "n_2003_10" DOUBLE  -- 2003-10,
  "n_2003_11" DOUBLE  -- 2003-11,
  "n_2003_12" DOUBLE  -- 2003-12,
  "n_2004_01" DOUBLE  -- 2004-01,
  "n_2004_02" DOUBLE  -- 2004-02,
  "n_2004_03" DOUBLE  -- 2004-03,
  "n_2004_04" DOUBLE  -- 2004-04,
  "n_2004_05" DOUBLE  -- 2004-05,
  "n_2004_06" DOUBLE  -- 2004-06,
  "n_2004_07" DOUBLE  -- 2004-07,
  "n_2004_08" DOUBLE  -- 2004-08,
  "n_2004_09" DOUBLE  -- 2004-09,
  "n_2004_10" DOUBLE  -- 2004-10,
  "n_2004_11" DOUBLE  -- 2004-11,
  "n_2004_12" DOUBLE  -- 2004-12,
  "n_2005_01" DOUBLE  -- 2005-01,
  "n_2005_02" DOUBLE  -- 2005-02,
  "n_2005_03" DOUBLE  -- 2005-03,
  "n_2005_04" DOUBLE  -- 2005-04,
  "n_2005_05" DOUBLE  -- 2005-05,
  "n_2005_06" DOUBLE  -- 2005-06,
  "n_2005_07" DOUBLE  -- 2005-07,
  "n_2005_08" DOUBLE  -- 2005-08,
  "n_2005_09" DOUBLE  -- 2005-09,
  "n_2005_10" DOUBLE  -- 2005-10,
  "n_2005_11" DOUBLE  -- 2005-11,
  "n_2005_12" DOUBLE  -- 2005-12,
  "n_2006_01" DOUBLE  -- 2006-01,
  "n_2006_02" DOUBLE  -- 2006-02,
  "n_2006_03" DOUBLE  -- 2006-03,
  "n_2006_04" DOUBLE  -- 2006-04,
  "n_2006_05" DOUBLE  -- 2006-05,
  "n_2006_06" DOUBLE  -- 2006-06,
  "n_2006_07" DOUBLE  -- 2006-07,
  "n_2006_08" DOUBLE  -- 2006-08,
  "n_2006_09" DOUBLE  -- 2006-09,
  "n_2006_10" DOUBLE  -- 2006-10,
  "n_2006_11" DOUBLE  -- 2006-11,
  "n_2006_12" DOUBLE  -- 2006-12
);

Euro/Ecu Exchange Rates - Monthly Data - Unpivoted

@eurostat.ei_mfrt_m.tidy

93.16 kB
11,445 rows
6 columns

CREATE TABLE tidy (
  "freq" VARCHAR,
  "s_adj" VARCHAR,
  "indic" VARCHAR,
  "currency" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);