ECB Exchange Rates Data Model
The ECB Exchange Rates provides 90 days of history on exchange rates against the European Euro as established daily by the European Central Bank.
Set up this platform in Invantive Cloud: https://cloud.invantive.com/ecb-exchange-rates
Text comparisons on this platform are case sensitive.
Platform
- Used from: Invantive Cloud and the Invantive products on your own computer or server.
- Kind: an application reached over its API.
- The data is partitioned, such as per company or administration.
- Invantive Cloud plans: Free for public data, Office for Entrepreneurs, Office for Accountants, Premium Finance.
- Language of its user community: English.
Figures
| Figure | Count |
|---|---|
| Tables | 2 |
| Columns | 6 |
| Tables with insert | 0 |
| Tables with update | 0 |
| Tables with delete | 0 |
| Tables documented | 0 |
Data Model Poster
This data model declares no keys yet; the dotted relations are derived from column names.
On a table of the poster: plus and minus zoom, the arrow keys move, 0 fits.
The poster as text: tables per topic and their relations
Ecb (without relations)
ecb_euro_exchange_rates_last_90_days, ecb_euro_exchange_rates_last_day
Tables
EcbExchangeRates.EcbExchangeRates
- ecb_euro_exchange_rates_last_90_days: Euro Exchange Rates Last 90 Days
- ecb_euro_exchange_rates_last_day: Euro Exchange Rates Last Day
Sample Queries
--
-- ECB exchange rates against the Euro for the last 90 days.
--
-- Table documentation: https://documentation.invantive.eu/2017R2/ecb-exchange-rates-data-model/webhelp/ecb-exchange-rates-connector-ecb_euro_exchange_rates_last_90_days.html
--
select *
from EcbExchangeRates.EcbExchangeRates.ecb_euro_exchange_rates_last_90_days@exr
limit 100
Attributes
The attributes of this platform are on the page Attributes.
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: