block_timestamp::date as date,

symbol,

sum(supplied_usd) as supplied_usd

from ethereum.aave.ez_deposits

where block_timestamp >= current_date - 30

group by date, symbol