get_weekly_trading_volume_by_chain
Retrieve weekly trading volume data segmented by blockchain to analyze DEX performance trends across different networks.
Instructions
Retrieve weekly trading volume by blockchain.
Args:
limit (int, optional): Maximum number of rows to retrieve from the query. Defaults to 1000.
Returns:
str: A markdown-formatted pivot table of trading volume data, or an error message if the query fails.
Tool call template
This tool declares no required parameters. Add optional parameters from the input schema as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {},
"name": "get_weekly_trading_volume_by_chain"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No |
Implementation Reference
- main.py:85-104 (handler)The handler function for the 'get_weekly_trading_volume_by_chain' tool, registered via @mcp.tool() decorator. It fetches data from Dune Analytics query ID 2180075, processes it into a pivot table (date by blockchain, usd_volume), sorts by date descending, and returns a markdown table. Includes input validation via type hints and docstring, error handling.
@mcp.tool() def get_weekly_trading_volume_by_chain(limit: int = 1000) -> str: """ Retrieve weekly trading volume by blockchain. Args: limit (int, optional): Maximum number of rows to retrieve from the query. Defaults to 1000. Returns: str: A markdown-formatted pivot table of trading volume data, or an error message if the query fails. """ try: data = get_latest_result(2180075, limit=limit) df = pd.DataFrame(data) df["date"] = pd.to_datetime(df["_col1"]).dt.date pivot_df = df.pivot(index="date", columns="blockchain", values="usd_volume") pivot_df = pivot_df.sort_index(ascending=False) return pivot_df.to_markdown() except Exception as e: return str(e) - main.py:21-43 (helper)Supporting helper function used by the tool to retrieve latest execution results from a specified Dune Analytics query via the Dune API, handling HTTP requests and parsing JSON response.
def get_latest_result(query_id: int, limit: int = 1000) -> list: """ Fetch the latest results from a Dune Analytics query. Args: query_id (int): The ID of the Dune query to fetch results from. limit (int, optional): Maximum number of rows to return. Defaults to 1000. Returns: list: A list of dictionaries containing the query results, or an empty list if the request fails. Raises: httpx.HTTPStatusError: If the API request fails due to a client or server error. """ url = f"{BASE_URL}/query/{query_id}/results" params = {"limit": limit} with httpx.Client() as client: response = client.get(url, params=params, headers=HEADERS, timeout=300) response.raise_for_status() data = response.json() result_data = data.get("result", {}).get("rows", []) return result_data - main.py:85-85 (registration)The @mcp.tool() decorator registers the get_weekly_trading_volume_by_chain function as an MCP tool in the FastMCP server.
@mcp.tool()