Home / Catalog / Government of Canada Open Data

Overview

Foreign exchange rates in Canadian dollars, Bank of Canada, monthly

Monthly foreign exchange rates in Canadian dollars, Bank of Canada. Statistics Canada table 10-10-0009-01.

Source: Government of Canada Open Data
Category: economy
Tags: forexexchange-ratesstatcangovernment-of-canada
Rows: 20,809
Date range: 1950-10 – 2017-04 (ref_date)
Last refresh: 2026-09-20T21:17:10+00:00 (cadence: monthly)
Quality score: 98.1 / 100

commercial use OK freshness: fresh

Data preview

Showing rows 1–100 of 20,809 · page 1 of 209

ref_date	geo	type_of_currency	uom	uom_id	scalar_factor	vector	coordinate	value	terminated	decimals
1950-10	Canada	United States dollar, noon spot rate, average	Dollars	81	units	v37426	1.1	1.05333333	—	8
1950-10	Canada	United States dollar, 90-day forward noon rate	Dollars	81	units	v37437	1.22	1.0473125	—	8
1950-10	Canada	Belgian franc, noon spot rate, average	Dollars	81	units	v37448	1.2	0.0209281	t	8
1950-10	Canada	Danish krone, noon spot rate, average	Dollars	81	units	v37452	1.3	0.15256229	—	8
1950-10	Canada	French franc, noon spot rate, average	Dollars	81	units	v37453	1.4	0.00301389	t	8
1950-10	Canada	German mark, noon spot rate, average	Dollars	81	units	v37454	1.5	0.25075	t	8
1950-10	Canada	Italian lira, noon spot rate, average	Dollars	81	units	v37455	1.6	0.00169967	t	8
1950-10	Canada	Dutch guilder, noon spot rate, average	Dollars	81	units	v37457	1.8	0.27715455	t	8
1950-10	Canada	Norwegian krone, noon spot rate, average	Dollars	81	units	v37427	1.9	0.14747619	—	8
1950-10	Canada	Swedish krona, noon spot rate, average	Dollars	81	units	v37428	1.1	0.20353333	—	8
1950-10	Canada	Swiss franc, noon spot rate, average	Dollars	81	units	v37429	1.11	0.24184286	—	8
1950-10	Canada	United Kingdom pound sterling, noon spot rate, average	Dollars	81	units	v37430	1.12	2.94932381	—	8
1950-10	Canada	Irish pound, noon spot rate, average	Dollars	81	units	v37442	1.13	2.9493	t	4
1950-11	Canada	United States dollar, noon spot rate, average	Dollars	81	units	v37426	1.1	1.0403125	—	8
1950-11	Canada	United States dollar, 90-day forward noon rate	Dollars	81	units	v37437	1.22	1.0362642	—	8
1950-11	Canada	Belgian franc, noon spot rate, average	Dollars	81	units	v37448	1.2	0.02071292	t	8
1950-11	Canada	Danish krone, noon spot rate, average	Dollars	81	units	v37452	1.3	0.15080476	—	8
1950-11	Canada	French franc, noon spot rate, average	Dollars	81	units	v37453	1.4	0.00297358	t	8
1950-11	Canada	German mark, noon spot rate, average	Dollars	81	units	v37454	1.5	0.24765714	t	8
1950-11	Canada	Italian lira, noon spot rate, average	Dollars	81	units	v37455	1.6	0.00167838	t	8
1950-11	Canada	Dutch guilder, noon spot rate, average	Dollars	81	units	v37457	1.8	0.27370833	t	8
1950-11	Canada	Norwegian krone, noon spot rate, average	Dollars	81	units	v37427	1.9	0.14561905	—	8
1950-11	Canada	Swedish krona, noon spot rate, average	Dollars	81	units	v37428	1.1	0.201	—	8
1950-11	Canada	Swiss franc, noon spot rate, average	Dollars	81	units	v37429	1.11	0.23875238	—	8
1950-11	Canada	United Kingdom pound sterling, noon spot rate, average	Dollars	81	units	v37430	1.12	2.91249048	—	8
1950-11	Canada	Irish pound, noon spot rate, average	Dollars	81	units	v37442	1.13	2.9125	t	4
1950-12	Canada	United States dollar, noon spot rate, average	Dollars	81	units	v37426	1.1	1.05307813	—	8
1950-12	Canada	United States dollar, 90-day forward noon rate	Dollars	81	units	v37437	1.22	1.04899671	—	8
1950-12	Canada	Belgian franc, noon spot rate, average	Dollars	81	units	v37448	1.2	0.02095208	t	8
1950-12	Canada	Danish krone, noon spot rate, average	Dollars	81	units	v37452	1.3	0.15266316	—	8
1950-12	Canada	French franc, noon spot rate, average	Dollars	81	units	v37453	1.4	0.00301017	t	8
1950-12	Canada	German mark, noon spot rate, average	Dollars	81	units	v37454	1.5	0.25068333	t	8
1950-12	Canada	Italian lira, noon spot rate, average	Dollars	81	units	v37455	1.6	0.00169883	t	8
1950-12	Canada	Dutch guilder, noon spot rate, average	Dollars	81	units	v37457	1.8	0.277075	t	8
1950-12	Canada	Norwegian krone, noon spot rate, average	Dollars	81	units	v37427	1.9	0.14739474	—	8
1950-12	Canada	Swedish krona, noon spot rate, average	Dollars	81	units	v37428	1.1	0.20344737	—	8
1950-12	Canada	Swiss franc, noon spot rate, average	Dollars	81	units	v37429	1.11	0.24431579	—	8
1950-12	Canada	United Kingdom pound sterling, noon spot rate, average	Dollars	81	units	v37430	1.12	2.94773027	—	8
1950-12	Canada	Irish pound, noon spot rate, average	Dollars	81	units	v37442	1.13	2.9477	t	4
1951-01	Canada	United States dollar, noon spot rate, average	Dollars	81	units	v37426	1.1	1.051875	—	8
1951-01	Canada	United States dollar, 90-day forward noon rate	Dollars	81	units	v37437	1.22	1.04767045	—	8
1951-01	Canada	Belgian franc, noon spot rate, average	Dollars	81	units	v37448	1.2	0.02100231	t	8
1951-01	Canada	Danish krone, noon spot rate, average	Dollars	81	units	v37452	1.3	0.15251818	—	8
1951-01	Canada	French franc, noon spot rate, average	Dollars	81	units	v37453	1.4	0.00300627	t	8
1951-01	Canada	German mark, noon spot rate, average	Dollars	81	units	v37454	1.5	0.25038462	t	8
1951-01	Canada	Italian lira, noon spot rate, average	Dollars	81	units	v37455	1.6	0.00169692	t	8
1951-01	Canada	Dutch guilder, noon spot rate, average	Dollars	81	units	v37457	1.8	0.27676154	t	8
1951-01	Canada	Norwegian krone, noon spot rate, average	Dollars	81	units	v37427	1.9	0.14732273	—	8
1951-01	Canada	Swedish krona, noon spot rate, average	Dollars	81	units	v37428	1.1	0.20335455	—	8
1951-01	Canada	Swiss franc, noon spot rate, average	Dollars	81	units	v37429	1.11	0.24526818	—	8
1951-01	Canada	United Kingdom pound sterling, noon spot rate, average	Dollars	81	units	v37430	1.12	2.94502841	—	8
1951-01	Canada	United States dollar, closing spot rate	Dollars	81	units	v37432	1.24	1.05312499	—	8
1951-01	Canada	United States dollar, highest spot rate	Dollars	81	units	v37433	1.25	1.059375	—	8
1951-01	Canada	United States dollar, lowest spot rate	Dollars	81	units	v37434	1.26	1.0475	—	8
1951-01	Canada	Irish pound, noon spot rate, average	Dollars	81	units	v37442	1.13	2.945	t	4
1951-02	Canada	United States dollar, noon spot rate, average	Dollars	81	units	v37426	1.1	1.049125	—	8
1951-02	Canada	United States dollar, 90-day forward noon rate	Dollars	81	units	v37437	1.22	1.04496875	—	8
1951-02	Canada	Belgian franc, noon spot rate, average	Dollars	81	units	v37448	1.2	0.02093087	t	8
1951-02	Canada	Danish krone, noon spot rate, average	Dollars	81	units	v37452	1.3	0.15215789	—	8
1951-02	Canada	French franc, noon spot rate, average	Dollars	81	units	v37453	1.4	0.00299913	t	8
1951-02	Canada	German mark, noon spot rate, average	Dollars	81	units	v37454	1.5	0.24984348	t	8
1951-02	Canada	Italian lira, noon spot rate, average	Dollars	81	units	v37455	1.6	0.00169316	t	8
1951-02	Canada	Dutch guilder, noon spot rate, average	Dollars	81	units	v37457	1.8	0.27614783	t	8
1951-02	Canada	Norwegian krone, noon spot rate, average	Dollars	81	units	v37427	1.9	0.14701579	—	8
1951-02	Canada	Swedish krona, noon spot rate, average	Dollars	81	units	v37428	1.1	0.20288421	—	8
1951-02	Canada	Swiss franc, noon spot rate, average	Dollars	81	units	v37429	1.11	0.24426316	—	8
1951-02	Canada	United Kingdom pound sterling, noon spot rate, average	Dollars	81	units	v37430	1.12	2.93861842	—	8
1951-02	Canada	United States dollar, closing spot rate	Dollars	81	units	v37432	1.24	1.04531249	—	8
1951-02	Canada	United States dollar, highest spot rate	Dollars	81	units	v37433	1.25	1.05374999	—	8
1951-02	Canada	United States dollar, lowest spot rate	Dollars	81	units	v37434	1.26	1.0440625	—	8
1951-02	Canada	Irish pound, noon spot rate, average	Dollars	81	units	v37442	1.13	2.9386	t	4
1951-03	Canada	United States dollar, noon spot rate, average	Dollars	81	units	v37426	1.1	1.04729687	—	8
1951-03	Canada	United States dollar, 90-day forward noon rate	Dollars	81	units	v37437	1.22	1.04339063	—	8
1951-03	Canada	Belgian franc, noon spot rate, average	Dollars	81	units	v37448	1.2	0.02085167	t	8
1951-03	Canada	Danish krone, noon spot rate, average	Dollars	81	units	v37452	1.3	0.15190667	—	8
1951-03	Canada	French franc, noon spot rate, average	Dollars	81	units	v37453	1.4	0.00299613	t	8
1951-03	Canada	German mark, noon spot rate, average	Dollars	81	units	v37454	1.5	0.24943889	t	8
1951-03	Canada	Italian lira, noon spot rate, average	Dollars	81	units	v37455	1.6	0.00169039	t	8
1951-03	Canada	Dutch guilder, noon spot rate, average	Dollars	81	units	v37457	1.8	0.27567778	t	8
1951-03	Canada	Norwegian krone, noon spot rate, average	Dollars	81	units	v37427	1.9	0.14680667	—	8
1951-03	Canada	Swedish krona, noon spot rate, average	Dollars	81	units	v37428	1.1	0.20256	—	8
1951-03	Canada	Swiss franc, noon spot rate, average	Dollars	81	units	v37429	1.11	0.24302667	—	8
1951-03	Canada	United Kingdom pound sterling, noon spot rate, average	Dollars	81	units	v37430	1.12	2.933875	—	8
1951-03	Canada	United States dollar, closing spot rate	Dollars	81	units	v37432	1.24	1.0496875	—	8
1951-03	Canada	United States dollar, highest spot rate	Dollars	81	units	v37433	1.25	1.05249999	—	8
1951-03	Canada	United States dollar, lowest spot rate	Dollars	81	units	v37434	1.26	1.044375	—	8
1951-03	Canada	Irish pound, noon spot rate, average	Dollars	81	units	v37442	1.13	2.9339	t	4
1951-04	Canada	United States dollar, noon spot rate, average	Dollars	81	units	v37426	1.1	1.0596131	—	8
1951-04	Canada	United States dollar, 90-day forward noon rate	Dollars	81	units	v37437	1.22	1.05598214	—	8
1951-04	Canada	Belgian franc, noon spot rate, average	Dollars	81	units	v37448	1.2	0.0210476	t	8
1951-04	Canada	Danish krone, noon spot rate, average	Dollars	81	units	v37452	1.3	0.15365238	—	8
1951-04	Canada	French franc, noon spot rate, average	Dollars	81	units	v37453	1.4	0.00303408	t	8
1951-04	Canada	German mark, noon spot rate, average	Dollars	81	units	v37454	1.5	0.252356	t	8
1951-04	Canada	Italian lira, noon spot rate, average	Dollars	81	units	v37455	1.6	0.0017102	t	8
1951-04	Canada	Dutch guilder, noon spot rate, average	Dollars	81	units	v37457	1.8	0.278912	t	8
1951-04	Canada	Norwegian krone, noon spot rate, average	Dollars	81	units	v37427	1.9	0.1484619	—	8
1951-04	Canada	Swedish krona, noon spot rate, average	Dollars	81	units	v37428	1.1	0.20485238	—	8
1951-04	Canada	Swiss franc, noon spot rate, average	Dollars	81	units	v37429	1.11	0.24519524	—	8
1951-04	Canada	United Kingdom pound sterling, noon spot rate, average	Dollars	81	units	v37430	1.12	2.96652262	—	8
1951-04	Canada	United States dollar, closing spot rate	Dollars	81	units	v37432	1.24	1.0671875	—	8

