MONTHLY | DELEGATE_AMOUNT | UNDELEGATE_AMOUNT | CUMULATIVE_DELEGATE_AMOUNT | CUMULATIVE_UNDELEGATE_AMOUNT | NET | |
|---|---|---|---|---|---|---|
1 | 2025-03-01 00:00:00.000 | 51273787.510757 | -2516418.537683 | 1536156843.45777 | -816942383.406415 | 719214460.051358 |
hessCurrent Net
Updated 2025-03-16
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
›
⌄
with delegate as (select trunc(block_timestamp,'month') as monthly,
sum(amount/pow(10,6)) as delegate_amount,
sum(delegate_amount) over (order by monthly asc) as cumulative_delegate_amount,
count(DISTINCT tx_id) as delegate_tx,
count(DISTINCT DELEGATOR_ADDRESS) as delegate_user,
avg(amount/pow(10,6)) as avg_delegate_amount
from axelar.gov.fact_staking
where action = 'delegate'
group by 1
)
,
undelegate as (select trunc(block_timestamp,'month') as monthly,
sum(amount/pow(10,6))*-1 as undelegate_amount,
sum(undelegate_amount) over (order by monthly asc) as cumulative_undelegate_amount,
count(DISTINCT tx_id)*-1 as undelegate_tx,
count(DISTINCT DELEGATOR_ADDRESS)*-1 as undelegate_user,
avg(amount/pow(10,6)) as avg_undelegate_amount
from axelar.gov.fact_staking
where action = 'undelegate'
group by 1
)
select a.monthly,
delegate_amount,
undelegate_amount,
cumulative_delegate_amount,
cumulative_undelegate_amount,
cumulative_delegate_amount+cumulative_undelegate_amount as Net
from delegate a left outer join undelegate b on a.monthly = b.monthly
where a.monthly >= '2022-08-01'
order by 1 desc
limit 1
Last run: 23 days ago
1
113B
6s