select date_trunc('day', block_timestamp) as Transaction_Date,
count (tx_id) as N_daily_transfer
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 Transaction_Date
order by Transaction_Date desc