with data as (

select

block_timestamp::date as date

,'ETH' as chain

, amount_usd

, origin_to_address

from ethereum.core.ez_token_transfers

where 1=1

and to_address = '0xc8c0e780960f954c3426a32b6ab453248d632b59'

and origin_from_address = '0x7fb867f4ac8e0fea476926e00bca8b0381e8dbe7'

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

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

UNION ALL

select

block_timestamp::date as date

,'BASE' as chain

, amount_usd

, origin_to_address

from base.core.ez_token_transfers

where 1=1

and to_address = '0xc8c0e780960f954c3426a32b6ab453248d632b59'

and origin_from_address = '0x7fb867f4ac8e0fea476926e00bca8b0381e8dbe7'

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

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

UNION ALL

select

block_timestamp::date as date

,'BNB' as chain

, amount_usd

, origin_to_address

from bsc.core.ez_token_transfers