select

block_timestamp::date as date,

symbol,

sum(ISSUED_TOKENS) as sum_deposited_tokens,

sum(Supplied_USD) as sum_deposited_Value,

count (DISTINCT DEPOSITOR_ADDRESS) as num_depositors

from ethereum.aave.ez_deposits where BLOCKCHAIN = 'ethereum' and AAVE_VERSION = 'Aave V2' and block_timestamp >= CURRENT_DATE - 60

group by 1,2

order by 1 asc