SELECT

distinct tx_hash

from ethereum.core.ez_token_transfers

where origin_to_address = '0xa4b41efc1b6f73355c90119aeefddb1ffcf907b0'

and contract_address = '0xb4bd4628e6efb0cb521d9ec35050c75840320374'

and from_address= '0xa4b41efc1b6f73355c90119aeefddb1ffcf907b0')

SELECT

sum(event_inputs:value)/pow(10,18) as Early_ETH_Redeemed,

date_trunc('day', block_timestamp::date) as TIME,

sum(Early_ETH_Redeemed) over (order by TIME) as accumulative_Redemption

from ethereum.core.fact_event_logs

where origin_to_address = '0xa4b41efc1b6f73355c90119aeefddb1ffcf907b0'

and contract_address = '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'

and event_inputs:from = '0xa4b41efc1b6f73355c90119aeefddb1ffcf907b0'

and event_inputs:to != '0xa45645ebb075a96d1c89511e28d3e9b94f3b7905'

and tx_hash in ( select tx_hash from early_redemptions)

group by TIME