Average exchange rate - Norges Bank Currencies SQL Query - Peliqan

Average exchange rate

SQL query for Norges Bank Currencies

Calculate the average exchange rate for a specific currency over a specified time period.

SELECT AVG(exchange_rate) FROM currencies WHERE currency_code = ‘USD’ AND date BETWEEN ‘2021-01-01’ AND ‘2021-12-31’

Norges Bank Currencies data model

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.