Navigation: Schema: OpenExchangeRates > Tables

RateTimeSeriesByDateRangeAndBase: Open Exchange Rates Exchange Rate Time Series by Date Range and Base Currency

Catalog: OpenExchangeRates

Schema: OpenExchangeRates

Label: Exchange Rate Time Series by Date Range and Base Currency

Documentation:

Get historical exchange rates for a given time period, where available, using the time series / bulk download API endpoint. Please read all the details before integrating. Time Series requests are currently available for clients on the Enterprise and Unlimited plans.

This is a read-only table function. The Open Exchange Rates API may not support changing the data or the Invantive SQL driver for Open Exchange Rates does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Open Exchange Rates API.

Select Open Exchange Rates API URL: time-series.json?start={start}&end={end}&base={base}&show_alternative={show_alternative}

Insert Open Exchange Rates API URL: time-series.json?start={start}&end={end}&base={base}&show_alternative={show_alternative}

Update Open Exchange Rates API URL: time-series.json?start={start}&end={end}&base={base}&show_alternative={show_alternative}

Delete Open Exchange Rates API URL: time-series.json?start={start}&end={end}&base={base}&show_alternative={show_alternative}

Field Selection Method: NotRequired

Parameters of Table Function

The following parameters can be used to control the behaviour of the table function RateTimeSeriesByDateRangeAndBase. A value must be provided at all times for required parameters, but optional parameters in general do not need to have a value and the execution will default to a pre-defined behaviour. Values can be specified by position and by name. In both cases, all parameters not specified will be treated using their default values.

Value specification by position is done by listing all values from the first to the last needed value. For example with `select * from table(value1, value2, value3)` on a table with four parameters will use the default value for the fourth parameter and the specified values for the first three.

Value specification by name is done by listing all values that require a value. For example with `select * from table(name1 => value1, name3 => value3)` on the same table will use the default values for the second and fourth parameters and the specified values for the first and third.

Name	Data Type	Required	Default Value	Documentation
base	string	☐	USD	Change base currency (3-letter code, default: USD).
end	datetime	☑		The time series end date without time.
show_alternative	boolean	☐	True	Extend returned values with alternative, black market and digital currency rates.
start	datetime	☑		The time series start date without time.

Table Function Columns

The columns of the table function RateTimeSeriesByDateRangeAndBase are shown below. Each column has an SQL data type.

