amirozaUntitled Query
Updated 2022-01-21
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
select
date_trunc('day',block_timestamp) as block_day,
date_trunc('hour',block_timestamp) as block_hour,
case
when delegator_address = 'terra1r3h498nmhphfqufgg4vgqjxgq6xv3yw24azqc6' 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-01-13'
group by block_day, block_hour, delegator
Run a query to Download Data