from (select date_trunc('day',block_timestamp) date,

count (distinct tx_hash) as transactions ,

count (distinct FROM_ADDRESS) as Users,

sum (AMOUNT) as Volume,

sum (AMOUNT_USD) USD_Volume,origin_function_signature

from ethereum.core.ez_token_transfers

where to_address= '0xd89a09084555a7d0abe7b111b1f78dfeddd638be'

and origin_function_signature in ('0xffaad6a5','0xd7a169eb')

--0xd7a169eb -->deposit and delegate ,

--0xffaad6a5 --> deposit

and SYMBOL='USDC'

and block_timestamp >= CURRENT_DATE - 30

group by 1 ,6