Baselight

Euro/ECU Exchange Rates - Daily Data

Eurostat code: ert_bil_eur_d ยท (1974-07-01 - 2025-05-21)

@eurostat.ert_bil_eur_d

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-05-22T11:00:00+0200

Tables

Euro/ECU Exchange Rates - Daily Data - Raw

@eurostat.ert_bil_eur_d.raw
  • 11.69 MB
  • 38 rows
  • 13413 columns

CREATE TABLE raw (
  "freq" VARCHAR,
  "statinfo" VARCHAR,
  "unit" VARCHAR,
  "currency" VARCHAR,
  "n_1974_07_01" DOUBLE,
  "n_1974_07_02" DOUBLE,
  "n_1974_07_03" DOUBLE,
  "n_1974_07_04" DOUBLE,
  "n_1974_07_05" DOUBLE,
  "n_1974_07_08" DOUBLE,
  "n_1974_07_09" DOUBLE,
  "n_1974_07_10" DOUBLE,
  "n_1974_07_11" DOUBLE,
  "n_1974_07_12" DOUBLE,
  "n_1974_07_15" DOUBLE,
  "n_1974_07_16" DOUBLE,
  "n_1974_07_17" DOUBLE,
  "n_1974_07_18" DOUBLE,
  "n_1974_07_19" DOUBLE,
  "n_1974_07_22" DOUBLE,
  "n_1974_07_23" DOUBLE,
  "n_1974_07_24" DOUBLE,
  "n_1974_07_25" DOUBLE,
  "n_1974_07_26" DOUBLE,
  "n_1974_07_29" DOUBLE,
  "n_1974_07_30" DOUBLE,
  "n_1974_07_31" DOUBLE,
  "n_1974_08_01" DOUBLE,
  "n_1974_08_02" DOUBLE,
  "n_1974_08_05" DOUBLE,
  "n_1974_08_06" DOUBLE,
  "n_1974_08_07" DOUBLE,
  "n_1974_08_08" DOUBLE,
  "n_1974_08_09" DOUBLE,
  "n_1974_08_12" DOUBLE,
  "n_1974_08_13" DOUBLE,
  "n_1974_08_14" DOUBLE,
  "n_1974_08_15" DOUBLE,
  "n_1974_08_16" DOUBLE,
  "n_1974_08_19" DOUBLE,
  "n_1974_08_20" DOUBLE,
  "n_1974_08_21" DOUBLE,
  "n_1974_08_22" DOUBLE,
  "n_1974_08_23" DOUBLE,
  "n_1974_08_26" DOUBLE,
  "n_1974_08_27" DOUBLE,
  "n_1974_08_28" DOUBLE,
  "n_1974_08_29" DOUBLE,
  "n_1974_08_30" DOUBLE,
  "n_1974_09_02" DOUBLE,
  "n_1974_09_03" DOUBLE,
  "n_1974_09_04" DOUBLE,
  "n_1974_09_05" DOUBLE,
  "n_1974_09_06" DOUBLE,
  "n_1974_09_09" DOUBLE,
  "n_1974_09_10" DOUBLE,
  "n_1974_09_11" DOUBLE,
  "n_1974_09_12" DOUBLE,
  "n_1974_09_13" DOUBLE,
  "n_1974_09_16" DOUBLE,
  "n_1974_09_17" DOUBLE,
  "n_1974_09_18" DOUBLE,
  "n_1974_09_19" DOUBLE,
  "n_1974_09_20" DOUBLE,
  "n_1974_09_23" DOUBLE,
  "n_1974_09_24" DOUBLE,
  "n_1974_09_25" DOUBLE,
  "n_1974_09_26" DOUBLE,
  "n_1974_09_27" DOUBLE,
  "n_1974_09_30" DOUBLE,
  "n_1974_10_01" DOUBLE,
  "n_1974_10_02" DOUBLE,
  "n_1974_10_03" DOUBLE,
  "n_1974_10_04" DOUBLE,
  "n_1974_10_07" DOUBLE,
  "n_1974_10_08" DOUBLE,
  "n_1974_10_09" DOUBLE,
  "n_1974_10_10" DOUBLE,
  "n_1974_10_11" DOUBLE,
  "n_1974_10_14" DOUBLE,
  "n_1974_10_15" DOUBLE,
  "n_1974_10_16" DOUBLE,
  "n_1974_10_17" DOUBLE,
  "n_1974_10_18" DOUBLE,
  "n_1974_10_21" DOUBLE,
  "n_1974_10_22" DOUBLE,
  "n_1974_10_23" DOUBLE,
  "n_1974_10_24" DOUBLE,
  "n_1974_10_25" DOUBLE,
  "n_1974_10_28" DOUBLE,
  "n_1974_10_29" DOUBLE,
  "n_1974_10_30" DOUBLE,
  "n_1974_10_31" DOUBLE,
  "n_1974_11_04" DOUBLE,
  "n_1974_11_05" DOUBLE,
  "n_1974_11_06" DOUBLE,
  "n_1974_11_07" DOUBLE,
  "n_1974_11_08" DOUBLE,
  "n_1974_11_11" DOUBLE,
  "n_1974_11_12" DOUBLE
);

Euro/ECU Exchange Rates - Daily Data - Unpivoted

@eurostat.ert_bil_eur_d.tidy
  • 1.98 MB
  • 326756 rows
  • 6 columns

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

Share link

Anyone who has the link will be able to view this.