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

Extract Sprott ESG Gold ETF (SESG) Historical Prices via this API
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)
API Description
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.
Key Features and Endpoints
- 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
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"
}
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"
}
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"
}
Convert Endpoint
{
"success": true,
"query": {
"from": "USD",
"to": "XAU",
"amount": 1000
},
"info": {
"timestamp": 1754974827,
"rate": 0.000482
},
"result": 0.482,
"unit": "troy ounces"
}
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"
}
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"
}
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"
}
Conclusion
Metals-API Documentation and explore the Metals-API Supported Symbols for a complete list of available metals.