Ali3NTop 10 Cosmos Validators Stats in 2023
Updated 2023-02-17
999
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 Validators_Table as (
select tx_id,
label as Validator_Label
from cosmos.core.fact_msg_attributes t1 join cosmos.core.fact_validators t2 on t1.attribute_value = t2.address
where msg_type = 'delegate'
and attribute_key = 'validator'
and label in ('🐠stake.fish','DokiaCapital','Coinbase Custody','SG-1','Zero Knowledge Validator (ZKV)','Binance Node','Everstake','Polychain','GAME','Paradigm')),
delegateamount as (
select tx_id,
block_timestamp,
split(ATTRIBUTE_VALUE,'uatom')[0]::numeric/1e6 as Delegate_Amount
from cosmos.core.fact_msg_attributes
where msg_type = 'delegate'
and attribute_key = 'amount'
and tx_id in (select tx_id from Validators_Table)
and block_timestamp >= '2023-01-01'),
delegatort as (
select tx_id,
block_timestamp,
attribute_value as Delegator
from cosmos.core.fact_msg_attributes
where msg_type = 'coin_spent'
and attribute_index = '0'
and attribute_key = 'spender'
and msg_index = '0'
and tx_id in (select tx_id from Validators_Table)
and block_timestamp >= '2023-01-01'),
maindelegate as (
select t1.tx_id,
t2.block_timestamp,
delegator,
delegate_amount,
Validator_Label
Run a query to Download Data