trunc(block_timestamp,'month') as date,

symbol,

count(distinct borrower_address) as borrowers,

sum(borrowed_usd) as borrowed_in_usd,

sum(borrowed_in_usd) over (partition by symbol order by date) as total_borrowed_usd

from ethereum.aave.ez_borrows where symbol in ('SNX','UNI','MKR')

and aave_version = 'Aave V2'

group by 1,2 order by 1 asc, 2 desc