with tb1 as ( select symbol,
count(DISTINCT tx_hash) as count_tx,
sum(BORROWED_USD) as volume_usd,
avg(BORROWED_USD) average_usd
from ethereum.aave.ez_borrows
where block_timestamp >= '2023-01-01'
and BORROWED_USD > 0
group by 1)
select symbol,
volume_usd
from tb1
order by 2 desc
limit 5