SELECT
SYMBOL_OUT AS token_out,
COUNT(DISTINCT tx_hash) AS trade_count
FROM
base.defi.ez_dex_swaps
WHERE
block_timestamp >= current_timestamp - interval '24 hours'
AND AMOUNT_OUT_USD IS NOT NULL
GROUP BY
token_out,
SYMBOL_OUT
ORDER BY
trade_count DESC
LIMIT
10