date_trunc('hour',block_timestamp) as hour,

sum(amount_usd) as value,

count(DISTINCT to_address) as users

-- event_type,

-- event_name

FROM ethereum.udm_events

WHERE

from_address = LOWER('0xab8e74017a8cc7c15ffccd726603790d26d7deca')

AND contract_address = LOWER('0xdBdb4d16EdA451D0503b854CF79D55697F90c8DF')

AND block_timestamp >= '2021-02-27T00:00:00Z'

GROUP BY 1

ORDER BY 1