select

upper(symbol) as symbol,

count(distinct(tx_hash))/count(distinct block_timestamp::date) as daily_tx,

sum(amount_out)/count(distinct block_timestamp::date) as daily_vol

from ethereum.defi.ez_dex_swaps a

-- join solana.core.dim_labels b

left join ethereum.core.dim_contracts b

on a.token_in = b.address

where block_timestamp::date BETWEEN '2021-03-01' and '2021-04-01'

and token_out = '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48'

and amount_in > 0

and amount_out > 0

group by 1

order by daily_vol desc

limit 5