select lower(address) as address from (

values

('0xc8c0e780960f954c3426a32b6ab453248d632b59') --fee addresses

,('0x77777d91c0b8ec9984a05302e4ef041dccf77fee') --fee addresses

) as t(address)

,pacholders as (

select lower(address) as address from (

values

('0xc204c2567732c87035ccd27b1f673dc9fc41d5e7')

) as t(address)

,data as (

select

block_timestamp::date as date,

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

chain,

amount_usd,

origin_to_address

from (

select block_timestamp, amount_usd, origin_to_address, 'ETH' as chain

from ethereum.core.ez_token_transfers

where to_address in (select address from addresses)

and origin_from_address not in (select address from addresses)

and origin_from_address in (select address from pacholders)

and block_timestamp::date > '2024-02-26'

and symbol not in ('Shiba 2.0', 'INNBC')

union all

select block_timestamp, amount_usd, origin_to_address, 'BASE' as chain

from base.core.ez_token_transfers

where to_address in (select address from addresses)

and origin_from_address not in (select address from addresses)

and origin_from_address in (select address from pacholders)

and block_timestamp::date > '2024-02-26'