Query editor
1SELECT2 project,3 token_pair,4 SUM(amount_usd) AS volume_usd5FROM dex.trades6WHERE blockchain = 'mantle'7 AND block_time >= NOW() - INTERVAL '30' day8GROUP BY project, token_pair9ORDER BY project, volume_usd DESC;10
SELECT
project,
token_pair,
SUM(amount_usd) AS volume_usd
FROM dex.trades
WHERE blockchain = 'mantle'
AND block_time >= NOW() - INTERVAL '30' day
GROUP BY project, token_pair
ORDER BY project, volume_usd DESC;