hessValidators last Since January 2023
Updated 2023-04-21
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
›
⌄
with flow as ( select trunc(block_timestamp,'month') as date,'Flow' as chain,node_id as validator, count(DISTINCT(delegator)) as total_user
from flow.core.ez_staking_actions
where tx_succeeded = 'TRUE'
group by 1,2,3
UNION
select trunc(block_timestamp,'month') as date,'Near' as chain,ADDRESS as validator, count(DISTINCT(SIGNER_ID)) as total_user
from near.core.fact_staking_actions
group by 1,2,3
UNION
select trunc(block_timestamp,'month') as date,'Osmosis' as chain,VALIDATOR_ADDRESS as validator, count(DISTINCT(DELEGATOR_ADDRESS)) as total_user
from osmosis.core.fact_staking
where tx_succeeded = 'TRUE'
group by 1,2,3
UNION
select trunc(block_timestamp,'month') as date,'Axelar' as chain,VALIDATOR_ADDRESS as validator, count(DISTINCT(DELEGATOR_ADDRESS)) as total_user
from axelar.core.fact_staking
where tx_succeeded = 'TRUE'
group by 1,2,3
UNION
select trunc(block_timestamp,'month') as date,'Terra' as chain,VALIDATOR_ADDRESS as validator, count(DISTINCT(DELEGATOR_ADDRESS)) as total_user
from terra.core.ez_staking
where tx_succeeded = 'TRUE'
group by 1,2,3
)
select chain, count(DISTINCT(validator)) as total_validator, avg(total_user) as avg_user
from flow
where date >= '2023-01-01'
group by 1
Run a query to Download Data