Skip to main content

Peliqan

Norges Bank Currencies

Exchange rate fluctuation

SQL query for Norges Bank Currencies

Identify instances where the exchange rate for a specific currency fluctuated by more than 5% within a week.

SELECT * FROM currencies WHERE currency_code = ‘AUD’ AND ABS((MAX(exchange_rate) – MIN(exchange_rate)) / MIN(exchange_rate) * 100) > 5 AND date BETWEEN ‘2021-01-01’ AND ‘2021-01-07’

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.