Euro/ECU Exchange Rates - Quarterly Data

Eurostat code: ert_bil_eur_q · (1971-Q1 - 2025-Q1)

@eurostat.ert_bil_eur_q

Table List

2 tables(322.71 KB)

Euro/ECU Exchange Rates - Quarterly Data - Raw

Euro/ECU Exchange Rates - Quarterly Data - Unpivoted

Euro/ECU Exchange Rates - Quarterly Data - Raw

@eurostat.ert_bil_eur_q.raw

This table contains the original data as downloaded from the Eurostat API, with labels mapped where available.

236.76 KB
77 rows
221 columns
Only the first 100 columns are shown

freq Freq	statinfo Statinfo	unit Unit	currency Currency	n_1971_q1 1971-Q1	n_1971_q2 1971-Q2	n_1971_q3 1971-Q3	n_1971_q4 1971-Q4	n_1972_q1 1972-Q1	n_1972_q2 1972-Q2	n_1972_q3 1972-Q3	n_1972_q4 1972-Q4	n_1973_q1 1973-Q1	n_1973_q2 1973-Q2	n_1973_q3 1973-Q3	n_1973_q4 1973-Q4	n_1974_q1 1974-Q1	n_1974_q2 1974-Q2	n_1974_q3 1974-Q3	n_1974_q4 1974-Q4	n_1975_q1 1975-Q1	n_1975_q2 1975-Q2	n_1975_q3 1975-Q3	n_1975_q4 1975-Q4	n_1976_q1 1976-Q1	n_1976_q2 1976-Q2	n_1976_q3 1976-Q3	n_1976_q4 1976-Q4	n_1977_q1 1977-Q1	n_1977_q2 1977-Q2	n_1977_q3 1977-Q3	n_1977_q4 1977-Q4	n_1978_q1 1978-Q1	n_1978_q2 1978-Q2	n_1978_q3 1978-Q3	n_1978_q4 1978-Q4	n_1979_q1 1979-Q1	n_1979_q2 1979-Q2	n_1979_q3 1979-Q3	n_1979_q4 1979-Q4	n_1980_q1 1980-Q1	n_1980_q2 1980-Q2	n_1980_q3 1980-Q3	n_1980_q4 1980-Q4	n_1981_q1 1981-Q1	n_1981_q2 1981-Q2	n_1981_q3 1981-Q3	n_1981_q4 1981-Q4	n_1982_q1 1982-Q1	n_1982_q2 1982-Q2	n_1982_q3 1982-Q3	n_1982_q4 1982-Q4	n_1983_q1 1983-Q1	n_1983_q2 1983-Q2	n_1983_q3 1983-Q3	n_1983_q4 1983-Q4	n_1984_q1 1984-Q1	n_1984_q2 1984-Q2	n_1984_q3 1984-Q3	n_1984_q4 1984-Q4	n_1985_q1 1985-Q1	n_1985_q2 1985-Q2	n_1985_q3 1985-Q3	n_1985_q4 1985-Q4	n_1986_q1 1986-Q1	n_1986_q2 1986-Q2	n_1986_q3 1986-Q3	n_1986_q4 1986-Q4	n_1987_q1 1987-Q1	n_1987_q2 1987-Q2	n_1987_q3 1987-Q3	n_1987_q4 1987-Q4	n_1988_q1 1988-Q1	n_1988_q2 1988-Q2	n_1988_q3 1988-Q3	n_1988_q4 1988-Q4	n_1989_q1 1989-Q1	n_1989_q2 1989-Q2	n_1989_q3 1989-Q3	n_1989_q4 1989-Q4	n_1990_q1 1990-Q1	n_1990_q2 1990-Q2	n_1990_q3 1990-Q3	n_1990_q4 1990-Q4	n_1991_q1 1991-Q1	n_1991_q2 1991-Q2	n_1991_q3 1991-Q3	n_1991_q4 1991-Q4	n_1992_q1 1992-Q1	n_1992_q2 1992-Q2	n_1992_q3 1992-Q3	n_1992_q4 1992-Q4	n_1993_q1 1993-Q1	n_1993_q2 1993-Q2	n_1993_q3 1993-Q3	n_1993_q4 1993-Q4	n_1994_q1 1994-Q1	n_1994_q2 1994-Q2	n_1994_q3 1994-Q3	n_1994_q4 1994-Q4
Quarterly	Average	National currency	Albanian lek
Quarterly	Average	National currency	Australian dollar																																												0.9542	0.9545	0.9561	0.9672	0.9806	1.0068	1.0416	0.9773	0.9268	0.8936	0.9126	0.9169	0.8658	0.9134	1.0874	1.1224	1.2411	1.3143	1.3469	1.6302	1.6039	1.6738	1.6083	1.5798	1.7262	1.7137	1.5623	1.3929	1.393	1.3306	1.3845	1.4113	1.444	1.575	1.5921	1.6045	1.7474	1.7233	1.5408	1.5048	1.6006	1.6778	1.6781	1.8965	1.8151	1.7296	1.7378	1.7201	1.7099	1.59	1.6042	1.6604	1.6423
Quarterly	Average	National currency	Bosnia and Herzegovina convertible mark
Quarterly	Average	National currency	Bulgarian lev
Quarterly	Average	National currency	Brazilian real
Quarterly	Average	National currency	Canadian dollar																			1.2404	1.1962	1.1441	1.0829	1.0768	1.1059	1.1537	1.1873	1.2229	1.2931	1.3768	1.3916	1.4654	1.581	1.6052	1.543	1.6205	1.6503	1.6422	1.6262	1.6478	1.5869	1.4712	1.3359	1.2511	1.2982	1.2527	1.2464	1.1885	1.1493	1.163	1.1216	1.0607	1.0448	1.0441	1.066	1.0094	0.9649	0.9255	0.9941	1.0669	1.176	1.2961	1.3272	1.403	1.4376	1.5047	1.5323	1.4921	1.5916	1.5633	1.4955	1.3579	1.4117	1.3422	1.2821	1.2747	1.3182	1.4254	1.4318	1.495	1.5868	1.5502	1.3646	1.3459	1.4232	1.4852	1.5192	1.6642	1.5993	1.5011	1.5331	1.4994	1.5104	1.5094	1.608	1.6829	1.6959
Quarterly	Average	National currency	Swiss franc															3.5539	3.339	3.2153	3.2665	3.2065	3.1163	2.9649	2.7598	2.7299	2.723	2.8223	2.8314	2.7409	2.5612	2.3886	2.3653	2.1518	2.1828	2.2684	2.2835	2.2783	2.2846	2.3444	2.3384	2.322	2.3069	2.3351	2.2669	2.163	1.9916	1.9414	1.9997	2.0079	1.9954	1.9106	1.8923	1.8485	1.8211	1.8254	1.8527	1.8736	1.8385	1.8825	1.881	1.8414	1.8204	1.8261	1.7878	1.7081	1.7268	1.7378	1.714	1.7209	1.6988	1.6964	1.7262	1.7417	1.7482	1.7792	1.8213	1.7889	1.8121	1.8154	1.7627	1.7328	1.7378	1.75	1.7501	1.7871	1.8007	1.8356	1.8766	1.8057	1.7581	1.793	1.7625	1.6976	1.673	1.6333	1.6369	1.6089	1.6071
Quarterly	Average	National currency	Chinese renminbi-yuan
Quarterly	Average	National currency	Czech koruna																																																																																									34.545	34.711	33.796	33.624	33.624	33.968	34.454	34.557
Quarterly	Average	National currency	Danish krone	7.6946	7.7434	7.7888	7.7838	7.8803	7.9003	7.7606	7.6151	7.5162	7.4184	7.3495	7.3798	7.4208	7.2336	7.2261	7.1571	7.1383	7.1008	7.1148	7.1364	7.0736	6.7292	6.6974	6.5464	6.5939	6.7831	6.9252	7.1126	7.0328	6.9836	7.0681	6.9909	6.9814	7.1502	7.2751	7.4201	7.801	7.8368	7.8142	7.8589	7.9655	7.9749	7.877	7.8782	8.0614	8.13	8.2238	8.2066	8.0901	8.0864	8.1831	8.1636	8.1815	8.202	8.1557	8.0478	7.9596	8.049	8.0723	7.9934	7.9808	7.9587	7.9452	7.8596	7.8112	7.8185	7.939	7.962	7.9189	7.9422	7.9416	8.0033	8.0953	8.0867	8.0595	7.9551	7.8573	7.8146	7.8836	7.8686	7.8837	7.8959	7.9315	7.9214	7.9232	7.9227	7.8248	7.5766	7.488	7.4951	7.741	7.6379	7.5597	7.567	7.5521	7.4953


