to_label,

sum(amount)

from ethereum.udm_events

where to_label_type = 'cex'

or to_label_type = 'dex'

and EVENT_TYPE = 'erc20_transfer'

and symbol = 'USDC'

and block_timestamp >= '2020-10-26'

and block_timestamp <= '2020-10-27'

group by 1

order by 2 DESC