select block_timestamp::date daily,
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 - 21
group by 1