CONCAT(LEAST(symbol_in, symbol_out), '-', GREATEST(symbol_in, symbol_out)) AS pair,

SUM(CASE WHEN amount_out_usd IS NULL THEN amount_in_usd ELSE amount_out_usd END) AS total_volume,

COUNT(DISTINCT tx_hash) AS swaps,

COUNT(DISTINCT origin_from_address) AS tradoors

ETHEREUM.defi.ez_dex_swaps

platform LIKE '%uniswap%'

AND block_timestamp >= CURRENT_TIMESTAMP - INTERVAL '24 hours'

GROUP BY

pair

total_volume > 0

ORDER BY

total_volume DESC

10