Afonso_Diaz2023-04-21 08:24 PM
Updated 2023-10-16
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
32
33
34
35
36
›
⌄
with
t2 as (
select
'Flow' as chain,
count(distinct node_id) as validators
from flow.gov.ez_staking_actions
where tx_succeeded = 1
and action in ('TokensCommitted', 'DelegatorTokensCommitted')
group by 1
union all
select
'Axelar' as chain,
count(distinct b.attribute_value) as validators
from axelar.core.fact_transactions c
join axelar.core.fact_msg_attributes a
using(tx_id)
join axelar.core.fact_msg_attributes b
using(tx_id)
where tx_succeeded = 1
and a.attribute_key = 'amount'
and a.msg_type = 'delegate'
and b.attribute_key = 'validator'
and b.msg_type = 'delegate'
group by 1
union all
select
'Osmosis' as chain,
count(distinct b.attribute_value) as validators
from osmosis.core.fact_transactions c
join osmosis.core.fact_msg_attributes a
using(tx_id)
join osmosis.core.fact_msg_attributes b
Run a query to Download Data