Retrieve Detailed abrdn Physical Gold Shares ETF (SGOL) Historical Prices through this API

In the world of investment, particularly in precious metals, having access to accurate and timely data is crucial. For those interested in the abrdn Physical Gold Shares ETF (SGOL), retrieving historical prices can provide valuable insights into market trends and investment performance. One of the most effective ways to access this data is through the Metals-API, a powerful tool designed for developers and financial analysts alike. This blog post will explore how to leverage the Metals-API to retrieve detailed historical prices for SGOL, while also delving into the broader context of gold trading and the innovative technology that supports it.

About Gold (XAU)

Gold has long been considered a safe haven asset, especially during times of economic uncertainty. As digital transformation sweeps through the financial sector, the integration of technology in trading precious metals is becoming increasingly important. The Metals-API not only provides real-time data but also empowers developers to create applications that utilize data analytics for market insights. By harnessing the power of technology, traders can innovate in price discovery and develop digital asset solutions that enhance their trading strategies.

With the rise of data analytics, understanding market trends and fluctuations in gold prices has never been easier. The Metals-API offers a suite of endpoints that allow users to access a wealth of information about gold and other precious metals. This includes real-time rates, historical data, and even news articles related to market movements. By utilizing these features, developers can build applications that provide comprehensive insights into the gold market.

API Description

The Metals-API is a robust platform that provides real-time and historical data for various metals, including gold (XAU). This API is designed to empower developers to create next-generation applications that can analyze and visualize metal prices effectively. With its innovative capabilities, the Metals-API transforms how users interact with metals data, making it easier to access and utilize for trading and investment purposes.

For detailed information on how to use the API, developers can refer to the Metals-API Documentation, which outlines the various endpoints and their functionalities. Additionally, the Metals-API Supported Symbols page provides a comprehensive list of all available metal symbols, ensuring that users can easily find the data they need.

Key Features and Endpoints

The Metals-API offers a variety of endpoints that cater to different data needs. Here are some of the key features:

Latest Rates Endpoint: This endpoint provides real-time exchange rate data for metals, updated based on your subscription plan. Depending on the plan, updates can occur every 60 minutes or every 10 minutes, allowing traders to stay informed about the latest market conditions.
Historical Rates Endpoint: Users can access historical rates dating back to 2019. By appending a specific date in the format YYYY-MM-DD, developers can query the API for past rates, which is essential for analyzing trends over time.
Bid And Ask Endpoint: This feature allows users to retrieve real-time bid and ask prices for metals, providing insight into the current market spread and helping traders make informed decisions.
Convert Endpoint: The API includes a currency conversion endpoint that enables users to convert amounts from one metal to another or to/from USD. This is particularly useful for traders dealing with multiple currencies.
Time-Series Endpoint: This endpoint allows users to query daily historical rates between two specified dates, making it easier to analyze price movements over specific periods.
Fluctuation Endpoint: Users can track how metal prices fluctuate on a day-to-day basis, providing insights into volatility and market dynamics.
Carat Endpoint: This feature provides information about gold rates by carat, which is essential for jewelers and those dealing in gold jewelry.
Lowest/Highest Price Endpoint: Users can query the API to get the lowest and highest prices 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, allowing traders to analyze daily price movements.
Historical LME Endpoint: This endpoint provides access to historical rates for LME symbols dating back to 2008, which is valuable for those interested in industrial metals.
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 API delivers exchange rates relative to USD, ensuring consistency in data interpretation.
Available Endpoints: The Metals-API includes 14 endpoints, each serving a different purpose, allowing users to tailor their data requests to their specific needs.
News Endpoint: This feature allows users to retrieve the latest news articles related to various metals, keeping traders informed about market developments.

API Endpoint Examples and Responses

Understanding how to interact with the Metals-API is crucial for developers. 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": 1777767633,
"base": "USD",
"date": "2026-05-03",
"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

Access historical exchange rates for any date since 1999.

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

Time-series Endpoint

Get exchange rates for a specific time period.

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

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": 1777767633,
"rate": 0.000482
},
"result": 0.482,
"unit": "troy ounces"
}

Fluctuation Endpoint

Track rate fluctuations between two dates.

{
"success": true,
"fluctuation": true,
"start_date": "2026-04-26",
"end_date": "2026-05-03",
"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) Endpoint

Get OHLC data for a specific time period.

{
"success": true,
"timestamp": 1777767633,
"base": "USD",
"date": "2026-05-03",
"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

Get current bid and ask prices for metals.

{
"success": true,
"timestamp": 1777767633,
"base": "USD",
"date": "2026-05-03",
"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

In conclusion, the Metals-API offers a comprehensive suite of tools for developers looking to retrieve detailed historical prices for the abrdn Physical Gold Shares ETF (SGOL) and other precious metals. By leveraging the various endpoints, users can access real-time data, historical rates, and valuable market insights that can enhance their trading strategies. The integration of technology in the precious metals market is transforming how traders operate, making it essential for developers to stay informed about the latest advancements.

For those interested in diving deeper into the capabilities of the Metals-API, the Metals-API Documentation is an invaluable resource. Additionally, the Metals-API Supported Symbols page provides a complete list of available symbols, ensuring that users can easily find the data they need. As the financial landscape continues to evolve, embracing these technological advancements will be key to successful trading in precious metals.

Ready to use Metals-API?

Try it now!

Retrieve Detailed abrdn Physical Gold Shares ETF (SGOL) Historical Prices through this API