MLDZMNval5
99
1
2
3
4
5
6
7
8
9
10
›
⌄
SELECT
date_trunc('week', date) as week,
case
when address like '%poolv1.near%' then 'poolv1.near'
when address like '%pool.near%' then 'pool.near'
end as pools,
count(distinct address) as no_validators
from near.core.fact_staking_pool_daily_balances
where balance > 26030
group by 1,2
Run a query to Download Data