• Finance
  • 14 columns
  • 1,000 rows
  • 8 formats

ISO20022 Foreign Exchange Rate Feed (fxtr.030)

This dataset provides comprehensive real-time and periodic foreign exchange rate quotes, including bid/ask spreads, spot and forward rates, and forward points for major currency pairs. It is ideal for financial institutions, trading platforms, and risk managers seeking accurate FX pricing and historical analysis for decision-making and compliance.

  • last updated 29 Oct 2025
  • by GoMask
The brief that made it

Real-time FX pricing for trading platforms

Sample rows

preview · 8 of 1,000 rows · all 14 columns
fx_rate_idstringrate_typestringbid_ratefloatquote_currencystringtimestampdatetimebase_currencystringask_ratefloatmid_ratefloatspreadfloatforward_pointsfloatforward_maturity_datedatesourcestringquote_statusstringupdate_frequencystring
FX001-USD-EUR-spot-20240613T091011spot0.9158EUR2024-06-13T09:10:11USD0.9160.91590.0002blankblankRefinitivfirmreal-time
FX002-EUR-USD-spot-20240613T093212spot1.0911USD2024-06-13T09:32:12EUR1.09141.091250.0003blankblankReutersfirmreal-time
FX003-GBP-USD-spot-20240613T094513spot1.2734USD2024-06-13T09:45:13GBP1.27361.27350.0002blankblankBloombergfirmhourly
FX004-USD-JPY-spot-20240613T100214spot157.15JPY2024-06-13T10:02:14USD157.17157.160.02blankblankRefinitivfirmreal-time
FX005-EUR-GBP-spot-20240613T101115spot0.8579GBP2024-06-13T10:11:15EUR0.85810.8580.0002blankblankReutersfirmhourly
FX006-USD-INR-forward-20240613T103416forward83.405INR2024-06-13T10:34:16USD83.42583.4150.020.0132024-09-13HDFC Bankindicativedaily
FX007-BRL-USD-forward-20240613T104717forward0.1841USD2024-06-13T10:47:17BRL0.18460.184350.00050.0032025-06-13Banco do Brasilfirmweekly
FX008-USD-ZAR-forward-20240613T110018forward18.36ZAR2024-06-13T11:00:18USD18.4118.3850.050.0422024-12-13Standard Bankfirmdaily

What the 1,000 rows show

from the 1,000-row sample
  • 1.1median bid_rate
  • 3quote statuses
  • 4update frequencies
  • 19base currencies
  • 123sources
  • 1.1median ask_rate
rate_type1,000 rows by value
0225450447spot45%382forward38%171swap17%
bid_rate1,000 rows, in bands of 200
048096095330002162608001,600bid_rate →

Median 1.1, from 0.00 to 1,555.

quote_currency1,000 rows · top 10 of 21 values
  1. USD296
  2. EUR141
  3. JPY90
  4. CHF79
  5. ZAR56
  6. GBP54
  7. KRW45
  8. INR40
  9. MXN33
  10. BRL32
14 columns by typefrom the column list below
  • string 7
  • float 5
  • date 1
  • datetime 1

Columns

14 columns in three groups
blueprint · 14 columns
columntypedescriptionexample
Text 7 columns
fx_rate_idstringUnique identifier for each foreign exchange rate recorduniqueFX001-USD-EUR-spot-202406…
base_currencystringISO 4217 code of the base currency in the FX pair (e.g., USD)USD
quote_currencystringISO 4217 code of the quote currency in the FX pair (e.g., EUR)EUR
rate_typestringType of FX rate quoted (e.g., spot, forward, swap)spot · forward · swapspot
sourcestringName or code of the rate provider or data sourceRefinitiv
quote_statusstringStatus of the FX quote (e.g., indicative, firm, expired)indicative · firm · expiredfirm
update_frequencystringFrequency of rate updates (e.g., real-time, hourly, daily)real-time · hourly · daily · weekly · optionalreal-time
Numbers 5 columns
bid_ratefloatBid price for the FX pair0 or more0.9158
ask_ratefloatAsk price for the FX pair0 or more0.916
mid_ratefloatMid-market rate for the FX pair (average of bid and ask)0 or more · optional0.9159
spreadfloatDifference between ask and bid rates0 or more · optional0.0002
forward_pointsfloatForward points applied to the spot rate for forward contractsoptional0.013
Dates and times 2 columns
timestampdatetimeDate and time when the FX rate was quoted or updated2024-06-13T09:10:11
forward_maturity_datedateMaturity date for forward FX contractsoptional2024-09-13

Use it for

  • median bid rate1.11,000 rowsmean bid rate by rate…25.6spot187.0forward21.0swap

    A finance dashboard

    Bid_rate by rate_type and a breakdown of quote_currency. Excel, Power BI or Tableau.

  • What pattern can you find in 1,000 rows?

    A class exercise

    Hand out the rows and one question. Everyone works from the same 1,000 rows.

  • A software demo

    Believable fx rates with timestamp, base_currency and quote_currency to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 14 columns, your size and your rules. See 20 rows before you pay.

Preview 20 rows free

1,000 rows: $1.99 · 10,000: $12.99One-time. No subscription. All prices

This dataset1,000 rows14 columns
Yours1,000 rows14 columns

blueprint · iso20022-foreign-exchange-rate-feed-fxtr030

Behind this dataset

Same schema. As many rows as you need.

These 1,000 rows came out of a blueprint — 14 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.

Rules it was built with
  • Currency pair identifier
  • Bid rate and ask rate
  • Mid rate calculated
  • Rate timestamp for validity
  • Source of rate: interbank, ECB, proprietary
  • Spread in basis points
  • Forward points for tenors
  • Rate type: indicative or firm
Rows
Open the blueprint in Data Factory

1 credit per row. Preview 20 rows free. Buy rows for the full run.

Exports
CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
Licence
yours to use, including commercially
API slug
iso20022-foreign-exchange-rate-feed-fxtr030

More in Finance

Browse all
Also in FinanceISO20022 Foreign Exchange Trade Confirmation (fxtr.016)Transaction Categorization DatasetFinance Expense Categorization DatasetAll 1,966 datasets

What should your data show?

Preview 20 rows free
No signup. No card.