select lower(address) as address from (

values

('0xc8c0e780960f954c3426a32b6ab453248d632b59') --old fee address

,('0x77777d91c0b8ec9984a05302e4ef041dccf77fee') --new fee address

-- ,('0x0000000000002bdbf1bf3279983603ec279cc6df') --relay?

) as t(address)

,excluded as (

select lower(address) as address from (

values

('0xc8c0e780960f954c3426a32b6ab453248d632b59') --old fee address

,('0x77777d91c0b8ec9984a05302e4ef041dccf77fee') --new fee address

,('0xf70da97812cb96acdf810712aa562db8dfa3dbef') --relay

,('0x85c153aae1f101af08151863306d9e0b823ea1b5') --my address, from one time sending relay funds to fee address

) as t(address)

,data as (

select

block_timestamp::date as date,

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

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

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 excluded)

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, 'ETH' as chain