Skip to main content

Peliqan

Try for free
Request a demo

Fixer.io currency exchange rates

Average exchange rate monthly

SQL query for Fixer.io currency exchange rates

Calculate the average exchange rate for a specific currency on a monthly basis.

SELECT MONTH(date) AS month, AVG(exchange_rate) FROM currencies WHERE currency_code = ‘JPY’ GROUP BY MONTH(date)

Try this query now in Fixer.io currency exchange rates

Fixer.io currency exchange rates data model

Fixer.io currency exchange rates
Rates

Ready to get instant access to all your company data ?​

Connect 300+ sources, serve any BI tool, and give every AI agent one governed endpoint to read, and write back where the app supports it.

  • 14-day free trial
  • No credit card needed