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

sum(amount) as volume,

count(distinct origin_from_address)as depositers,

case

when ORIGIN_FUNCTION_SIGNATURE ='0xb6b55f25' then 'deposit ETH'

when ORIGIN_FUNCTION_SIGNATURE ='0x00f714ce' then 'withdraw ETH'

end as function_signature

from ethereum.core.ez_eth_transfers

where origin_to_address = lower('0xae0Ee0A63A2cE6BaeEFFE56e7714FB4EFE48D419')

group by 1, 4

order by 1