with data as (

select

date_trunc('hour', block_timestamp)::timestamp as date_hour

, 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

date_trunc('hour', block_timestamp)::timestamp as date_hour

, 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

date_trunc('hour', block_timestamp)::timestamp as date_hour

, amount_usd

,origin_to_address

from bsc.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