DELEGATOR_ADDRESS | DELEGATE_AMOUNT | UNDELEGATE_AMOUNT | NET | DELEGATE_TX | UNDELEGATE_TX | AVG_DELEGATE_AMOUNT | AVGAVG_UNDELEGATE_AMOUNT | |
---|---|---|---|---|---|---|---|---|
1 | axelar14frs4mpggrww86h2n0ykqjstwypcllsz077e50 | 252769999.999995 | 1328828.8840367 | 254098828.884032 | 43 | -52 | 2633020.83333328 | 1328828.8840367 |
2 | axelar1r3pu4jjatcrwpjyca5zaweltstepkgqp54dhtv | 46404540 | 46404540 | 92809080 | 1 | -1 | 46404540 | 46404540 |
3 | axelar1ren608jc4cnslzsxs08memmmda2djncxcudhh7 | 84555669.733562 | 3676333.46667661 | 88232003.2002386 | 134 | -23 | 631012.460698224 | 3676333.46667661 |
4 | axelar1am2yc4lvyp27q8a6ehmscyv29u4qhfjx6a4jvs | 81058465.1583 | 1699465.35862183 | 82757930.5169218 | 38 | -23 | 2133117.50416579 | 1699465.35862183 |
5 | axelar1ezpemdmshyje4p4d2gmje8vv8w6nz4k5ndy52x | 62467051.079634 | 3287721.10945921 | 65754772.1890932 | 371 | -19 | 168374.80075373 | 3287721.10945921 |
6 | axelar14k7jpx6u0fj4yl273yu5glzdedaw5wzkkdzzmj | 59000004.2 | 2950000.21 | 61950004.41 | 29 | -20 | 2034482.90344828 | 2950000.21 |
7 | axelar15366t0hk23wz8rrz92yw8trvperwr3nehc52m0 | 54355073.9655 | 1907270.82258333 | 56262344.7880833 | 20 | -6 | 2717753.698275 | 1907270.82258333 |
8 | axelar1470j254cgy9tecw333v5dar2x6cudjpnxzvynk | 27176960.017341 | 13588480.0086705 | 40765440.0260115 | 89 | -2 | 305359.101318438 | 13588480.0086705 |
9 | axelar1y7rv6fqxyum0yux9tmplhfk9e3z3t7kk3he7wy | 17857142 | 17857142 | 35714284 | 1 | -1 | 17857142 | 17857142 |
10 | axelar17h2wdyu6pcdfck6t0wy280jk24m8nugftf2pmf | 31657461.8383 | 2638121.736525 | 34295583.574825 | 15 | -12 | 2110497.45588667 | 2638121.736525 |
11 | axelar1tkxrdzgrwkgrhl9ks3cujlkkjlgc5dk8udwu3u | 33632295.639999 | 0 | 33632295.639999 | 2 | 0 | 2802691.30333325 | 0 |
12 | axelar1ph0qnh7u2fhuqrx0w27mpg338np6uhqhrqh7qs | 32400000 | 719687.111111133 | 33119687.1111111 | 57 | -45 | 568421.052631579 | 719687.111111133 |
13 | axelar1kn40l8w85f72s8n793ky5dhghf39lpmsdz0fef | 20575549.807297 | 10287774.9036485 | 30863324.7109455 | 89 | -2 | 231185.952890978 | 10287774.9036485 |
14 | axelar1ez4duq7700ncrn9fjspl055tkvvtg47kfdmtw6 | 28239974.448339 | 655083.622343921 | 28895058.0706829 | 31 | -38 | 910966.917688355 | 655083.622343921 |
15 | axelar107st7afj07qgp5qsdvz8e0v5zd97xerr046m4y | 23043985.100434 | 4569593.98641767 | 27613579.0868517 | 348 | -3 | 66218.347989753 | 4569593.98641767 |
16 | axelar1ae85qw6pyl6wsf6hgz3szh0wg5mqf0zjxqfjf0 | 23212500.761837 | 4000000 | 27212500.761837 | 9 | -2 | 2579166.75131522 | 4000000 |
17 | axelar1qksza8ge9r872syq4n4ec3nufr5jzwfv7shenf | 13204254.636762 | 13204254.636762 | 26408509.273524 | 2 | -1 | 6602127.318381 | 13204254.636762 |
18 | axelar1j0annpmn5qyfsw466a78skjssdlnhq7z2rpw8s | 22562421.789151 | 1364387.28270286 | 23926809.0718539 | 17 | -7 | 1327201.28171476 | 1364387.28270286 |
19 | axelar12ff0kf7ndscu8epmnwn7nzwmwwud64fhjjv9gs | 21237963 | 2654745.375 | 23892708.375 | 7 | -8 | 3033994.71428571 | 2654745.375 |
20 | axelar159akkvrsrl24ypa8q52wf3rsq8duk5af0ryqfv | 18000000 | 3000000 | 21000000 | 6 | -6 | 3000000 | 3000000 |
hessOverview of top 1000 Addresses
Updated 4 days agoCopy 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
›
⌄
with delegate as (select DELEGATOR_ADDRESS,
sum(amount/pow(10,6)) as delegate_amount,
count(DISTINCT tx_id) as delegate_tx,
count(DISTINCT DELEGATOR_ADDRESS) as delegate_user,
avg(amount/pow(10,6)) as avg_delegate_amount
from axelar.gov.fact_staking
where action = 'delegate'
group by 1
)
,
undelegate as (select DELEGATOR_ADDRESS,
sum(amount/pow(10,6))*-1 as undelegate_amounts,
count(DISTINCT tx_id)*-1 as undelegate_txs,
count(DISTINCT DELEGATOR_ADDRESS)*-1 as undelegate_user,
avg(amount/pow(10,6)) as avg_undelegate_amounts
from axelar.gov.fact_staking
where action = 'undelegate'
group by 1
)
select a.DELEGATOR_ADDRESS,
delegate_amount,
ifnull(avg_undelegate_amounts,0) as undelegate_amount,
delegate_amount+undelegate_amount as Net,
delegate_tx,
ifnull(undelegate_txs,0) as undelegate_tx,
avg_delegate_amount,
ifnull(avg_undelegate_amounts,0) as avgavg_undelegate_amount
from delegate a left outer join undelegate b on a.DELEGATOR_ADDRESS = b.DELEGATOR_ADDRESS
order by 4 desc
limit 1000
Last run: 4 days ago
1000
106KB
4s