In this section, we showcase how the AI Agent processes a user query and returns a structured response based on the query.
User Query:
Which address on Ethereum was the most active in the last 24 hours.
D.A.T.A framework generated query:
{
"sql": {
"query": "WITH address_activity AS (\n SELECT\n from_address AS address,\n COUNT(*) AS tx_count\n FROM\n eth.transactions\n WHERE date_parse(date, '%Y-%m-%d') >= date_add('day', -1, current_date)\n GROUP BY\n from_address\n UNION ALL\n SELECT\n to_address AS address,\n COUNT(*) AS tx_count\n FROM\n eth.transactions\n WHERE\n date_parse(date, '%Y-%m-%d') >= date_add('day', -1, current_date)\n GROUP BY\n to_address\n)\nSELECT\n address,\n SUM(tx_count) AS total_transactions\nFROM\n address_activity\nGROUP BY\n address\nORDER BY\n total_transactions DESC\nLIMIT 1;",
"explanation": "This query identifies the most active Ethereum address in the last 24 hours by counting transactions where the address was either the sender (from_address) or the receiver (to_address). The results are aggregated and ordered by the total number of transactions, with the most active address returned.",
"timeRange": "Last 24 hours"
},
"analysis": {
"overview": {
"totalTransactions": "Number of transactions involving the most active address",
"timeSpan": "Last 24 hours",
"keyMetrics": ["Total transactions involving the address", "Address activity rank"]
},
"patterns": {
"transactionPatterns": ["High frequency of transactions", "Potential bot or automated activity"],
"addressBehavior": ["Possible exchange or DeFi protocol address", "High volume of incoming/outgoing transactions"],
"temporalTrends": ["Peak activity during specific hours", "Consistent transaction frequency"]
},
"statistics": {
"averages": {
"transactionsPerHour": "Average transactions per hour for the address"
},
"distributions": {
"transactionTypes": ["Incoming vs outgoing transactions", "Smart contract interactions"]
},
"anomalies": ["Unusual spikes in transaction volume", "Sudden changes in activity patterns"]
},
"insights": [
"The address may belong to a high-frequency trading bot or a centralized exchange.",
"High transaction volume could indicate market-making activity or arbitrage opportunities."
],
"recommendations": [
"Monitor the address for continued high activity to identify potential market trends.",
"Investigate the nature of transactions (e.g., DeFi interactions, NFT trades) for deeper insights."
]
}
}
D.A.T.A framework query result
%%%% D.A.T.A. Generated SQL query:
WITH address_activity AS (
SELECT
from_address AS address,
COUNT(*) AS tx_count
FROM
eth.transactions
WHERE date_parse(date, '%Y-%m-%d') >= date_add('day', -1, current_date)
GROUP BY
from_address
UNION ALL
SELECT
to_address AS address,
COUNT(*) AS tx_count
FROM
eth.transactions
WHERE
date_parse(date, '%Y-%m-%d') >= date_add('day', -1, current_date)
GROUP BY
to_address
)
SELECT
address,
SUM(tx_count) AS total_transactions
FROM
address_activity
GROUP BY
address
ORDER BY
total_transactions DESC
LIMIT 1;
◎ LOGS
%%%% D.A.T.A. queryResult
{
"success": true,
"data": [
{
"address": "0xdac17f958d2ee523a2206206994597c13d831ec7",
"total_transactions": "118841"
}
],
"metadata": {
"total": 1,
"queryTime": "2025-01-15T08:04:54.644Z",
"queryType": "aggregate",
"executionTime": 0,
"cached": false
}
}
User Query:
What is the gas prive average on Ethereum last 3 days.
User Query:
Which stablecoin had the highest trading volume on Ethereum in the last 24 hours.
Ai Agent return result
Example response when Ai Agent integrate with D.A.T.A.
Example response when Ai Agent integrate with D.A.T.A.
