select count (distinct tx_hash) as txns, sum(amount) as total_deposits, avg(amount) as avg_deposits
from ethereum.core.ez_token_transfers
where
--tx_hash='0x862d0646f4d60c5b4e806810e757a4a4f831321719dbcd7de3286786e4181d27'
ORIGIN_TO_ADDRESS='0xde9ec95d7708b8319ccca4b8bc92c0a3b70bf416'
and symbol ='USDC'
and block_timestamp >= CURRENT_DATE - 30