Query DB Gold Short ETN (DGZ) Historical Prices with this API

Introduction

In the world of finance, the ability to access and analyze historical prices is crucial for making informed investment decisions. For those interested in the Query DB Gold Short ETN (DGZ), understanding how to retrieve historical prices is essential. This blog post will explore how to utilize the Metals-API to access historical price data for gold and other precious metals. With its innovative features and real-time capabilities, the Metals-API empowers developers to create advanced applications that can analyze market trends and provide valuable insights.

Metals-API Information

About Gold (XAU)

Gold, represented by the symbol XAU, has long been a safe haven for investors. As digital transformation sweeps through the financial sector, the integration of technology in trading precious metals has become increasingly important. The Metals-API provides a robust platform for accessing real-time and historical data, allowing developers to leverage data analytics for market insights. By utilizing this API, developers can innovate in price discovery and create digital asset solutions that enhance trading strategies.

API Description

The Metals-API is a powerful tool designed for developers seeking to access real-time and historical data on precious metals. With its extensive capabilities, the API allows for seamless integration into applications, enabling developers to build next-generation solutions. The API supports a variety of endpoints, each tailored to meet specific data retrieval needs. Whether you are looking for the latest rates, historical data, or conversion capabilities, the Metals-API has you covered. For more detailed information, you can refer to the Metals-API Documentation.

Key Features and Endpoints

The Metals-API offers a range of endpoints that cater to various data needs:

• Latest Rates Endpoint: This endpoint provides real-time exchange rate data, updated based on your subscription plan. Depending on the plan, updates can occur every 60 minutes or every 10 minutes, ensuring you have access to the most current market information.
• Historical Rates Endpoint: Access historical rates dating back to 2019 by appending a specific date to your query. This feature is invaluable for analyzing past market trends and making informed predictions.
• Bid And Ask Endpoint: Retrieve real-time bid and ask prices, allowing you to gauge market sentiment and make timely trading decisions.
• Convert Endpoint: This endpoint enables you to convert amounts between different currencies, facilitating transactions across various markets.
• Time-Series Endpoint: Query daily historical rates between two dates of your choice, providing a comprehensive view of market fluctuations over time.
• Fluctuation Endpoint: Track how currencies fluctuate on a day-to-day basis, offering insights into market volatility.
• Carat Endpoint: Retrieve information about gold rates by carat, which is essential for jewelers and investors in the jewelry market.
• Lowest/Highest Price Endpoint: Query the API to get the lowest and highest prices for a specific date, helping you identify market extremes.
• Open/High/Low/Close (OHLC) Price Endpoint: Get detailed OHLC data for a specific time period, which is crucial for technical analysis.
• Historical LME Endpoint: Access historical rates for LME symbols dating back to 2008, providing a broader context for market analysis.
• API Key: Your unique API key is essential for accessing the API's features and must be included in your requests.
• API Response: The API delivers exchange rates relative to USD, ensuring consistency in data interpretation.
• Available Endpoints: With 14 different endpoints, the Metals-API offers a comprehensive suite of functionalities tailored to meet diverse data needs.
• Supported Symbols Endpoint: Access a constantly updated list of all available currencies and metals, ensuring you have the latest information at your fingertips.

List of Symbols

The Metals-API provides access to a comprehensive range of metal symbols. For a complete list of all supported symbols and their specifications, refer to the Metals-API Supported Symbols page. This resource is invaluable for developers looking to integrate specific metals into their applications.

API Endpoint Examples and Responses

Understanding the API responses is crucial for effective implementation. Below are examples of various endpoints and their corresponding JSON responses:

Latest Rates Endpoint

Get real-time exchange rates for all available metals:

{
"success": true,
"timestamp": 1783556352,
"base": "USD",
"date": "2026-07-09",
"rates": {
"XAU": 0.000482,
"XAG": 0.03815,
"XPT": 0.000912,
"XPD": 0.000744,
"XCU": 0.294118,
"XAL": 0.434783,
"XNI": 0.142857,
"XZN": 0.344828
},
"unit": "per troy ounce"
}

This response indicates a successful query, providing the current exchange rates for various metals relative to USD.

