select lower(address) as address from (

values

('0xc8c0e780960f954c3426a32b6ab453248d632b59') --old fee address

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

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

) as t(address)

,included as (

select lower(address) as address from (

values

('0xf70da97812cb96acdf810712aa562db8dfa3dbef') --relay

,('0x7777169426921d6fcee2b9abcb5be8783c675c20') --old 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 from_address in (select address from included)

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

from ethereum.core.ez_native_transfers

where to_address in (select address from addresses)