count (distinct tx_hash) as num_transactions,

count (distinct depositor_address) num_wallets,

sum (zeroifnull(withdrawn_tokens)) volume,

sum (zeroifnull(withdrawn_usd)) volume_usd,

sum (volume) over (order by daily) cum_volume,

sum (volume_usd) over (order by daily) cum_volume_usd

from ethereum.aave.ez_withdraws

where symbol ilike '%ETH%'

and block_timestamp::date >= CURRENT_DATE - 30

group by 1