MONTH | NAKAMOTO_COEFF | |
|---|---|---|
1 | 2025-06-09 00:00:00.000 | 10 |
2 | 2025-06-08 00:00:00.000 | 10 |
3 | 2025-06-07 00:00:00.000 | 10 |
4 | 2025-06-06 00:00:00.000 | 10 |
5 | 2025-06-05 00:00:00.000 | 10 |
6 | 2025-06-04 00:00:00.000 | 10 |
7 | 2025-06-03 00:00:00.000 | 10 |
8 | 2025-06-02 00:00:00.000 | 10 |
9 | 2025-06-01 00:00:00.000 | 10 |
10 | 2025-05-31 00:00:00.000 | 10 |
11 | 2025-05-30 00:00:00.000 | 10 |
12 | 2025-05-29 00:00:00.000 | 10 |
13 | 2025-05-28 00:00:00.000 | 10 |
14 | 2025-05-27 00:00:00.000 | 10 |
15 | 2025-05-26 00:00:00.000 | 10 |
16 | 2025-05-25 00:00:00.000 | 10 |
17 | 2025-05-24 00:00:00.000 | 10 |
18 | 2025-05-23 00:00:00.000 | 10 |
19 | 2025-05-22 00:00:00.000 | 10 |
20 | 2025-05-21 00:00:00.000 | 11 |
0xHaM-dnear decentralization progress 2 copy
Updated 3 days ago
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
›
⌄
-- forked from adriaparcerisas / near decentralization progress 2 @ https://flipsidecrypto.xyz/adriaparcerisas/q/WGe1TM1KhWDl/near-decentralization-progress-2
-- forked from near decentralization progress 1 @ https://flipsidecrypto.xyz/edit/queries/5905c42c-700a-4360-9d7e-bba62331f8f5
WITH
totals as (
SELECT
date as months,
count(distinct address) as validators,
sum(balance) as cumulative_near_delegated
FROM near.gov.fact_staking_pool_daily_balances
group by 1
),
ranking3 as (
SELECT
date as month,
address as validator,
balance as total_near_delegated,
cumulative_near_delegated
FROM near.gov.fact_staking_pool_daily_balances x
join totals y on date=y.months
),
stats as (
SELECT
month,
33 as bizantine_fault_tolerance,
cumulative_near_delegated,
(cumulative_near_delegated*bizantine_fault_tolerance)/100 as threshold--,
--sum(total_sol_delegated) over (partition by month order by validator_ranks asc) as total_sol_delegated_by_ranks,
--count(distinct vote_accounts) as validators
from ranking3
),
stats2 as (
select *,
1 as numbering,
sum(numbering) over (partition by month order by total_near_delegated desc) as rank
Last run: 3 days ago
...
1750
52KB
56s