defi_internValidators
Updated 2023-11-16Copy Reference Fork
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
›
⌄
⌄
SELECT
DISTINCT DELEGATOR_ADDRESS AS delegator
, sum(amount/pow(10,6)) as amount_sei
from sei.core.fact_staking
group by 1
order by 2 desc
/*
case VALIDATOR_ADDRESS
when 'seivaloper1xhxnad3c86q3d8ggsyu24j7r0y5k3ef4uhh9e2' then 'sei0'
when 'seivaloper1qe8uuf5x69c526h4nzxwv4ltftr73v7qnkypla' then 'Stakecito'
when 'seivaloper1d3ar2psa9ca55q45jg3q6f3ltmpr0ndqqlty87' then 'sei1'
when 'seivaloper1qae8v3h6wd6f5yfxyx3zeumuddwhm4qeyz5qre' then 'Brochain'
when 'seivaloper1hnkkqnzwmyw652muh6wfea7xlfgplnyj0ku4w4' then 'Cosmostation'
when 'seivaloper1xh2gf9gyvumlgpr9ws5n425vhntv9rysw9gr4q' then 'StakingCabin'
when 'seivaloper1d4lyuujr4urd7fkdlytccrd0cljqycycjp9xz8' then 'Notional'
when 'seivaloper1zv9z2wqt348dhxqn38xv8dvsu78cle4xs2cdf4' then 'Enigma'
when 'seivaloper1ummny4p645xraxc4m7nphf7vxawfzt3p5hn47t' then 'Everstake'
when 'seivaloper1t9fq3qfm7ngau5gr8qgf5dpfzjqg79kf65cu04' then 'Imperator.co'
when 'seivaloper146m089lq8mkqw6w0mmlhxz6247g2taha89at74' then 'RHINO'
when 'seivaloper1mpe9rdk7ycujge7r9ncjt4ekamgrdcygvzwqe8' then 'polkachu.com'
when 'seivaloper10hg23nf7eejwvthlad096x95pq84g4wnnwjtzq' then 'ContributionDAO'
when 'seivaloper140l6y2gp3gxvay6qtn70re7z2s0gn57zl6nups' then 'Lavender.Five Nodes'
when 'seivaloper16znh8ktn33dwnxxc9q0jmxmjf6hsz4tl0s6vxh' then 'Flipside'
when 'seivaloper1wuj3xg3yrw4ryxn9vygwuz0necs4klj7j9nay6' then 'Hype INFRA'
when 'seivaloper1spg334qdsxtmlzqn9vsh566477wd0hr56cjspj' then 'Citadel.one'
when 'seivaloper14u38cl6knqxs6vs7lj7vzfvap42yyc3runtrwc' then 'Blockscope.net'
when 'seivaloper17yen4et6asmmz43a49dka69h9l9r56n0tsq0yv' then 'Dora Factory'
when 'seivaloper1eqgnd7ey0hnha8rrfukjrsawulhna0zagcg6a4' then 'Stakin'
when 'seivaloper17ga9jha45gu0x04yrmfpjpksmqe48wupzk5jex' then 'Active Nodes'
when 'seivaloper1wwfpmcvehq6yqdxfccs5rdr745q3kmy06l9d0d' then 'kingnodes 👑'
when 'seivaloper1es38d8hn854vdcg8ql6fr3cycmahj6qypmpefu' then 'WhisperNode🤐'
when 'seivaloper18tpdet22kpvswxayekwn55ry0r5acx4kaauupk' then 'A41'
Run a query to Download Data