Foreign Exchange Rates | Federal Reserve Board
Available in
AWS Marketplace
Available in
AWS Marketplace
Available in
AWS Marketplace
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
show moreBuyer guide
Read insights from real user interviews on why they chose this product.
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.