platform,

count(distinct (pool_name)) as n_pools,

count(1) as n_swaps

ETHEREUM.CORE.EZ_DEX_SWAPS

BLOCK_TIMESTAMP >= '{{start_date}}'

AND block_timestamp <= '{{end_date}}'

GROUP BY

platform

ORDER BY

n_swaps DESC;