with addresses as (

select lower(address) as address from (

values

,('0x163c5e051049e92915017fe7bb9b8ce6182bcbb1')

,('0x37a8f295612602f2774d331e562be9e61b83a327')

,('0x7ffc3dbf3b2b50ff3a1d5523bc24bb5043837b14')

,('0x067170777ba8027ced27e034102d54074d062d71')

,('0x34ecdad9090cd133e63cf6670f3a03aa7f04fa74')

,('0x5a509e3fbf5efcdfe9c3e9a0eb56b1a036ab8e23')

,('0xe9f2dcfdbb31149b02a520f8babd89227a0c6568')

,('0xd4ce1f1b8640c1988360a6729d9a73c85a0c80a3')

,('0xce946931adf7afc0797de2a76270a28458f487ed')

,('0x000000fee13a103a10d593b9ae06b3e05f2e7e1c')

,('0x5d64d14d2cf4fe5fe4e65b1c7e3d11e18d493091')

,('0x89f30783108e2f9191db4a44ae2a516327c99575')

,('0x23b5aa437cfdaf03235d78961e032dba549dfc06')

) 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 addresses) and from_address not in (select address from addresses)