MadiTop 10 Destination delegators by volume of delegated ATOM
Updated 2022-12-11
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 t1 as (select block_timestamp, tx_id, replace(ATTRIBUTE_value, 'uatom')/pow(10,6) as amount
from cosmos.core.fact_msg_attributes
where MSG_TYPE = 'redelegate' and ATTRIBUTE_KEY = 'amount'
and block_timestamp >= '2022-10-31' and block_timestamp <= '2022-11-14'),
t2 as (select block_timestamp, tx_id, ATTRIBUTE_value as destination_validator
from cosmos.core.fact_msg_attributes
where MSG_TYPE = 'redelegate' and ATTRIBUTE_KEY = 'destination_validator'
and block_timestamp >= '2022-10-31' and block_timestamp <= '2022-11-14')
select Validator, round(sum(amount),2) as volume_ATOM, VOte, "Link on MintScan" from(
select t1.block_timestamp, t1.tx_id, destination_validator, amount,
case
when DESTINATION_VALIDATOR = 'cosmosvaloper1vvwtk805lxehwle9l4yudmq6mn0g32px9xtkhc' then 'Imperator.co' -- no with veto
when DESTINATION_VALIDATOR = 'cosmosvaloper1n3mhyp9fvcmuu8l0q8qvjy07x0rql8q46fe2xk' then '0base.vc' -- no with veto
when DESTINATION_VALIDATOR = 'cosmosvaloper1grgelyng2v6v3t8z87wu3sxgt9m5s03xfytvz7' then 'iqlusion' --yes
when DESTINATION_VALIDATOR = 'cosmosvaloper10jzj3jjd3frna0ay08sh4zu4fpy957s49jkk7m' then 'Onbloc Node' --no with veto
when DESTINATION_VALIDATOR = 'cosmosvaloper1xnrth5rku3z3msm9prxe3l0p2yec3d9mzxz9ka' then 'coinhall.org ' --yes
when DESTINATION_VALIDATOR = 'cosmosvaloper1ptyzewnns2kn37ewtmv6ppsvhdnmeapvtfc9y5' then 'WeStaking' -- no with veto
when DESTINATION_VALIDATOR = 'cosmosvaloper196ax4vc0lwpxndu9dyhvca7jhxp70rmcvrj90c' then 'SG-1' --yes
when DESTINATION_VALIDATOR = 'cosmosvaloper1ey69r37gfxvxg62sh4r0ktpuc46pzjrm873ae8' then 'Sikka' --yes
when DESTINATION_VALIDATOR = 'cosmosvaloper1x3mkgqpshvpq87d33ndsleu7gd7w47dl4ve0yy' then 'CrowdControl' --yes
when DESTINATION_VALIDATOR = 'cosmosvaloper1vygmh344ldv9qefss9ek7ggsnxparljlmj56q5' then 'PUPMØS'
end as Validator, --no with veto
case when DESTINATION_VALIDATOR in ('cosmosvaloper1vvwtk805lxehwle9l4yudmq6mn0g32px9xtkhc', 'cosmosvaloper1n3mhyp9fvcmuu8l0q8qvjy07x0rql8q46fe2xk',
'cosmosvaloper10jzj3jjd3frna0ay08sh4zu4fpy957s49jkk7m', 'cosmosvaloper1ptyzewnns2kn37ewtmv6ppsvhdnmeapvtfc9y5',
'cosmosvaloper1vygmh344ldv9qefss9ek7ggsnxparljlmj56q5') then 'No With Veto' else 'Yes' end as Vote,
concat('https://www.mintscan.io/cosmos/validators/', DESTINATION_VALIDATOR) as "Link on MintScan"
from t1 join t2 on t1.tx_id = t2.tx_id
)
where DESTINATION_VALIDATOR in('cosmosvaloper1vvwtk805lxehwle9l4yudmq6mn0g32px9xtkhc', 'cosmosvaloper1n3mhyp9fvcmuu8l0q8qvjy07x0rql8q46fe2xk',
'cosmosvaloper1grgelyng2v6v3t8z87wu3sxgt9m5s03xfytvz7', 'cosmosvaloper10jzj3jjd3frna0ay08sh4zu4fpy957s49jkk7m',
'cosmosvaloper1xnrth5rku3z3msm9prxe3l0p2yec3d9mzxz9ka','cosmosvaloper1ptyzewnns2kn37ewtmv6ppsvhdnmeapvtfc9y5',
'cosmosvaloper196ax4vc0lwpxndu9dyhvca7jhxp70rmcvrj90c', 'cosmosvaloper1ey69r37gfxvxg62sh4r0ktpuc46pzjrm873ae8',
'cosmosvaloper1x3mkgqpshvpq87d33ndsleu7gd7w47dl4ve0yy','cosmosvaloper1vygmh344ldv9qefss9ek7ggsnxparljlmj56q5'
Run a query to Download Data