Skip to main content

Peliqan

Try for free
Request a demo

Norges Bank Currencies

Average exchange rate monthly

SQL query for Norges Bank Currencies

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 Norges Bank Currencies

Norges Bank Currencies data model

Norges Bank Currencies
Currencies

View 5 columns
RateNumber
Rate_idString
Rate_dateDate-time
Rate_currencyString
Rate_quote_currencyString

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