Historical Rates Endpoint

Access historical exchange rates for any date since 1999:

{
"success": true,
"timestamp": 1783469952,
"base": "USD",
"date": "2026-07-08",
"rates": {
"XAU": 0.000485,
"XAG": 0.03825,
"XPT": 0.000915,
"XPD": 0.000748
},
"unit": "per troy ounce"
}

This response provides historical rates, allowing developers to analyze past market performance.

Time-series Endpoint

Get exchange rates for a specific time period:

{
"success": true,
"timeseries": true,
"start_date": "2026-07-02",
"end_date": "2026-07-09",
"base": "USD",
"rates": {
"2026-07-02": {
"XAU": 0.000485,
"XAG": 0.03825,
"XPT": 0.000915
},
"2026-07-04": {
"XAU": 0.000483,
"XAG": 0.0382,
"XPT": 0.000913
},
"2026-07-09": {
"XAU": 0.000482,
"XAG": 0.03815,
"XPT": 0.000912
}
},
"unit": "per troy ounce"
}

This response provides a time-series view of exchange rates, which is essential for trend analysis.

Convert Endpoint

Convert any amount from one metal to another or to/from USD:

{
"success": true,
"query": {
"from": "USD",
"to": "XAU",
"amount": 1000
},
"info": {
"timestamp": 1783556352,
"rate": 0.000482
},
"result": 0.482,
"unit": "troy ounces"
}

This response shows the conversion of USD to gold, providing the equivalent amount in troy ounces.

Fluctuation Endpoint

Track rate fluctuations between two dates:

{
"success": true,
"fluctuation": true,
"start_date": "2026-07-02",
"end_date": "2026-07-09",
"base": "USD",
"rates": {
"XAU": {
"start_rate": 0.000485,
"end_rate": 0.000482,
"change": -3.0e-6,
"change_pct": -0.62
},
"XAG": {
"start_rate": 0.03825,
"end_rate": 0.03815,
"change": -0.0001,
"change_pct": -0.26
},
"XPT": {
"start_rate": 0.000915,
"end_rate": 0.000912,
"change": -3.0e-6,
"change_pct": -0.33
}
},
"unit": "per troy ounce"
}

This response provides insights into how rates have changed over a specified period, which is crucial for understanding market dynamics.

OHLC (Open/High/Low/Close) Endpoint

Get OHLC data for a specific time period:

{
"success": true,
"timestamp": 1783556352,
"base": "USD",
"date": "2026-07-09",
"rates": {
"XAU": {
"open": 0.000485,
"high": 0.000487,
"low": 0.000481,
"close": 0.000482
},
"XAG": {
"open": 0.03825,
"high": 0.0383,
"low": 0.0381,
"close": 0.03815
},
"XPT": {
"open": 0.000915,
"high": 0.000918,
"low": 0.00091,
"close": 0.000912
}
},
"unit": "per troy ounce"
}

This response provides a comprehensive view of the market's performance over a specific period, essential for traders and analysts.

Bid/Ask Endpoint

Get current bid and ask prices for metals:

{
"success": true,
"timestamp": 1783556352,
"base": "USD",
"date": "2026-07-09",
"rates": {
"XAU": {
"bid": 0.000481,
"ask": 0.000483,
"spread": 2.0e-6
},
"XAG": {
"bid": 0.0381,
"ask": 0.0382,
"spread": 0.0001
},
"XPT": {
"bid": 0.000911,
"ask": 0.000913,
"spread": 2.0e-6
}
},
"unit": "per troy ounce"
}

This response provides the current bid and ask prices, which are crucial for executing trades effectively.

Conclusion

In conclusion, the Metals-API offers a comprehensive suite of features that empower developers to access and analyze historical prices for gold and other precious metals. By leveraging the various endpoints, developers can create applications that provide real-time insights and facilitate informed trading decisions. Whether you are interested in the latest rates, historical data, or conversion capabilities, the Metals-API is an invaluable resource. For more information, visit the Metals-API Website and explore the Metals-API Documentation for detailed guidance on implementation. Understanding how to utilize this API effectively can significantly enhance your trading strategies and market analysis capabilities.