with all_data as
( select eth_to_address,eth_from_address,amount , block_timestamp , case
when eth_to_address=lower('0xae0Ee0A63A2cE6BaeEFFE56e7714FB4EFE48D419') then 'Ethereum to starknet'
when eth_from_address=lower('0xae0Ee0A63A2cE6BaeEFFE56e7714FB4EFE48D419') then 'starknet to Ethereum'
end as type
from ethereum.core.ez_eth_transfers
where
eth_to_address=lower('0xae0Ee0A63A2cE6BaeEFFE56e7714FB4EFE48D419')
or
eth_from_address=lower('0xae0Ee0A63A2cE6BaeEFFE56e7714FB4EFE48D419')
)
select sum(amount),type,block_timestamp::date from all_data
group by type,block_timestamp::date