Name	Data Type	Required
base	string	☐
date	string	☐
end_date	datetime	☐
rate_AED	decimal	☐
rate_AFN	decimal	☐
rate_ALL	decimal	☐
rate_AMD	decimal	☐
rate_ANG	decimal	☐
rate_AOA	decimal	☐
rate_ARS	decimal	☐
rate_AUD	decimal	☐
rate_AWG	decimal	☐
rate_AZN	decimal	☐
rate_BAM	decimal	☐
rate_BBD	decimal	☐
rate_BDT	decimal	☐
rate_BGN	decimal	☐
rate_BHD	decimal	☐
rate_BIF	decimal	☐
rate_BMD	decimal	☐
rate_BND	decimal	☐
rate_BOB	decimal	☐
rate_BRL	decimal	☐
rate_BSD	decimal	☐
rate_BTC	decimal	☐
rate_BTN	decimal	☐
rate_BTS	decimal	☐
rate_BWP	decimal	☐
rate_BYN	decimal	☐
rate_BZD	decimal	☐
rate_CAD	decimal	☐
rate_CDF	decimal	☐
rate_CHF	decimal	☐
rate_CLF	decimal	☐
rate_CLP	decimal	☐
rate_CNH	decimal	☐
rate_CNY	decimal	☐
rate_COP	decimal	☐
rate_CRC	decimal	☐
rate_CUC	decimal	☐
rate_CUP	decimal	☐
rate_CVE	decimal	☐
rate_CZK	decimal	☐
rate_DASH	decimal	☐
rate_DJF	decimal	☐
rate_DKK	decimal	☐
rate_DOGE	decimal	☐
rate_DOP	decimal	☐
rate_DZD	decimal	☐
rate_EAC	decimal	☐
rate_EGP	decimal	☐
rate_EMC	decimal	☐
rate_ERN	decimal	☐
rate_ETB	decimal	☐
rate_ETH	decimal	☐
rate_EUR	decimal	☐
rate_FCT	decimal	☐
rate_FJD	decimal	☐
rate_FKP	decimal	☐
rate_FTC	decimal	☐
rate_GBP	decimal	☐
rate_GEL	decimal	☐
rate_GGP	decimal	☐
rate_GHS	decimal	☐
rate_GIP	decimal	☐
rate_GMD	decimal	☐
rate_GNF	decimal	☐
rate_GTQ	decimal	☐
rate_GYD	decimal	☐
rate_HKD	decimal	☐
rate_HNL	decimal	☐
rate_HRK	decimal	☐
rate_HTG	decimal	☐
rate_HUF	decimal	☐
rate_IDR	decimal	☐
rate_ILS	decimal	☐
rate_IMP	decimal	☐
rate_INR	decimal	☐
rate_IQD	decimal	☐
rate_IRR	decimal	☐
rate_ISK	decimal	☐
rate_JEP	decimal	☐
rate_JMD	decimal	☐
rate_JOD	decimal	☐
rate_JPY	decimal	☐
rate_KES	decimal	☐
rate_KGS	decimal	☐
rate_KHR	decimal	☐
rate_KMF	decimal	☐
rate_KPW	decimal	☐
rate_KRW	decimal	☐
rate_KWD	decimal	☐
rate_KYD	decimal	☐
rate_KZT	decimal	☐
rate_LAK	decimal	☐
rate_LBP	decimal	☐
rate_LD	decimal	☐
rate_LKR	decimal	☐
rate_LRD	decimal	☐
rate_LSL	decimal	☐
rate_LTC	decimal	☐
rate_LYD	decimal	☐
rate_MAD	decimal	☐
rate_MDL	decimal	☐
rate_MGA	decimal	☐
rate_MKD	decimal	☐
rate_MMK	decimal	☐
rate_MNT	decimal	☐
rate_MOP	decimal	☐
rate_MRO	decimal	☐
rate_MRU	decimal	☐
rate_MUR	decimal	☐
rate_MVR	decimal	☐
rate_MWK	decimal	☐
rate_MXN	decimal	☐
rate_MYR	decimal	☐
rate_MZN	decimal	☐
rate_NAD	decimal	☐
rate_NGN	decimal	☐
rate_NIO	decimal	☐
rate_NMC	decimal	☐
rate_NOK	decimal	☐
rate_NPR	decimal	☐
rate_NVC	decimal	☐
rate_NXT	decimal	☐
rate_NZD	decimal	☐
rate_OMR	decimal	☐
rate_PAB	decimal	☐
rate_PEN	decimal	☐
rate_PGK	decimal	☐
rate_PHP	decimal	☐
rate_PKR	decimal	☐
rate_PLN	decimal	☐
rate_PPC	decimal	☐
rate_PYG	decimal	☐
rate_QAR	decimal	☐
rate_RON	decimal	☐
rate_RSD	decimal	☐
rate_RUB	decimal	☐
rate_RWF	decimal	☐
rate_SAR	decimal	☐
rate_SBD	decimal	☐
rate_SCR	decimal	☐
rate_SDG	decimal	☐
rate_SEK	decimal	☐
rate_SGD	decimal	☐
rate_SHP	decimal	☐
rate_SLL	decimal	☐
rate_SOS	decimal	☐
rate_SRD	decimal	☐
rate_SSP	decimal	☐
rate_STD	decimal	☐
rate_STN	decimal	☐
rate_STR	decimal	☐
rate_SVC	decimal	☐
rate_SYP	decimal	☐
rate_SZL	decimal	☐
rate_THB	decimal	☐
rate_TJS	decimal	☐
rate_TMT	decimal	☐
rate_TND	decimal	☐
rate_TOP	decimal	☐
rate_TRY	decimal	☐
rate_TTD	decimal	☐
rate_TWD	decimal	☐
rate_TZS	decimal	☐
rate_UAH	decimal	☐
rate_UGX	decimal	☐
rate_USD	decimal	☐
rate_UYU	decimal	☐
rate_UZS	decimal	☐
rate_VEF_BLKMKT	decimal	☐
rate_VEF_DICOM	decimal	☐
rate_VEF_DIPRO	decimal	☐
rate_VEF	decimal	☐
rate_VES	decimal	☐
rate_VND	decimal	☐
rate_VTC	decimal	☐
rate_VUV	decimal	☐
rate_WST	decimal	☐
rate_XAF	decimal	☐
rate_XAG	decimal	☐
rate_XAU	decimal	☐
rate_XCD	decimal	☐
rate_XDR	decimal	☐
rate_XMR	decimal	☐
rate_XOF	decimal	☐
rate_XPD	decimal	☐
rate_XPF	decimal	☐
rate_XPM	decimal	☐
rate_XPT	decimal	☐
rate_XRP	decimal	☐
rate_YER	decimal	☐
rate_ZAR	decimal	☐
rate_ZMW	decimal	☐
rate_ZWL	decimal	☐
start_date	datetime	☐

15-06-2022 20:38 Version 22.0.232-PROD+3445

Please enable JavaScript to view this site.

Open Exchange Rates API Data Model

RateTimeSeriesByDateRangeAndBase: Open Exchange Rates Exchange Rate Time Series by Date Range and Base Currency

Parameters of Table Function

Table Function Columns

Important Safety and Usage Information