boomer77Total Address
Updated 2021-08-07
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
with june as
(select
delegator_address
from terra.staking
where date_trunc('day',block_timestamp) = '2021-06-30'
and action = 'delegate'
group by 1),
q1 as
(select
DISTINCT delegator_address
from terra.staking
where date_trunc('month',block_timestamp) between '2021-01-01' and '2021-03-31'
and action = 'delegate')
select count(A.delegator_address) as address, address/17567 * 100 as Percentage
from june A
join q1 B on A.delegator_address = B.delegator_address
Run a query to Download Data