Webvar
Foreign Exchange Rates | Federal Reserve Board - logo

Foreign Exchange Rates | Federal Reserve Board

Federal Reserve Board's data download program provides free and open access to various financial and economic data. This listing contains daily exchange rates of major currencies against the U.S. dollar for the past 10 business days. The data are noon buying rates in New York for cable transfers payable in the listed currencies.

Available in

AWS Marketplace

Available in

AWS Marketplace

Purchase this listing from Webvar in AWS Marketplace using your AWS account. In AWS Marketplace, you can quickly launch pre-configured software with just a few clicks. AWS handles billing and payments, and charges on your AWS bill.

About

This release contains daily exchange rates of major currencies against the U.S. dollar for the past 10 business days. The data are noon buying rates in New York for cable transfers payable in the listed currencies. The following exchange rates are certified by the Federal Reserve Bank of New York for customs purposes as required by section 522 of the amended Tariff Act of 1930. These rates are also those required by the SEC for the integrated disclosure system for foreign private issuers. The information is based on data collected by the Federal Reserve Bank of New York from a sample of market participants. As part of this listing, the exchange rate data are updated every Monday at 5:20 p.m. Data are available up through Friday of the previous business week.

This data is part of U.S. Government Work. The structure of the original data is slightly modified to comply with SQL without modifying the actual data. This data is anonymized/aggregated.

# More Information:

- [Source - Federal Reserve Board's Data Download Program](https://www.federalreserve.gov/releases/h10/current/)

- [Schema Definitions](https://s3.amazonaws.com/rearc-data-provider/foreign-exchange-rates/public/foreign-exchange-rates-schema.docx)

- [Sample Dataset](https://s3.amazonaws.com/rearc-data-provider/foreign-exchange-rates/public/sample.csv)

- [Terms of Use](https://www.usa.gov/government-works)

- [Federal Reserve Board Data Homepage](https://www.federalreserve.gov/data.htm)

- Frequency: Weekly (Every Monday @5:30 PM EST)

# What's included?

You will receive access to the following:

- Foreign exchange rates of major currencies against the U.S. dollar for the past 10 business days (foreign-exchange-rates.csv)

### Here are some sample Athena SQL queries you can try on the dataset.

**# list exchange rate for yuan per US dollar**

```bash

SELECT "time_period", "china_yuan_per_us_dollar" FROM "foreign_exchange_rates"."data";

```

**# list exchange rates for all countries against the US dollar for a specific date**

```bash

SELECT * FROM "foreign_exchange_rates"."data" WHERE "time_period" = date '2019-05-03';

```

**# compare exchange rate for Japanese yen and Hong Kong dollar for a specific date**

```bash

SELECT "time_period", "japan_yen_per_us_dollar", "hongkong_hkd_per_us_dollar" FROM "foreign_exchange_rates"."data" WHERE "time_period" = date '2019-05-01';

```

**# compare all exchange rates between 2 specific dates**

```bash

SELECT * FROM "foreign_exchange_rates"."data" WHERE "time_period" IN (date '2019-05-01', date '2019-05-02');

```

## Contact Information

If you have questions about the source data, please contact [here](https://www.federalreserve.gov/apps/contactus/feedback.aspx). If you have any questions please contact data@rearc.io.

## About Rearc

Rearc is a cloud, software and services company. We believe that empowering engineers drives innovation. Cloud-native architectures, modern software and data practices, and the ability to safely experiment can enable engineers to realize their full potential. We have partnered with several enterprises and startups to help them achieve agility. Our approach is simple — empower engineers with the best tools possible to make an impact within their industry.

Related Products

How it works?

Search

Search 25000+ products and services vetted by AWS.

Request private offer

Our team will send you an offer link to view.

Purchase

Accept the offer in your AWS account, and start using the software.

Manage

All your transactions will be consolidated into one bill in AWS.

Create Your Marketplace with Webvar!

Launch your marketplace effortlessly with our solutions. Optimize sales processes and expand your reach with our platform.