USER | STAKE_TX | UNSTAKE_TX | STAKE_AMOUNT | UNSTAKE_AMOUNT | CURRENT_BALANCE | AVG_STAKE_AMOUNT | AVG_UNSTAKE_AMOUNT | MAX_STAKE_AMOUNT | MAX_UNSTAKE_AMOUNT | MEDIAN_STAKE_AMOUNT | MEDIAN_UNSTAKE_AMOUNT | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 0x7051d4085c9941a75eba445cb188877b83532535731391b8ab47d43789d77d0e | 4 | 0 | 3424965.52855893 | 0 | 3424965.52855893 | 856241.382139733 | 0 | 1999969.92046097 | 0 | 712496.80404898 | 0 |
2 | 0x6c24d908c502c2e4b4496216126085056a3c3767b61e9ffa764cb7fefdeaf9 | 1 | 0 | 1999970.7216678 | 0 | 1999970.7216678 | 1999970.7216678 | 0 | 1999970.7216678 | 0 | 1999970.7216678 | 0 |
3 | 0xdab9849f69900968b934f1441afea9e8cc68d23e5304390faeaa13c6611c0c99 | 9 | 4 | 1919442.52736856 | 262476.35891675 | 1656966.16845181 | 159953.54394738 | 65619.089729188 | 508580.30118646 | 109396.962 | 99998.53608339 | 75273.25928854 |
4 | 0xe8065c9960640b6bea2c1a97260cc714c7237c1e85d79bee569ac5b980b16f2b | 4 | 4 | 3249981.08229063 | 1750012.36519474 | 1499968.71709589 | 812495.270572657 | 437503.091298685 | 1999970.7216678 | 999999.45478 | 624992.6804944 | 375000.43486815 |
5 | 0x4e348fb99479bc0f85e55a7145f23abcc3778bccfaee31be97c617ec61d22e5 | 10 | 2 | 2044784.90074095 | 589409.69080887 | 1455375.20993208 | 204478.490074095 | 294704.845404435 | 575399.57650672 | 312315.11814528 | 127523.341472995 | 294704.845404435 |
6 | 0x20effa76a78ab6993c1f737069876f1181a0233fd38e09209611032a64d9728f | 60 | 28 | 3440734.24535795 | 2130611.73892083 | 1310122.50643712 | 57345.570755966 | 76093.27639003 | 230000 | 312807.53467539 | 45900.60307173 | 51186.532662015 |
7 | 0x598c805f3bbeb616ad91353dd15a17b0b8d0afce2e38ac31588562aff58a07ba | 2 | 0 | 1219110.91993019 | 0 | 1219110.91993019 | 406370.306643397 | 0 | 919715.19073188 | 0 | 199597.15279887 | 0 |
8 | 0xdf0fba62282ccb0a282b8d8161cacca84ae1c6e616a84e86e7c5825e8779c5ac | 156 | 0 | 1068314.3323914 | 0 | 1068314.3323914 | 6848.168797381 | 0 | 21710.35045699 | 0 | 5708.202849755 | 0 |
9 | 0xeedbb01dc455e1514f8a0f6f27972bdc4e1027d884712949d00f080c160aa864 | 40 | 0 | 1019486.64326745 | 0 | 1019486.64326745 | 25487.166081686 | 0 | 104744.50584705 | 0 | 13862.80225076 | 0 |
10 | 0xfd556560eb13eaae5a4bdc8daff38bcbdbda589f8fde7d9d42fc684d90bf5b66 | 7 | 0 | 1000098.73385342 | 0 | 1000098.73385342 | 142871.247693346 | 0 | 998985.74972982 | 0 | 9.99985736 | 0 |
11 | 0x262231e9a7ce410e534be36f7167ba771851e57e7546265e5fad1997bfef0732 | 108 | 15 | 1732153.16399179 | 855345.52517421 | 876807.63881758 | 16038.455222146 | 57023.035011614 | 241249.37161049 | 240412.59181483 | 168.82021441 | 42445.07132797 |
12 | 0x3909aca08951c187c713331ce1441a17a6c172a99dfc1db8b7a4ce360e1eba90 | 3 | 0 | 799988.28866714 | 0 | 799988.28866714 | 266662.762889047 | 0 | 374994.51031272 | 0 | 374994.51031272 | 0 |
13 | 0xc05a134cfc810151be52211f7c16f8c2031669a9ff5643ce674611f47b3aa968 | 3 | 0 | 737491.5824795 | 0 | 737491.5824795 | 245830.527493167 | 0 | 324995.24227102 | 0 | 249996.34020848 | 0 |
14 | 0xfbd51234aa61e428c9ba558fb0fe1bab20855ca61c15209099e7b2230c2d6266 | 294 | 23 | 715862.81285628 | 3050.69776374 | 712812.11509254 | 2434.907526722 | 132.639033206 | 15000 | 1084.83567019 | 2200 | 4.49101086 |
15 | 0xcbf244c9e25904b1f0d25553ec94e59b0e941504483354329bbd275e5ab2f76b | 16 | 4 | 804537.25089851 | 142179.78108186 | 662357.46981665 | 50283.578181157 | 35544.945270465 | 153651.5150624 | 76557.26741813 | 5019.21402369 | 32810.25683187 |
16 | 0x564f9e176210b635c7e8345ee44f779e35974aeb9b797ffb1449e3cff1b6882d | 138 | 6 | 644767.25397473 | 853.20165019 | 643914.05232454 | 4298.448359832 | 142.200275032 | 21684.86850518 | 390.31831462 | 2226.1878393 | 87.101810505 |
17 | 0x85f39a9bd8d389f9ee950bbe6ce6f487e5e343586f6d12bc6a62831a8a505d6f | 12 | 3 | 641608.76127151 | 60253.80057039 | 581354.96070112 | 53467.396772626 | 20084.60019013 | 190623.26483828 | 41180.16473719 | 56258.760222085 | 19060.6230587 |
18 | 0x74e5136c81d20ea2b13682d07fc813fe80c8d708db885d2e127e9f2b071ee1bd | 536 | 0 | 533816.75165008 | 0 | 533816.75165008 | 995.926775467 | 0 | 3902.94286334 | 0 | 993.485642185 | 0 |
19 | 0x33d3b21c7a8cded78f584c0fd1392311f8334ca6e8729b9766381e390e15a4d | 14 | 1 | 550913.62916811 | 65242.47703874 | 485671.15212937 | 39350.973512008 | 65242.47703874 | 94998.55927995 | 65242.47703874 | 32794.51990855 | 65242.47703874 |
20 | 0x74a6e452b477eaa2c1f0ee6e3b9ca62a204687a6b8308953e293d5b967f4e3d6 | 49 | 0 | 482793.17815503 | 0 | 482793.17815503 | 9852.922003164 | 0 | 47361.32440311 | 0 | 5253.99999999 | 0 |
hessOverview of Top 1000 Addresses
Updated 2025-03-20
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 stake_tx as ( select DISTINCT a.tx_hash,
a.block_timestamp,
event_data:"amapt"/pow(10,8) as amount,
sender as user
from aptos.core.fact_events a join aptos.core.fact_transactions b on a.tx_hash = b.tx_hash
and a.event_address like '0x111ae3e5bc816a5e63c2da97d0aa3886519e0cd5e4b046659fa35796bd11542a%'
and a.EVENT_RESOURCE in ('MintEvent','DepositEvent','StakeEvent')
and a.tx_hash not in (select tx_hash from aptos.core.fact_events
where event_resource in ('UnstakeEvent','WithdrawalRequestEvent'))
having amount is not null )
,
unstake_tx as ( select DISTINCT a.tx_hash,
a.block_timestamp,
event_data:"amapt"/pow(10,8) as amount,
sender as user
from aptos.core.fact_events a left outer join aptos.core.fact_transactions b on a.tx_hash = b.tx_hash
where event_resource in ('UnstakeEvent')
and a.event_address like '0x111ae3e5bc816a5e63c2da97d0aa3886519e0cd5e4b046659fa35796bd11542a%'
and a.tx_hash not in (select tx_hash from stake_tx))
,
stake as ( select user,
count(DISTINCT tx_hash) as stake_tx,
count(DISTINCT user) as stakers,
sum(amount) as stake_amount,
avg(amount) as avg_stake_amount,
max(amount) as max_stake_amount,
median(amount) as median_stake_amount
from stake_tx
group by 1)
,
unstake as ( select user,
count(DISTINCT tx_hash) as unstake_txs,
count(DISTINCT user) as unstaker,
sum(amount) as unstakes_apt,
avg(amount) as avg_unstakes_amount,
max(amount) as max_unstake_amounts,
Last run: about 1 month ago
...
1000
168KB
287s