count(DISTINCT tx_hash) as borrows,

sum(borrowed_usd) as volume,

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

from ethereum.aave.ez_borrows

where block_timestamp >= CURRENT_DATE - {{Date}}

group by 1

order by 3 DESC

limit 10