select
date_trunc('day',block_timestamp) as block_day,
date_trunc('hour',block_timestamp) as block_hour,
delegator_address,
validator_address,
validator_address_label,
event_amount_usd,
case
when delegator_address = 'terra1aj42lga06ujtj4vwfpsn74rqdcjvfdh2namcs8' then 'me'
else 'everyone else' end as delegator
from terra.staking
where validator_address = 'terravaloper1r843mpk5zzkfgtnduskd0dzgeltv0n503ckzy6'
and block_day = '2021-12-16'