Foreign exchange rates, United States

Name: Foreign exchange rates, United States
Creator: Government of Canada Open Data
License: https://open.canada.ca/en/open-government-licence-canada
Keywords: forex, exchange-rates, statcan, government-of-canada

Foreign exchange rates for the United States dollar. Statistics Canada table 10-10-0087-01.

Source: Government of Canada Open Data160 rowsUpdated: 9/20/2026License: OGL-Canada-2.0

forexexchange-ratesstatcangovernment-of-canada

Quality

100

Attribution

Contains information licensed under the Open Government Licence – Canada

Schema

Column	Type	Description
ref_date	string	Reference date — the time period the observation refers to (Statistics Canada table field REF_DATE).
geo	string	Geography the observation covers (Statistics Canada table field GEO).
type_of_exchange_rate_united_states	string
uom	string	Unit of measure for the estimate (Statistics Canada table field UOM).
uom_id	integer	Unit of measure identifier (Statistics Canada table field UOM_ID).
scalar_factor	string	Scalar factor applied to the value, e.g. units, thousands or millions (Statistics Canada table field SCALAR_FACTOR).
scalar_id	integer	Scalar factor identifier (Statistics Canada table field SCALAR_ID).
vector	string	Vector number — Statistics Canada's unique identifier for the time series (table field VECTOR).
coordinate	float	Table coordinate locating the estimate within the source table (Statistics Canada table field COORDINATE).
value	float	Estimate value as published in the Statistics Canada table.
decimals	integer	Number of decimals published for the estimate (Statistics Canada table field DECIMALS).

Sample rows

ref_date	geo	type_of_exchange_rate_united_states	uom	uom_id	scalar_factor	vector	coordinate	value	decimals
1952-01	Canada	Canadian cents per United States dollar, spot rate adjusted, by working days	Cents	55	units	v37699	1.1	100.06	2
1952-04	Canada	Canadian cents per United States dollar, spot rate adjusted, by working days	Cents	55	units	v37699	1.1	98.14	2
1952-07	Canada	Canadian cents per United States dollar, spot rate adjusted, by working days	Cents	55	units	v37699	1.1	96.35	2
1952-10	Canada	Canadian cents per United States dollar, spot rate adjusted, by working days	Cents	55	units	v37699	1.1	97.02	2
1953-01	Canada	Canadian cents per United States dollar, spot rate adjusted, by working days	Cents	55	units	v37699	1.1	97.71	2

Use with an LLM

Point any LLM at the metadata endpoint — the documentation above is machine-readable too (JSON-LD + Croissant).

cURL

curl "https://datazimuts.com/v1/datasets/ckan_canada/fx_rates_us" | jq '{title, rows, columns_count, license}'

Python

import requests

ds = requests.get("https://datazimuts.com/v1/datasets/ckan_canada/fx_rates_us").json()
print(ds["title"], ds["rows"], "rows")

# Sample rows for an LLM context window
for row in ds.get("sample_rows", [])[:5]:
    print(row)

API endpoint: https://datazimuts.com/v1/datasets/ckan_canada/fx_rates_us

Tip: fetch /llms.txt for the full machine-readable catalog.