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

About this Dataset

Euro/ECU Exchange Rates - Daily Data

This Eurostat dataset contains data on euro/ecu exchange rates - daily 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-11-08T11:00:00+0100

Tables

Euro/ECU Exchange Rates - Daily Data - Raw

@eurostat.ert_bil_eur_d.raw

12.42 MB
38 rows
13,587 columns

CREATE TABLE raw (
  "freq" VARCHAR,
  "statinfo" VARCHAR,
  "unit" VARCHAR,
  "currency" VARCHAR,
  "n_1974_07_01" DOUBLE  -- 1974-07-01,
  "n_1974_07_02" DOUBLE  -- 1974-07-02,
  "n_1974_07_03" DOUBLE  -- 1974-07-03,
  "n_1974_07_04" DOUBLE  -- 1974-07-04,
  "n_1974_07_05" DOUBLE  -- 1974-07-05,
  "n_1974_07_08" DOUBLE  -- 1974-07-08,
  "n_1974_07_09" DOUBLE  -- 1974-07-09,
  "n_1974_07_10" DOUBLE  -- 1974-07-10,
  "n_1974_07_11" DOUBLE  -- 1974-07-11,
  "n_1974_07_12" DOUBLE  -- 1974-07-12,
  "n_1974_07_15" DOUBLE  -- 1974-07-15,
  "n_1974_07_16" DOUBLE  -- 1974-07-16,
  "n_1974_07_17" DOUBLE  -- 1974-07-17,
  "n_1974_07_18" DOUBLE  -- 1974-07-18,
  "n_1974_07_19" DOUBLE  -- 1974-07-19,
  "n_1974_07_22" DOUBLE  -- 1974-07-22,
  "n_1974_07_23" DOUBLE  -- 1974-07-23,
  "n_1974_07_24" DOUBLE  -- 1974-07-24,
  "n_1974_07_25" DOUBLE  -- 1974-07-25,
  "n_1974_07_26" DOUBLE  -- 1974-07-26,
  "n_1974_07_29" DOUBLE  -- 1974-07-29,
  "n_1974_07_30" DOUBLE  -- 1974-07-30,
  "n_1974_07_31" DOUBLE  -- 1974-07-31,
  "n_1974_08_01" DOUBLE  -- 1974-08-01,
  "n_1974_08_02" DOUBLE  -- 1974-08-02,
  "n_1974_08_05" DOUBLE  -- 1974-08-05,
  "n_1974_08_06" DOUBLE  -- 1974-08-06,
  "n_1974_08_07" DOUBLE  -- 1974-08-07,
  "n_1974_08_08" DOUBLE  -- 1974-08-08,
  "n_1974_08_09" DOUBLE  -- 1974-08-09,
  "n_1974_08_12" DOUBLE  -- 1974-08-12,
  "n_1974_08_13" DOUBLE  -- 1974-08-13,
  "n_1974_08_14" DOUBLE  -- 1974-08-14,
  "n_1974_08_15" DOUBLE  -- 1974-08-15,
  "n_1974_08_16" DOUBLE  -- 1974-08-16,
  "n_1974_08_19" DOUBLE  -- 1974-08-19,
  "n_1974_08_20" DOUBLE  -- 1974-08-20,
  "n_1974_08_21" DOUBLE  -- 1974-08-21,
  "n_1974_08_22" DOUBLE  -- 1974-08-22,
  "n_1974_08_23" DOUBLE  -- 1974-08-23,
  "n_1974_08_26" DOUBLE  -- 1974-08-26,
  "n_1974_08_27" DOUBLE  -- 1974-08-27,
  "n_1974_08_28" DOUBLE  -- 1974-08-28,
  "n_1974_08_29" DOUBLE  -- 1974-08-29,
  "n_1974_08_30" DOUBLE  -- 1974-08-30,
  "n_1974_09_02" DOUBLE  -- 1974-09-02,
  "n_1974_09_03" DOUBLE  -- 1974-09-03,
  "n_1974_09_04" DOUBLE  -- 1974-09-04,
  "n_1974_09_05" DOUBLE  -- 1974-09-05,
  "n_1974_09_06" DOUBLE  -- 1974-09-06,
  "n_1974_09_09" DOUBLE  -- 1974-09-09,
  "n_1974_09_10" DOUBLE  -- 1974-09-10,
  "n_1974_09_11" DOUBLE  -- 1974-09-11,
  "n_1974_09_12" DOUBLE  -- 1974-09-12,
  "n_1974_09_13" DOUBLE  -- 1974-09-13,
  "n_1974_09_16" DOUBLE  -- 1974-09-16,
  "n_1974_09_17" DOUBLE  -- 1974-09-17,
  "n_1974_09_18" DOUBLE  -- 1974-09-18,
  "n_1974_09_19" DOUBLE  -- 1974-09-19,
  "n_1974_09_20" DOUBLE  -- 1974-09-20,
  "n_1974_09_23" DOUBLE  -- 1974-09-23,
  "n_1974_09_24" DOUBLE  -- 1974-09-24,
  "n_1974_09_25" DOUBLE  -- 1974-09-25,
  "n_1974_09_26" DOUBLE  -- 1974-09-26,
  "n_1974_09_27" DOUBLE  -- 1974-09-27,
  "n_1974_09_30" DOUBLE  -- 1974-09-30,
  "n_1974_10_01" DOUBLE  -- 1974-10-01,
  "n_1974_10_02" DOUBLE  -- 1974-10-02,
  "n_1974_10_03" DOUBLE  -- 1974-10-03,
  "n_1974_10_04" DOUBLE  -- 1974-10-04,
  "n_1974_10_07" DOUBLE  -- 1974-10-07,
  "n_1974_10_08" DOUBLE  -- 1974-10-08,
  "n_1974_10_09" DOUBLE  -- 1974-10-09,
  "n_1974_10_10" DOUBLE  -- 1974-10-10,
  "n_1974_10_11" DOUBLE  -- 1974-10-11,
  "n_1974_10_14" DOUBLE  -- 1974-10-14,
  "n_1974_10_15" DOUBLE  -- 1974-10-15,
  "n_1974_10_16" DOUBLE  -- 1974-10-16,
  "n_1974_10_17" DOUBLE  -- 1974-10-17,
  "n_1974_10_18" DOUBLE  -- 1974-10-18,
  "n_1974_10_21" DOUBLE  -- 1974-10-21,
  "n_1974_10_22" DOUBLE  -- 1974-10-22,
  "n_1974_10_23" DOUBLE  -- 1974-10-23,
  "n_1974_10_24" DOUBLE  -- 1974-10-24,
  "n_1974_10_25" DOUBLE  -- 1974-10-25,
  "n_1974_10_28" DOUBLE  -- 1974-10-28,
  "n_1974_10_29" DOUBLE  -- 1974-10-29,
  "n_1974_10_30" DOUBLE  -- 1974-10-30,
  "n_1974_10_31" DOUBLE  -- 1974-10-31,
  "n_1974_11_04" DOUBLE  -- 1974-11-04,
  "n_1974_11_05" DOUBLE  -- 1974-11-05,
  "n_1974_11_06" DOUBLE  -- 1974-11-06,
  "n_1974_11_07" DOUBLE  -- 1974-11-07,
  "n_1974_11_08" DOUBLE  -- 1974-11-08,
  "n_1974_11_11" DOUBLE  -- 1974-11-11,
  "n_1974_11_12" DOUBLE  -- 1974-11-12
);

Euro/ECU Exchange Rates - Daily Data - Unpivoted

@eurostat.ert_bil_eur_d.tidy

2.1 MB
331,391 rows
6 columns

CREATE TABLE tidy (
  "freq" VARCHAR,
  "statinfo" VARCHAR,
  "unit" VARCHAR,
  "currency" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);