DATE | Active Nodes | AN Change % | Stake Pools | Delegation Pools | Delegation % | Active APT | Pending Active | Inactive APT | Pending Inactive | Total | Stake Change % | Delegated APT | Delegated % | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 2025-03-10 00:00:00.000 | 149 | 0 | 104 | 45 | 30.2013 | 872951683.873913 | 0 | 10073299.2023568 | 3605573.93995135 | 886630557.016222 | 0.01327969801 | 333889425.304448 | 37.65823574 |
2 | 2025-03-09 00:00:00.000 | 149 | -0.6667 | 104 | 45 | 30.2013 | 872703394.135899 | 64.05 | 10244756.8917222 | 3564615.71181669 | 886512830.789438 | -0.3551269767 | 333889425.304448 | 37.66323664 |
3 | 2025-03-08 00:00:00.000 | 150 | 0.6711 | 104 | 46 | 30.6667 | 872399150.258213 | 71.349 | 13398177.0627323 | 3874898.45093677 | 889672297.120882 | 0.3779624869 | 337509722.954948 | 37.936409175 |
4 | 2025-03-07 00:00:00.000 | 149 | 3.4722 | 104 | 45 | 30.2013 | 872215407.467864 | 315.91814495 | 9772487.94068873 | 4334119.86961471 | 886322331.196312 | 0.6728807895 | 334188525.141387 | 37.705077868 |
5 | 2025-03-06 00:00:00.000 | 144 | -0.6897 | 100 | 44 | 30.5556 | 866638596.469321 | 536.5225277 | 9854467.5807135 | 3904699.59073537 | 880398300.163298 | -0.311349609 | 332705757.034938 | 37.790367947 |
6 | 2025-03-05 00:00:00.000 | 145 | 0 | 100 | 45 | 31.0345 | 866417753.487894 | 1396.99473338 | 12652555.6808943 | 4076271.7757866 | 883147977.939308 | 0.2467884848 | 336070605.722008 | 38.053714 |
7 | 2025-03-04 00:00:00.000 | 145 | 0.6944 | 102 | 43 | 29.6552 | 869820221.048768 | 0 | 9283657.6092224 | 1869957.29989396 | 880973835.957884 | 0.173391424 | 333412526.798124 | 37.845905655 |
8 | 2025-03-03 00:00:00.000 | 144 | 0 | 101 | 43 | 29.8611 | 868867699.263061 | 0 | 9403259.043121 | 1177988.59909369 | 879448946.905275 | -0.2235489173 | 333412526.798124 | 37.911527209 |
9 | 2025-03-02 00:00:00.000 | 144 | 0 | 101 | 43 | 29.8611 | 868926195.240151 | 0 | 9416487.84032329 | 3076667.23904267 | 881419350.319517 | 0.03464761752 | 333412526.798124 | 37.826776401 |
10 | 2025-03-01 00:00:00.000 | 144 | 0 | 101 | 43 | 29.8611 | 868768566.872637 | 0 | 9242415.3951426 | 3103083.02045525 | 881114065.288235 | 0.002866959509 | 333412526.798124 | 37.839882478 |
11 | 2025-02-28 00:00:00.000 | 144 | 0 | 101 | 43 | 29.8611 | 868861973.318565 | 6.17721488 | 9296171.34100605 | 2930653.99217607 | 881088804.828962 | 0.005031401162 | 333412526.798124 | 37.840967332 |
12 | 2025-02-27 00:00:00.000 | 144 | -2.7027 | 101 | 43 | 29.8611 | 868150347.367168 | 0 | 9281175.08233671 | 3612953.49745774 | 881044475.946962 | 0.2333817629 | 331959478.704576 | 37.677947909 |
13 | 2025-02-26 00:00:00.000 | 148 | 0 | 106 | 42 | 28.3784 | 872441356.73898 | 14.02 | 3455922.74919719 | 3095772.92430411 | 878993066.432482 | -0.01152910521 | 325167526.759313 | 36.993184495 |
14 | 2025-02-25 00:00:00.000 | 148 | 1.3699 | 106 | 42 | 28.3784 | 872549687.937841 | 0 | 3113533.05407676 | 3431197.16091183 | 879094418.15283 | 0.2896326175 | 325290362.066225 | 37.002892448 |
15 | 2025-02-24 00:00:00.000 | 146 | 0.6897 | 105 | 41 | 28.0822 | 870216051.098071 | 105.28901816 | 3094998.63542152 | 3244472.12349207 | 876555627.146003 | 0.1612808328 | 325288723.771285 | 37.109877993 |
16 | 2025-02-23 00:00:00.000 | 145 | 0 | 104 | 41 | 28.2759 | 869078145.917317 | 125.94778142 | 3201945.8027971 | 2863969.64451796 | 875144187.312413 | 0.02627199968 | 324265082.670768 | 37.052760833 |
17 | 2025-02-22 00:00:00.000 | 145 | -1.3605 | 104 | 41 | 28.2759 | 868849442.463311 | 0 | 3182811.71904115 | 2882075.64016191 | 874914329.822514 | -0.4232290484 | 323180270.207497 | 36.938504627 |
18 | 2025-02-21 00:00:00.000 | 147 | 2.0833 | 105 | 42 | 28.5714 | 869635075.912954 | 0 | 6017129.37732533 | 2980754.44652712 | 878632959.736807 | 1.013458122 | 326296602.297869 | 37.136849771 |
19 | 2025-02-20 00:00:00.000 | 144 | 1.4085 | 103 | 41 | 28.4722 | 861685761.422373 | 0.1 | 5337855.38775333 | 2794104.47996267 | 869817721.390089 | 0.2638897778 | 323143300.828683 | 37.150691792 |
20 | 2025-02-19 00:00:00.000 | 142 | 0.7092 | 101 | 41 | 28.8732 | 861467888.705781 | 274.48727445 | 3177365.71566472 | 2882873.70765059 | 867528402.61637 | 0.08992434415 | 323059883.942895 | 37.239113206 |
messariAptos Base - [chain] staking balances
Updated 2024-07-09
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
stake_txs as (
select
date_trunc('day', block_timestamp) as date
, version
, address as pool_address
, change_data :active :value ::int / pow(10,8) as active_stake
, change_data :pending_active :value ::int / pow(10,8) as active_pending
, change_data :inactive :value ::int / pow(10,8) as inactive_stake
, change_data :pending_inactive :value ::int / pow(10,8) as inactive_pending
from aptos.core.fact_changes
where success
and change_type = 'write_resource'
and inner_change_type = '0x1::stake::StakePool'
and block_timestamp > '2022-10-19' -- oldest stake pool change
qualify row_number() over (partition by address, date order by version desc, change_index desc) = 1
),
delegate_txs as (
select
date_trunc('day', block_timestamp) as date
, version
, address as pool_address
, change_data :active_shares :total_coins ::int / pow(10, 8) as active_delegated
, change_data :total_coins_inactive ::int / pow(10, 8) as inactive_delegated
from aptos.core.fact_changes
where success
and change_type = 'write_resource'
and inner_change_type = '0x1::delegation_pool::DelegationPool'
Last run: 25 days ago
90
15KB
496s