Skip to main content

Peliqan

Try for free
Request a demo

Fixer.io currency exchange rates

Exchange rate fluctuation

SQL query for Fixer.io currency exchange rates

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’

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