WITH tb1 AS (
SELECT
POOL_NAME,
SYMBOL_IN,
SUM(COALESCE(amount_in_usd, 0)) AS total_volume
FROM
avalanche.defi.ez_dex_swaps
WHERE
block_timestamp >= CURRENT_DATE - INTERVAL '30 days'
GROUP BY
POOL_NAME,
SYMBOL_IN
ORDER BY
total_volume DESC
)
SELECT
SYMBOL_IN,
total_volume
FROM
tb1
ORDER BY
total_volume DESC
LIMIT
10