token0_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)",

median(abs(amount0_usd)) "Median Amount (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')

group by 1