Skip to content
background-image background-image

ECB Quarterly Averages Reader

[ | version 3.0]


The connector is permitted for use of the platform background agent.

Connector processing type: Row by row!

The ECB quarterly averages reader is connected to the ECB data portal exchange reference rates and returns the average exchange rates for the published set of currency codes and all completed quarters of the provided year.

The connector expects the input of:

  • year (format yyyy)

Euro foreign exchange reference rates

The reference rates are usually updated at around 16:00 CET every working day, except on TARGET closing days.

They are based on the daily concertation procedure between central banks across Europe, which normally takes place around 14:10 CET. The reference rates are published for information purposes only. Using the rates for transaction purposes is strongly discouraged.


This connector does not include any configuration.

Input & Output Schema


ECB quarterly averages rates input (ver. 1.0.0)

Column Data type Allow null Description
Year integer Yes Year, for which the average rates are required


ECB quarterly averages rates output (ver. 1.0.0)

Column Data type Allow null Description
Quartal string No Quarter (JAN_TO_MAR, APR_TO_JUN, ...)
Year integer No Year
Average double No Average exchange rate for the period
CurrencyCode string No Currency code in ISO 4217 format
Amount integer No Exchange rate for the currency using the decimal place factor

Release notes


  • First release