date_trunc('day',block_timestamp) as block_day,

date_trunc('hour',block_timestamp) as block_hour,

case

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

and block_day in (SELECT cast(block_timestamp as date)

from terra.staking

where delegator_address = 'terra1x72sahwd7ajywtw6pd6f6shq7m3xsdzhndq7qp')

group by block_day, block_hour, delegator