hess2. Total Staking and Unstaking
    Updated 2025-06-12
    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
    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.649074093034380741268-23069770444614.529758-490796342.7374763382.4664551371003771.423456.77348273846404540
    1
    149B
    4s