select date_trunc('day', block_timestamp) Date_Transfer,
sum (amount) as daily_volume
from ethereum.udm_events
where EVENT_NAME = 'transfer'
and ORIGIN_FUNCTION_NAME = 'transfer'
and block_timestamp >= '2022-01-01'
and symbol like 'USDC%'
and TO_LABEL_TYPE not like 'defi%'
group by Date_Transfer
order by Date_Transfer desc