pool_name

, round(sum(amount_usd)/1000000) as total_volume_million

, round(avg(amount_usd)) as avg_volume

from ethereum.dex_swaps

where platform like '%uniswap-v2%'

and date_trunc('day',block_timestamp) > date_trunc('month',current_date) - interval '6 Month'

and amount_usd > 0

group by 1

order by 2 desc

limit 5