symbol,

count(distinct(tx_hash)) as tx_num,

sum (supplied_usd) as total_deposited_usd,

count(distinct(depositor_address)) as depositor_num

from ethereum.aave.ez_deposits

where aave_version = 'Aave V2'

group by symbol

order by total_deposited_usd desc

limit 10