date_trunc('day',block_timestamp) as block_day,

date_trunc('hour',block_timestamp) as block_hour,

when delegator_address = 'terra19dnl64gf2krtx63m3gud5az9yh8ekdspr44rnt' 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 =

and block_day = '2022-01-24'

group by block_day, block_hour, delegator