pool_name,

platform,

COUNT(DISTINCT tx_id) as swap_volume

FROM ethereum.dex_swaps

WHERE

platform IN ('uniswap-v2','uniswap-v3')

AND

DATE_TRUNC('week',block_timestamp) <= '2022-02-24'

AND

amount_usd<>0

GROUP BY 1,2

ORDER BY 3 DESC

LIMIT 20