token0_symbol "Token",

count (distinct (tx_hash)) "Swaps Count",

count (distinct (recipient)) "Swappers Count",

sum(abs(amount0_usd)) "Volume (USD)",

avg(abs(amount0_usd)) "Average Volume (USD)",

median(abs(amount0_usd)) "Median Amount (USD)"

from ethereum.uniswapv3.ez_swaps

where 1 = 1

and token0_symbol is not null

and amount0_usd > 0

and block_timestamp >= current_date - interval '2 weeks'

group by 1

order by 4 desc

limit 10