get_daily_trading_volume_by_telegram_bot
Fetch daily trading volume data for Telegram bots from Dune Analytics queries and present it in markdown-formatted pivot tables with dates and bot names.
Instructions
Retrieve daily trading volume by Telegram bot.
This tool fetches daily trading volume data for Telegram bots from a Dune Analytics query and returns it in a markdown-formatted pivot table, with dates as the index and bot names as columns.
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_daily_trading_volume_by_telegram_bot"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No |
Implementation Reference
- main.py:241-263 (handler)The handler function for the tool 'get_daily_trading_volume_by_telegram_bot'. Decorated with @mcp.tool() for registration. Fetches data from Dune query 2687239, processes with pandas into a pivot table by date and Telegram bot, returns markdown table or error.
@mcp.tool() def get_daily_trading_volume_by_telegram_bot(limit: int = 1000) -> str: """ Retrieve daily trading volume by Telegram bot. This tool fetches daily trading volume data for Telegram bots from a Dune Analytics query and returns it in a markdown-formatted pivot table, with dates as the index and bot names as columns. 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(2687239, limit=limit) df = pd.DataFrame(data) df["date"] = pd.to_datetime(df["block_date"]).dt.date pivot_df = df.pivot(index="date", columns="bot", values="volumeUSD") pivot_df = pivot_df.sort_index(ascending=False) return pivot_df.to_markdown() except Exception as e: return str(e) - main.py:21-44 (helper)Shared helper function used by the tool to fetch the latest execution results from a specified Dune Analytics query using the Dune API.
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