select

block_timestamp::date as date,

symbol,

sum(BORROWED_TOKENS) as sum_borrowed_tokens,

sum(BORROWED_USD) as sum_borrowed_Value,

count (DISTINCT BORROWER_ADDRESS) as num_borrower

from ethereum.aave.ez_borrows where BLOCKCHAIN = 'ethereum' and AAVE_VERSION = 'Aave V2' and block_timestamp >= CURRENT_DATE - 60 and symbol like '%ETH%'

group by 1,2

order by 1 asc