hessShare of New Vs. Old
Updated 2024-12-18
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
›
⌄
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 DISTINCT DELEGATOR_ADDRESS
from new
where daily >= current_date - 90)
select
case when delegator_address in (select delegator_address from final) then 'New Stakers' else 'Active Stakers' end as type,
sum(amount/pow(10,6)) as delegate_amt
from axelar.gov.fact_staking
where action = 'delegate'
and TX_SUCCEEDED = 'TRUE'
and block_timestamp::date >= current_date - 31
group by 1
QueryRunArchived: QueryRun has been archived