POOL_NAME as "Pool Name",

count(a.*) as "Number of Swaps",

count(distinct FROM_ADDRESS) as "Number of Unique Swappers"

ethereum.uniswapv3.ez_swaps a

left join ethereum.core.fact_transactions b on b.tx_hash = a.tx_hash

where a.BLOCK_TIMESTAMP::date >= current_date - {{Date_Interval}}

and POOL_NAME ilike '%usdc%'

group by 1

order by 2 desc

limit 100