with data as (

select

block_timestamp::date as date

,date_trunc('week', block_timestamp)::date as week

,'ETH' as chain

, amount_usd

, origin_to_address

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

UNION ALL

select

block_timestamp::date as date

,date_trunc('week', block_timestamp)::date as week

,'BASE' as chain

, amount_usd

, origin_to_address

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

UNION ALL

select

block_timestamp::date as date

,date_trunc('week', block_timestamp)::date as week

,'BNB' as chain

, amount_usd

, origin_to_address