Skip to main content
The FXRATES table contains all the FX Rates. It is an isolated table and not part of any cube facts. FX Rates are looked up via the default implementation of IFXRates API.
Column NameTypeNot NullDescription
AS_OF_DATEDATEYTimestamp (at close of business) for the data.
BASE_CCYSTRINGYThe left side of the currency pair.
COUNTER_CCYSTRINGYThe right side of the currency pair.
FX_RATEDOUBLEYForex rate between the two currencies.

Unique Key

Columns
AS_OF_DATE
BASE_CCY
COUNTER_CCY