select lower(address) as address from (

values

('0x6460D14DbAeb27AEfec8eBeF85dB35DefA31c3b9'),

('0x27213E28D7fDA5c57Fe9e5dD923818DBCcf71c47'),

('0x163c5e051049e92915017fe7bb9b8ce6182bcbb1'),

('0x37a8f295612602f2774d331e562be9e61B83a327'),

('0x7ffc3dbf3b2b50ff3a1d5523bc24bb5043837b14'),

('0x067170777ba8027ced27e034102d54074d062d71'),

('0x34eCdAd9090CD133e63Cf6670f3A03Aa7F04fa74'),

('0X5a509e3fbf5eFCdfE9c3E9a0eb56B1a036AB8e23'),

('0xe9F2DCfDbb31149b02A520f8bABD89227A0C6568'),

('0xd4ce1f1b8640c1988360a6729d9a73c85a0c80a3'),

('0xce946931adf7afc0797de2a76270a28458f487ed'),

('0x000000fee13a103A10D593b9AE06b3e05F2E7E1c')

) as t(address)

,pacholders as (

select lower(address) as address from (

values

('0x1dd4fb074e9f28ca9d21c93e0aa915b487893b1c') ,('0x14c5766f8556683af2d8023e389837044794795a') ,('0x0301079dabdc9a2c70b856b2c51aca02bac10c3a') ,('0x38834c50d271b8b755493f9845b9f9b64920638a') ,('0x000000000000000000000000000000000000dead') ,('0x35cffd490fa1f20c7fadb669067e4cf289bd61a2') ,('0x0f02580e21a0e8241add50e56e1cbc72aa33b4a7') ,('0x6e3d09ffd8d35604652e74f7128f08c8474365d6') ,('0xebb74b95f8598e56db85c8e0ac1160b62d012776') ,('0x046299143a880c4d01a318bc6c9f2c0a5c1ed355') ,('0x02df485037c08c3743c182636987c1452cf2e7f9') ,('0x937237c6cef410395825fd431a702be7f785f24d') ,('0x11ddd59c33c73c44733b4123a86ea5ce57f6e854') ,('0x72ff64fb5176d245e6f52585c20dbce67544c9c0') ,('0x6a372dbc1968f4a07cf2ce352f410962a972c257') ,('0xd973506bf52c2cfa89f92deb75f2d85b139e35fa') ,('0xf39cfb4997a8b23248f64a3cd88027d61229d840') ,('0x6ed9ba4dc8985e949742482df288f92b156b331a') ,('0xe0104fcbcf4346fb07df05b51f04cbba6a210ed5') ,('0x798de49488a1d4642d80dee1b700802fd1953060') ,('0xf8b1ee004c9b133064011bc6cc50fc6648fda05d') ,('0xea51c9153918dd95ba7111217894a039bde0bcf3') ,('0x44889b52b71e60de6ed7de82e2939fcc52fb2b4e') ,('0x275a8d31bc87d5664249db312001310a058b800e') ,('0xc972fae6b524e8a6e0af21875675bf58a3133e60') ,('0xa418b2d220a080f38eb11c6eb462a44e505b26f1') ,('0x4d08a6fe192bc9059c9db5d9e9b33b12711f7966') ,('0x3301e6962d352a4f36c1932affbad736023a4ce5') ,('0x791742d6adcdac361b1ab061fe8998055e46e46b') ,('0x55aeff15b1f37c5d180f3350a56cc9cd6a6a6602') ,('0x384877cbe1d3187c34fff2b7d699902820a7a190') ,('0xab9d0066b928d0dbd0abf5d402167412b7010d24') ,('0xf4a1430b733cf5666054c6d735423c37a448d0c6') ,('0x13a22a2130dabeb69da14ed2cf8b6348430490e2') ,('0x064be19d55d34dc276ee2a754c26a6ddc7dfb750') ,('0x7802d4044d38b41235e553939aa8afb9bf301fab') ,('0x1711d0178c219f33428614163f50275a8954793b') ,('0x6131b5fae19ea4f9d964eac0408e4408b66337b5') ,('0x14928c304c54b3003a7f575ee8249c55281aad6e') ,('0xb46e33870a3c3fd65d926f480a51e34c60a2bdcb') ,('0x69d3158a17e11fbbdb2a0e7e8bd05ac3628e3630') ,('0x6aabc8c425ddda3371d9fa7230f1ab77fad4d366') ,('0xbebebeb035351f58602e0c1c8b59ecbff5d5f47b') ,('0xaada4bf9e31dbe3d3de04ff90c4a670b88483e0a') ,('0xe82e60015d957f9881439d63508101e0ee26673f') ,('0x08ce2914e6d86b46a0e1f96815b21cec831d67

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