symbol,

sum(withdrawn_usd) as withdrawn_usd

from ethereum.aave.ez_withdraws

where block_timestamp >= current_date - 30

and withdrawn_usd is not null

group by symbol