mohammadhGetting Started With Terra Bounties (March 24)
    Updated 2022-03-25
    select
    date_trunc('day',block_timestamp) as block_day,
    date_trunc('hour',block_timestamp) as block_hour,
    case
    when delegator_address = 'terra1tys00cres6q9230qz4awns5fxndrv649wssqkk' 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 = '2022-02-10'
    group by block_day, block_hour, delegator
    Run a query to Download Data