Query editor
1SELECT2 project_contract_address,3 SUM(amount_usd) AS volume4FROM dex.trades5WHERE6 block_time >= CURRENT_TIMESTAMP - INTERVAL '10' DAY AND blockchain = 'BNB'7GROUP BY8 project_contract_address9ORDER BY10 volume DESC
SELECT
project_contract_address,
SUM(amount_usd) AS volume
FROM dex.trades
WHERE
block_time >= CURRENT_TIMESTAMP - INTERVAL '10' DAY AND blockchain = 'BNB'
GROUP BY
project_contract_address
ORDER BY
volume DESC