token1_symbol "Symbol",

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

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

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

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

from ethereum.uniswapv3.ez_swaps

where 1 = 1

and block_timestamp >= current_date - interval '2 weeks'

and token0_symbol in ('USDT', 'USDC', 'DAI', 'BUSD')

and token1_symbol not in ('USDT', 'USDC', 'DAI', 'BUSD')

and token1_symbol is not null

group by 1

having "Volume (USD)" > 0

order by 4 desc

limit 10