rackhaelNEAR Validators - 1
Updated 2023-07-02
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
›
⌄
SELECT date_trunc('day', min(block_timestamp)) as date,
count(distinct address) as Validator,
sum(balance) as total_staked_amount
FROM near.core.fact_staking_pool_balances
where block_timestamp::date >= '2023-07-01'
-- group by 1
order by 1
-- SELECT ACTION, SUM(AMOUNT) AS VOLUME
-- FROM near.core.fact_staking_actions
-- WHERE ACTION IN ('staking', 'unstaking')
-- and address ='{{validator}}'
-- GROUP BY ACTION;
SELECT b.date as date,
count(distinct b.address) as Validator,
sum(b.balance ) as total_staked_amount
FROM near.core.fact_staking_pool_daily_balances b
join near.core.dim_address_labels l on p.address = l.address
join
where label_type = 'validator'
-- and block_timestamp::date >= '2023-0-01'
group by 1
order by 1
select p.address, l.address, *
from near.core.dim_staking_pools p
join near.core.dim_address_labels l on p.address = l.address
where l.address = 'pool.near'
'poolv1.near'
select *
Run a query to Download Data