Download latest snapshot: CSV JSON Parquet

Fields

Name	Type	Description	Unit / format	Nullable	Example values
`ref_date`	varchar	Reference date — the time period the observation refers to (Statistics Canada table field REF_DATE).	Not documented by source	No	1950-10, 1950-10, 1950-10
`geo`	varchar	Geography the observation covers (Statistics Canada table field GEO).	Not documented by source	No	Canada, Canada, Canada
`type_of_currency`	varchar	Not documented by source	Not documented by source	No	United States dollar, noon spot rate, average, United States dollar, 90-day forward noon rate, Belgian franc, noon spot rate, average
`uom`	varchar	Unit of measure for the estimate (Statistics Canada table field UOM).	Not documented by source	No	Dollars, Dollars, Dollars
`uom_id`	bigint	Unit of measure identifier (Statistics Canada table field UOM_ID).	Not documented by source	No	81, 81, 81
`scalar_factor`	varchar	Scalar factor applied to the value, e.g. units, thousands or millions (Statistics Canada table field SCALAR_FACTOR).	Not documented by source	No	units , units , units
`scalar_id`	bigint	Scalar factor identifier (Statistics Canada table field SCALAR_ID).	Not documented by source	No	0, 0, 0
`vector`	varchar	Vector number — Statistics Canada's unique identifier for the time series (table field VECTOR).	Not documented by source	No	v37426, v37437, v37448
`coordinate`	double	Table coordinate locating the estimate within the source table (Statistics Canada table field COORDINATE).	Not documented by source	No	1.1, 1.22, 1.2
`value`	double	Estimate value as published in the Statistics Canada table.	Not documented by source	No	1.05333333, 1.0473125, 0.0209281
`terminated`	varchar	Whether the series has been terminated (Statistics Canada table field TERMINATED).	Not documented by source	Yes	t, t, t
`decimals`	bigint	Number of decimals published for the estimate (Statistics Canada table field DECIMALS).	Not documented by source	No	8, 8, 8

