Collect Sprott ESG Gold ETF (SESG) Historical Prices utilizing this API

Collect Sprott ESG Gold ETF (SESG) Historical Prices Utilizing this API

The Sprott ESG Gold ETF (SESG) represents a significant step in the evolution of investment strategies focused on environmental, social, and governance (ESG) criteria. As investors increasingly seek to align their portfolios with sustainable practices, understanding the historical prices of gold through reliable data sources becomes essential. One of the most innovative tools available for this purpose is the Metals-API, which provides real-time and historical data on precious metals, including gold (XAU). This blog post will delve into how you can leverage the Metals-API to collect historical prices for SESG and explore the broader implications of digital transformation in the precious metals market.

About Gold (XAU)

Gold has long been regarded as a safe-haven asset, a hedge against inflation, and a store of value. In recent years, the digital transformation of precious metals trading has revolutionized how investors access and analyze gold prices. The integration of data analytics and technology into trading platforms has enabled market participants to gain deeper insights into price movements and trends.

With the rise of digital asset solutions, investors can now track gold prices in real-time, analyze historical data, and make informed decisions based on comprehensive market insights. The Metals-API plays a crucial role in this transformation by providing developers with the tools necessary to build next-generation applications that facilitate seamless access to gold price data.

Metals-API Overview

The Metals-API is a powerful JSON API that offers a wide range of functionalities for accessing metals prices and currency conversion. It empowers developers to create applications that can retrieve real-time and historical data, enabling users to make informed investment decisions. The API supports various endpoints, each designed to cater to specific needs, from fetching the latest rates to analyzing historical trends.

One of the standout features of the Metals-API is its ability to provide historical rates dating back to 2019. This capability is particularly beneficial for investors looking to analyze past performance and identify trends in gold prices. By appending a specific date to the API request, users can access historical data that is crucial for making informed investment decisions.

Key Features and Endpoints

The Metals-API offers a variety of endpoints that cater to different data retrieval needs. 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 or more frequently. This feature is essential for traders who need up-to-the-minute information on gold prices.
• Historical Rates Endpoint: Access historical exchange rates for most currencies dating back to 2019. This endpoint allows users to query the API for historical rates by appending a specific date, making it invaluable for trend analysis.
• Bid and Ask Endpoint: This powerful feature enables users to retrieve real-time bid and ask prices for metals, providing insights into market liquidity and pricing dynamics.
• Convert Endpoint: The Metals-API includes a currency conversion endpoint that allows users to convert any amount from one metal to another or to/from USD, facilitating easy calculations for investors.
• Time-Series Endpoint: Users can query the API for daily historical rates between two dates of their choice, enabling comprehensive analysis of price movements over time.
• Fluctuation Endpoint: This endpoint provides information about 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 particularly useful for jewelers and consumers interested in purchasing gold jewelry.
• Lowest/Highest Price Endpoint: This feature allows users to query the API to get the lowest and highest price for a specified date, aiding in understanding price extremes.
• Open/High/Low/Close (OHLC) Price Endpoint: Users can access OHLC data for a specific time period, which is crucial for technical analysis and trading strategies.
• Historical LME Endpoint: Access historical rates for LME symbols dating back to 2008, providing a broader context for market analysis.
• 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 by default, ensuring consistency in data interpretation.
• Supported Symbols Endpoint: This endpoint returns all available currencies, allowing users to stay updated on the latest symbols supported by the API.
• Gold Price India Endpoint: Retrieve the latest gold price in India using a dedicated endpoint, catering to regional market needs.
• News Endpoint: Stay informed with the latest news articles related to various metals, providing context for market movements.

API Endpoint Examples and Responses

Understanding how to interact with the Metals-API is crucial for developers looking to integrate its capabilities into their applications. Below are examples of various API endpoints and their responses:

Latest Rates Endpoint

{
    "success": true,
    "timestamp": 1756710031,
    "base": "USD",
    "date": "2025-09-01",
    "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"
}

The response above indicates that the latest gold price (XAU) is 0.000482 per troy ounce, providing a snapshot of current market conditions.

Historical Rates Endpoint

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

This example shows how to access historical rates for a specific date, allowing users to analyze past performance and trends.

Time-Series Endpoint

{
    "success": true,
    "timeseries": true,
    "start_date": "2025-08-25",
    "end_date": "2025-09-01",
    "base": "USD",
    "rates": {
        "2025-08-25": {
            "XAU": 0.000485,
            "XAG": 0.03825,
            "XPT": 0.000915
        },
        "2025-08-27": {
            "XAU": 0.000483,
            "XAG": 0.0382,
            "XPT": 0.000913
        },
        "2025-09-01": {
            "XAU": 0.000482,
            "XAG": 0.03815,
            "XPT": 0.000912
        }
    },
    "unit": "per troy ounce"
}

The time-series endpoint allows users to retrieve data over a specified period, making it easier to identify trends and fluctuations in gold prices.

Convert Endpoint

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

This endpoint demonstrates how to convert an amount from one metal to another, providing a clear understanding of the conversion process.

Fluctuation Endpoint

{
    "success": true,
    "fluctuation": true,
    "start_date": "2025-08-25",
    "end_date": "2025-09-01",
    "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"
}

The fluctuation endpoint provides insights into how prices have changed over a specified period, which is crucial for understanding market dynamics.

OHLC (Open/High/Low/Close) Price Endpoint

{
    "success": true,
    "timestamp": 1756710031,
    "base": "USD",
    "date": "2025-09-01",
    "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 endpoint is particularly useful for traders who rely on open, high, low, and close prices to make trading decisions based on technical analysis.

Bid/Ask Endpoint

{
    "success": true,
    "timestamp": 1756710031,
    "base": "USD",
    "date": "2025-09-01",
    "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 illustrates the current bid and ask prices for gold, silver, and platinum, providing essential information for market participants.

Conclusion

In conclusion, the Sprott ESG Gold ETF (SESG) represents a forward-thinking approach to investing in gold while adhering to ESG principles. By utilizing the Metals-API, investors and developers can access a wealth of historical price data and real-time insights that empower informed decision-making. The API's robust features, including the latest rates, historical data, and various conversion options, make it an invaluable tool for anyone involved in the precious metals market.

As the landscape of precious metals trading continues to evolve, embracing technology and data analytics will be crucial for staying ahead in this dynamic market. For further exploration of the API's capabilities, refer to the Metals-API Documentation and the Metals-API Supported Symbols page to discover the full range of available data.

By leveraging the power of the Metals-API, you can unlock the potential of historical gold prices and make strategic investment decisions that align with your financial goals.