hessmonthly new Stakers
Updated 2024-12-18
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
with new as (select min(block_timestamp) as daily,
DELEGATOR_ADDRESS
from axelar.gov.fact_staking
where action = 'delegate'
group by 2
)
select trunc(daily,'month') as monthly,
count(DISTINCT DELEGATOR_ADDRESS) as new_staker,
sum(new_staker) over (order by monthly asc) as cumulative_new_staker
from new
group by 1
QueryRunArchived: QueryRun has been archived