“Not documented by source” means the provider publishes no per-field documentation — descriptions are never invented.

Snapshots

Snapshot	Timestamp	Rows	Size	Quality	Download
`20260920T211710Z-a402d58c95dc`	2026-09-20T21:17:10+00:00	20,809	202.4 KB	98.1	CSV JSON Parquet

Snapshots are immutable — the content hash is recorded for every version.

Source & license

Provider: Government of Canada Open Data
The Government of Canada's open data portal (open.canada.ca) publishes datasets from federal departments and agencies, including Statistics Canada statistical tables and Canada Border Services Agency operational feeds.
Provider site: https://open.canada.ca
Source data URL: https://open.canada.ca/data/en/dataset/eff192e2-00fc-4487-852c-6ee9f3b2fc26
License: OGL-Canada-2.0 — OK for commercial use. Attribution is required when you use this data.
Commercial use: Yes
Attribution required: Contains information licensed under the Open Government Licence – Canada
Terms: https://open.canada.ca/en/open-government-licence-canada
Refresh cadence: monthly
Provenance: Ingested by the Government of Canada Open Data connector (v1.0.0) from https://open.canada.ca/data/en/dataset/eff192e2-00fc-4487-852c-6ee9f3b2fc26; latest snapshot 20260920T211710Z-a402d58c95dc (sha256 a402d58c95dc…)