recipient "Swapper",

count (distinct (tx_hash)) "Swaps 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 block_timestamp >= current_date - interval '2 weeks'

group by 1

having "Volume (USD)" > 0

order by 3 desc

limit 10