Query editor
1SELECT2 token_pair,3 SUM(amount_usd) AS volume_7d,4 COUNT(*) AS trades,5 SUM(amount_usd)/COUNT(*) AS avg_trade_size6FROM dex.trades7WHERE block_time > NOW() - INTERVAL '7' day8AND blockchain = 'mantle'9GROUP BY 110ORDER BY volume_7d DESC;11
SELECT
token_pair,
SUM(amount_usd) AS volume_7d,
COUNT(*) AS trades,
SUM(amount_usd)/COUNT(*) AS avg_trade_size
FROM dex.trades
WHERE block_time > NOW() - INTERVAL '7' day
AND blockchain = 'mantle'
GROUP BY 1
ORDER BY volume_7d DESC;