hessLast 30 Days
Updated 2024-12-18
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
with new as (select min(block_timestamp) as daily,
DELEGATOR_ADDRESS
from axelar.gov.fact_staking
where action = 'delegate'
group by 2
)
,
final as (select trunc(daily,'day') as day,
count(DISTINCT DELEGATOR_ADDRESS) as new_staker,
sum(new_staker) over (order by day asc) as cumulative_new_staker
from new
group by 1 )
select sum(new_staker) as total_stakers,
avg(new_staker) as avg
from final
where day >= '2024-01-01'
QueryRunArchived: QueryRun has been archived