with ETH as (

select

block_timestamp::date as date

,'ETH' as chain

, sum(amount_usd) as usd_in

from ethereum.core.ez_token_transfers

where 1=1

and to_address = '0xc8c0e780960f954c3426a32b6ab453248d632b59'

and block_timestamp::date > '2024-04-05'

and origin_from_address != '0xc8c0e780960f954c3426a32b6ab453248d632b59' -- excludes our swaps, when we conver tokens to weth/usdc

group by block_timestamp::date

order by 1 desc

, BASE as (

select

block_timestamp::date as date

,'BASE' as chain

, sum(amount_usd) as usd_in

from base.core.ez_token_transfers

where 1=1

and to_address = '0xc8c0e780960f954c3426a32b6ab453248d632b59'

and block_timestamp::date > '2024-04-05'

and origin_from_address != '0xc8c0e780960f954c3426a32b6ab453248d632b59' -- excludes our swaps, when we conver tokens to weth/usdc

group by block_timestamp::date

order by 1 desc

, BNB as (

select

block_timestamp::date as date

,'BNB' as chain

, sum(amount_usd) as usd_in

from base.core.ez_token_transfers

where 1=1

and to_address = '0xc8c0e780960f954c3426a32b6ab453248d632b59'

and block_timestamp::date > '2024-04-05'