select block_timestamp::date daily,
count (distinct tx_hash) num_transactions,
count (distinct redeemer) num_wallets,
sum (received_amount) volume,
sum (received_amount_usd) volume_usd,
sum (volume) over (order by daily) cum_volume ,
sum (volume_usd) over (order by daily) cum_volume_usd
from ethereum.compound.ez_redemptions
where received_contract_symbol ilike '%ETH%'
and block_timestamp::date >= CURRENT_DATE - 21
group by 1