bergDaily Stake and Stakers on Near
Updated 2022-11-16Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
select block_timestamp::date date,
count(distinct(tx_hash)) as staked_num,
count(distinct(tx_signer)) as stakers_num,
sum(stake_amount / pow(10, 24)) as staked_volume,
(staked_num / stakers_num) as staked_num_per_staker,
(staked_volume / stakers_num) as staked_volume_per_staker,
avg(stake_amount / pow(10, 24)) as staked_amount_avg,
median(stake_amount / pow(10, 24)) as staked_amount_median,
sum(staked_num) over (order by date) AS staked_num_cum,
sum(staked_volume) over (order by date) AS staked_volume_cum,
sum(stakers_num) over (order by date) as stakers_num_cum
from near.core.dim_staking_actions
where 1 = 1
and action = 'Stake'
and date >= '2022-11-01'
group by date
order by date
Run a query to Download Data