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.