symbol,

count(distinct(tx_hash)) as tx_num,

sum (borrowed_usd) as total_deposited_usd,

count( distinct(borrower_address)) as borrower_num

from ethereum.aave.ez_borrows

where aave_version = 'Aave V2'

group by symbol

order by total_deposited_usd desc

limit 10