Delegate Amount (AXL) | Undelegate Amount (AXL) | DELEGATE_TX | UNDELEGATE_TX | DELEGATE_USER | UNDELEGATE_USER | Delegate Amount (USD) | Undelegate Amount (USD) | Avg Delegate (AXL) | Max Delegate (AXL) | Avg UnDelegate (AXL) | Max UnDelegate (AXL) | |
---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 1615716281.48778 | -1029259763.64907 | 409303 | 43807 | 41268 | -23069 | 770444614.529758 | -490796342.737476 | 3382.46645513 | 71003771.4 | 23456.773482738 | 46404540 |
hess2. Total Staking and Unstaking
Updated 2025-06-12Copy Reference Fork
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
36
›
⌄
with axl_price as (
select hour::date as date, token_address, avg(price) as axl
from ethereum.price.ez_prices_hourly
where token_address = lower('0x467719ad09025fcc6cf6f8311755809d45a5e5f3')
and hour = current_date
group by 1,2
),
delegate as (select sum(amount / pow(10,6)) as 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,
max(amount / pow(10,6)) as max_delegate_amount,
median(amount / pow(10,6)) as median_delegate_amount,
sum((amount / pow(10,6)) * axl) as delegate_amount_usd,
from axelar.gov.fact_staking
cross join axl_price
where action = 'delegate'
),
undelegate as ( select sum(amount / pow(10,6)) * -1 as undelegate_amount,
count(distinct tx_id) as undelegate_tx,
count(distinct delegator_address) * -1 as undelegate_user,
avg(amount / pow(10,6)) as avg_undelegate_amount,
max(amount / pow(10,6)) as max_undelegate_amount,
median(amount / pow(10,6)) as median_undelegate_amount,
sum((amount / pow(10,6)) * axl) * -1 as undelegate_amount_usd,
from axelar.gov.fact_staking
cross join axl_price
where action = 'undelegate'
)
select
delegate_amount as "Delegate Amount (AXL)",
undelegate_amount as "Undelegate Amount (AXL)",
delegate_tx,
undelegate_tx,
delegate_user,
undelegate_user,
Last run: about 1 month ago
1
149B
4s