pool_name,

pool_address,

count (distinct (tx_hash)) as swaps_number,

count (distinct (recipient)) as swappers_number,

sum(iff(amount0_usd > 0, amount0_usd , -1 * amount0_usd)) as total_amount_usd,

avg(iff(amount0_usd > 0, amount0_usd , -1 * amount0_usd)) as average_amount_usd,

median(iff(amount0_usd > 0, amount0_usd , -1 * amount0_usd)) as median_amount_usd

from ethereum.uniswapv3.ez_swaps

where block_timestamp::date between '2022-11-01' and '2022-11-07'

and amount0_usd > 0

group by pool_name, pool_address

select * from maintable

order by total_amount_usd desc

limit 10