SELECT
date_trunc('hour', block_timestamp) as hour,
-- date(block_timestamp) as date,
sum(event_inputs:value/1e18) as amount,
COUNT(DISTINCT event_inputs:provider) as wallet
from ethereum_core.fact_event_logs
where date(block_timestamp) >= '2022-04-20'
and contract_address = '0x0e42acbd23faee03249daff896b78d7e79fbd58e' -- veSTG token
-- and tx_hash = '0x9fb545785e578ac37c8a550555a28c385eb6bb7d6aab2662d25790c194369806' -- sample stake trx
and event_name = 'Deposit'
and event_inputs:locktime is not NULL
GROUP BY hour