date_trunc('week',BLOCK_TIMESTAMP) as week,

when FROM_ADDRESS=lower('0xADF15Ec41689fc5b6DcA0db7c53c9bFE7981E655') then 'FXS'

when FROM_ADDRESS=lower('0xD3B5D9a561c293Fb42b446FE7e237DaA9BF9AA84') then 'ALCX'

when FROM_ADDRESS=lower('0x808D3E6b23516967ceAE4f17a5F9038383ED5311') then 'FOX'

when FROM_ADDRESS=lower('0x15A629f0665A3Eb97D7aE9A7ce7ABF73AeB79415') then 'TCR'

when FROM_ADDRESS=lower('0xf49764c9C5d644ece6aE2d18Ffd9F1E902629777') then 'SUSHI'

when FROM_ADDRESS=lower('0xeff721Eae19885e17f5B80187d6527aad3fFc8DE') then 'SNX'

end as reactors,

count(distinct TO_ADDRESS) as withdrawer,

sum(AMOUNT_USD) as vol_withdraw,

count(distinct tx_hash) as no_withdraw

from ethereum.core.ez_token_transfers

where BLOCK_TIMESTAMP>='2022-01-01'

group by 1,2 having reactors is not null