Extract Sprott ESG Gold ETF (SESG) Historical Prices via this API

Extract Sprott ESG Gold ETF (SESG) Historical Prices via this API
In the rapidly evolving world of finance, the demand for accurate and real-time data is paramount, especially when it comes to precious metals like gold. The Sprott ESG Gold ETF (SESG) is a prime example of how investors are increasingly looking for sustainable investment options. To effectively track the historical prices of SESG, developers can leverage the powerful capabilities of the Metals-API. This blog post will delve into the intricacies of obtaining historical prices for gold using the Metals-API, while also exploring the broader context of gold as a digital asset.
About Gold (XAU)
Gold, represented by the symbol XAU, has long been a cornerstone of wealth preservation and investment. In recent years, the digital transformation of precious metals has opened new avenues for investors and developers alike. The integration of data analytics and technology in trading has revolutionized how market insights are derived and utilized. With the rise of digital asset solutions, gold is no longer just a physical commodity; it has become a dynamic digital asset that can be traded and analyzed in real-time.
As the market for gold evolves, the importance of accurate price discovery becomes increasingly critical. The Metals-API provides developers with the tools needed to innovate in this space, enabling them to build applications that can deliver real-time insights and analytics. By utilizing the Metals-API, developers can access a wealth of information about gold prices, fluctuations, and historical data, empowering them to make informed decisions.
API Description
The Metals-API is a comprehensive JSON API that offers real-time and historical data for various metals, including gold, silver, platinum, and palladium. This API is designed to empower developers to create next-generation applications that require accurate and timely metals data. With its innovative features and capabilities, the Metals-API stands out as a transformative tool in the financial technology landscape.
One of the key advantages of the Metals-API is its ability to provide real-time exchange rate data, which is crucial for applications that require up-to-the-minute information. The API's endpoints are designed to cater to a variety of use cases, from simple price retrieval to complex data analysis. By leveraging the Metals-API, developers can build applications that not only track prices but also analyze trends and fluctuations over time.
Key Features and Endpoints
The Metals-API offers a range of endpoints that provide developers with the flexibility to access the data they need. Here are some of the key features:
- Latest Rates Endpoint: Depending on your subscription plan, this endpoint returns real-time exchange rate data updated every 60 minutes, every 10 minutes, or even more frequently. This is essential for applications that require the latest market information.
- Historical Rates Endpoint: Historical rates are available for most currencies dating back to 2019. Developers can query the Metals-API for historical rates by appending a specific date to the endpoint. This feature is particularly useful for analyzing price trends over time.
- Bid And Ask Endpoint: This powerful feature enables developers to retrieve real-time bid and ask prices for various metals, allowing for more informed trading decisions.
- Convert Endpoint: The Metals-API includes a currency conversion endpoint, which can be used to convert any amount from one metal to another or to/from USD. This is particularly useful for applications that require multi-currency support.
- Time-Series Endpoint: This endpoint allows developers to query the API for daily historical rates between two dates of their choice, making it easier to analyze trends over specific periods.
- Fluctuation Endpoint: Developers can retrieve information about how currencies fluctuate on a day-to-day basis, providing insights into market volatility.
- Carat Endpoint: This feature allows developers to retrieve information about gold rates by carat, which is essential for applications focused on jewelry and precious metal trading.
- Lowest/Highest Price Endpoint: This endpoint allows developers to query the API to get the lowest and highest price for a specified date, which is crucial for understanding market extremes.
- Open/High/Low/Close (OHLC) Price Endpoint: This endpoint provides open, high, low, and close prices for a specific date, which is vital for technical analysis.
- Historical LME Endpoint: This endpoint provides access to historical rates for LME symbols dating back to 2008, allowing for comprehensive analysis of market trends.
- API Key: Each user is assigned a unique API key that must be included in requests to authenticate access to the API.
- API Response: The Metals-API delivers exchange rates relative to USD by default, ensuring consistency in data presentation.
- Available Endpoints: The API comes with multiple endpoints, each providing different functionalities tailored to specific needs.
- Supported Symbols Endpoint: This endpoint returns all available currencies and metals, ensuring developers can easily find the symbols they need.
- Gold Price India Endpoint: This dedicated endpoint retrieves the latest gold price in India, catering to regional market needs.
- News Endpoint: The Metals-API allows users to retrieve the latest news articles related to various metals, keeping developers informed about market developments.
API Endpoint Examples and Responses
To illustrate the capabilities of the Metals-API, let's explore some example responses for key endpoints:
Latest Rates Endpoint
{
"success": true,
"timestamp": 1754974827,
"base": "USD",
"date": "2025-08-12",
"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 the latest exchange rates for various metals, with gold (XAU) priced at 0.000482 per troy ounce. Developers can use this data to display current market prices in their applications.
Historical Rates Endpoint
{
"success": true,
"timestamp": 1754888427,
"base": "USD",
"date": "2025-08-11",
"rates": {
"XAU": 0.000485,
"XAG": 0.03825,
"XPT": 0.000915,
"XPD": 0.000748
},
"unit": "per troy ounce"
}
This example shows a historical rate for gold on a specific date, allowing developers to analyze past performance and trends.
Time-Series Endpoint
{
"success": true,
"timeseries": true,
"start_date": "2025-08-05",
"end_date": "2025-08-12",
"base": "USD",
"rates": {
"2025-08-05": {
"XAU": 0.000485,
"XAG": 0.03825,
"XPT": 0.000915
},
"2025-08-07": {
"XAU": 0.000483,
"XAG": 0.0382,
"XPT": 0.000913
},
"2025-08-12": {
"XAU": 0.000482,
"XAG": 0.03815,
"XPT": 0.000912
}
},
"unit": "per troy ounce"
}
This response provides a time series of exchange rates for gold over a specified period, enabling developers to visualize trends and fluctuations.
Convert Endpoint
{
"success": true,
"query": {
"from": "USD",
"to": "XAU",
"amount": 1000
},
"info": {
"timestamp": 1754974827,
"rate": 0.000482
},
"result": 0.482,
"unit": "troy ounces"
}
The Convert Endpoint allows developers to convert amounts between different metals or currencies. In this case, it shows that $1000 converts to 0.482 troy ounces of gold.
Fluctuation Endpoint
{
"success": true,
"fluctuation": true,
"start_date": "2025-08-05",
"end_date": "2025-08-12",
"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 endpoint provides insights into how the price of gold has fluctuated over a specified period, which is crucial for traders looking to capitalize on market movements.
OHLC (Open/High/Low/Close) Price Endpoint
{
"success": true,
"timestamp": 1754974827,
"base": "USD",
"date": "2025-08-12",
"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"
}
The OHLC endpoint provides critical data for technical analysis, allowing traders to assess market performance over a specific period.
Bid/Ask Endpoint
{
"success": true,
"timestamp": 1754974827,
"base": "USD",
"date": "2025-08-12",
"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 for gold, which is essential for traders looking to execute buy or sell orders effectively.
Conclusion
In conclusion, the Metals-API offers a robust and comprehensive solution for developers looking to extract historical prices for the Sprott ESG Gold ETF (SESG) and other precious metals. By leveraging the various endpoints provided by the API, developers can access real-time data, historical trends, and detailed market insights. The integration of technology and data analytics in trading has transformed the landscape of precious metals investment, making it more accessible and efficient.
As the demand for sustainable investment options continues to grow, tools like the Metals-API will play a crucial role in enabling developers to create innovative applications that meet the needs of modern investors. For more information on how to get started with the Metals-API, be sure to check out the Metals-API Documentation and explore the Metals-API Supported Symbols for a complete list of available metals.
With the right tools and insights, developers can harness the power of real-time metals data to drive their applications and provide value to their users. The future of precious metals trading is here, and it is digital.