count(DISTINCT tx_hash) as deposits,

sum(supplied_usd) as volume,

row_number() over (order by volume desc) as roww

from ethereum.aave.ez_deposits

where block_timestamp >= CURRENT_DATE - {{Date}}

and supplied_usd >0

group by 1

order by 3 DESC

limit 10