count(distinct tx_hash) as N_redeem_actions,

count(distinct origin_from_address) as redeem_count,

sum(raw_amount)/pow(10,18) as redeem_amount,

block_timestamp::date as TIME,

sum(redeem_amount) over (order by TIME) as cum_amount

from ethereum.core.ez_token_transfers

where origin_to_address = '0x4da27a545c0c5b758a6ba100e3a049001de870f5'

and from_address = '0x4da27a545c0c5b758a6ba100e3a049001de870f5'

and block_timestamp > CURRENT_DATE - 365

group by TIME