get_latest_trading_volume_by_aggregator
Retrieve 24-hour and 7-day trading volume data segmented by aggregator for DEX metrics analysis and reporting.
Instructions
Retrieve the latest 24-hour and 7-day trading volume by aggregator.
Args:
limit (int, optional): Maximum number of rows to retrieve from the query. Defaults to 1000.
Returns:
str: A markdown-formatted 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_latest_trading_volume_by_aggregator"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No |
Implementation Reference
- main.py:65-83 (handler)Handler function for the 'get_latest_trading_volume_by_aggregator' tool. Decorated with @mcp.tool() for registration. Fetches latest trading volume data by aggregator from Dune query ID 21689, processes with pandas, and returns a markdown table.
@mcp.tool() def get_latest_trading_volume_by_aggregator(limit: int = 1000) -> str: """ Retrieve the latest 24-hour and 7-day trading volume by aggregator. Args: limit (int, optional): Maximum number of rows to retrieve from the query. Defaults to 1000. Returns: str: A markdown-formatted table of trading volume data, or an error message if the query fails. """ try: data = get_latest_result(21689, limit=limit) df = pd.DataFrame(data) df = df.set_index("Rank") df = df.sort_index(ascending=True) return df.to_markdown() except Exception as e: return str(e) - main.py:21-43 (helper)Helper function used by the tool to fetch the latest execution results from a specified Dune Analytics query ID.
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