MONTH | NAKAMOTO_COEFF | |
|---|---|---|
1 | 2020-08-25 00:00:00.000 | 0 |
2 | 2020-08-26 00:00:00.000 | 0 |
3 | 2020-08-27 00:00:00.000 | 0 |
4 | 2020-08-28 00:00:00.000 | 1 |
5 | 2020-08-29 00:00:00.000 | 1 |
6 | 2020-08-30 00:00:00.000 | 1 |
7 | 2020-08-31 00:00:00.000 | 1 |
8 | 2020-09-01 00:00:00.000 | 1 |
9 | 2020-09-02 00:00:00.000 | 2 |
10 | 2020-09-03 00:00:00.000 | 3 |
11 | 2020-09-04 00:00:00.000 | 3 |
12 | 2020-09-05 00:00:00.000 | 3 |
13 | 2020-09-06 00:00:00.000 | 3 |
14 | 2020-09-07 00:00:00.000 | 4 |
15 | 2020-09-08 00:00:00.000 | 4 |
16 | 2020-09-09 00:00:00.000 | 4 |
17 | 2020-09-10 00:00:00.000 | 4 |
18 | 2020-09-11 00:00:00.000 | 5 |
19 | 2020-09-12 00:00:00.000 | 5 |
20 | 2020-09-13 00:00:00.000 | 5 |
adriaparcerisasnear decentralization progress 2
Updated 13 hours 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 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
from ranking3
),
Last run: about 13 hours ago
...
1721
51KB
26s