SELECT
SYMBOL_IN AS token_in,
SYMBOL_OUT AS token_out,
SUM(AMOUNT_OUT_USD) AS total_volume,
COUNT(DISTINCT TX_HASH) AS swaps,
COUNT(DISTINCT ORIGIN_FROM_ADDRESS) AS tradoors
FROM
ETHEREUM.defi.ez_dex_swaps
WHERE
AMOUNT_IN_USD IS NOT NULL
AND AMOUNT_OUT_USD IS NOT NULL
AND block_timestamp >= DATE '2023-08-01'
AND block_timestamp <= CURRENT_DATE
AND token_in = '0x6c3ea9036406852006290770bedfcaba0e23a0e8' --pyusd token address
GROUP BY
token_in,
token_out,
SYMBOL_OUT,
SYMBOL_IN
ORDER BY
total_volume DESC
LIMIT
5