date_trunc('day',block_timestamp) as block_day,

date_trunc('hour',block_timestamp) as block_hour,

when delegator_address = '[your address]' then 'me'

else 'everyone else' end as delegator,sum(event_amount_usd) as amount_delegated_usd,

count(*) as transaction_count

from terra.staking

where validator_address =

'terravaloper18hpew39uymssr52w8euxqh4zrrjt02x7k0jmhk'

and block_day = '2022-01-15'

group by block_day, block_hour, delegator