select

symbol,

sum(raw_amount) as sum_amt,

avg(decimals) as avg_dec

from ethereum.core.ez_token_transfers

where date_trunc('day', block_timestamp) > current_date - interval '7 days'

and symbol is not null

group by 1

order by len(symbol) desc

limit 20