token0_symbol "Symbol",

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

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

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

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

from ethereum.uniswapv3.ez_swaps

where 1 = 1

and block_timestamp >= current_date - interval '2 weeks'

and "Symbol" is not null

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

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

group by 1

order by 2 desc

limit 10