CREATE TABLE raw (
  "freq" VARCHAR,
  "statinfo" VARCHAR,
  "unit" VARCHAR,
  "currency" VARCHAR,
  "n_1971_q1" DOUBLE,
  "n_1971_q2" DOUBLE,
  "n_1971_q3" DOUBLE,
  "n_1971_q4" DOUBLE,
  "n_1972_q1" DOUBLE,
  "n_1972_q2" DOUBLE,
  "n_1972_q3" DOUBLE,
  "n_1972_q4" DOUBLE,
  "n_1973_q1" DOUBLE,
  "n_1973_q2" DOUBLE,
  "n_1973_q3" DOUBLE,
  "n_1973_q4" DOUBLE,
  "n_1974_q1" DOUBLE,
  "n_1974_q2" DOUBLE,
  "n_1974_q3" DOUBLE,
  "n_1974_q4" DOUBLE,
  "n_1975_q1" DOUBLE,
  "n_1975_q2" DOUBLE,
  "n_1975_q3" DOUBLE,
  "n_1975_q4" DOUBLE,
  "n_1976_q1" DOUBLE,
  "n_1976_q2" DOUBLE,
  "n_1976_q3" DOUBLE,
  "n_1976_q4" DOUBLE,
  "n_1977_q1" DOUBLE,
  "n_1977_q2" DOUBLE,
  "n_1977_q3" DOUBLE,
  "n_1977_q4" DOUBLE,
  "n_1978_q1" DOUBLE,
  "n_1978_q2" DOUBLE,
  "n_1978_q3" DOUBLE,
  "n_1978_q4" DOUBLE,
  "n_1979_q1" DOUBLE,
  "n_1979_q2" DOUBLE,
  "n_1979_q3" DOUBLE,
  "n_1979_q4" DOUBLE,
  "n_1980_q1" DOUBLE,
  "n_1980_q2" DOUBLE,
  "n_1980_q3" DOUBLE,
  "n_1980_q4" DOUBLE,
  "n_1981_q1" DOUBLE,
  "n_1981_q2" DOUBLE,
  "n_1981_q3" DOUBLE,
  "n_1981_q4" DOUBLE,
  "n_1982_q1" DOUBLE,
  "n_1982_q2" DOUBLE,
  "n_1982_q3" DOUBLE,
  "n_1982_q4" DOUBLE,
  "n_1983_q1" DOUBLE,
  "n_1983_q2" DOUBLE,
  "n_1983_q3" DOUBLE,
  "n_1983_q4" DOUBLE,
  "n_1984_q1" DOUBLE,
  "n_1984_q2" DOUBLE,
  "n_1984_q3" DOUBLE,
  "n_1984_q4" DOUBLE,
  "n_1985_q1" DOUBLE,
  "n_1985_q2" DOUBLE,
  "n_1985_q3" DOUBLE,
  "n_1985_q4" DOUBLE,
  "n_1986_q1" DOUBLE,
  "n_1986_q2" DOUBLE,
  "n_1986_q3" DOUBLE,
  "n_1986_q4" DOUBLE,
  "n_1987_q1" DOUBLE,
  "n_1987_q2" DOUBLE,
  "n_1987_q3" DOUBLE,
  "n_1987_q4" DOUBLE,
  "n_1988_q1" DOUBLE,
  "n_1988_q2" DOUBLE,
  "n_1988_q3" DOUBLE,
  "n_1988_q4" DOUBLE,
  "n_1989_q1" DOUBLE,
  "n_1989_q2" DOUBLE,
  "n_1989_q3" DOUBLE,
  "n_1989_q4" DOUBLE,
  "n_1990_q1" DOUBLE,
  "n_1990_q2" DOUBLE,
  "n_1990_q3" DOUBLE,
  "n_1990_q4" DOUBLE,
  "n_1991_q1" DOUBLE,
  "n_1991_q2" DOUBLE,
  "n_1991_q3" DOUBLE,
  "n_1991_q4" DOUBLE,
  "n_1992_q1" DOUBLE,
  "n_1992_q2" DOUBLE,
  "n_1992_q3" DOUBLE,
  "n_1992_q4" DOUBLE,
  "n_1993_q1" DOUBLE,
  "n_1993_q2" DOUBLE,
  "n_1993_q3" DOUBLE,
  "n_1993_q4" DOUBLE,
  "n_1994_q1" DOUBLE,
  "n_1994_q2" DOUBLE,
  "n_1994_q3" DOUBLE,
  "n_1994_q4" DOUBLE
);