pool_name,

date_trunc('week',block_timestamp) as week,

COUNT(DISTINCT tx_id) as total_swaps

FROM ethereum.dex_swaps

WHERE

platform='uniswap-v2'

AND

DATE_TRUNC('day',block_timestamp) > getdate()-interval '60 days'

AND

amount_usd<>0

GROUP BY 1,2

ORDER BY 3 DESC

LIMIT 100