date_trunc('hour',block_timestamp) as hour,

sum(amount) 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('0xC3f279090a47e80990Fe3a9c30d24Cb117EF91a8') --LP pool

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

GROUP BY 1

ORDER BY 1