select
date_trunc('hour', block_timestamp) as day,
sum(raw_amount/1e18) as sum_amount,
count(distinct tx_hash) as tx_count
from
ethereum.core.ez_token_transfers
where
CONTRACT_ADDRESS = '0x600000000a36f3cd48407e35eb7c5c910dc1f7a8'
group by
day
order by
day asc