SalehUser Distribution by Stake Volume
    Updated 2025-05-03
    with lst_price_last as (
    select
    hour::date as price_day
    ,avg(price) as avg_price
    from avalanche.price.ez_prices_hourly
    where symbol = 'WAVAX'
    and hour=current_date
    group by 1
    )
    , lst_stake as (
    select
    block_timestamp::date as date
    ,tx_hash
    ,ORIGIN_FROM_ADDRESS as staker
    ,DECODED_LOG:shares/1e18 as amount
    from avalanche.core.ez_decoded_event_logs
    where block_timestamp::date>='2023-04-05'
    and TX_STATUS='SUCCESS'
    and EVENT_REMOVED=false
    and CONTRACT_ADDRESS='0xa25eaf2906fa1a3a13edac9b9657108af7b703e3'
    and EVENT_NAME='Deposit'
    -- and tx_hash='0xb25d2f873e17f9f1344d89e2d9eef4927043f54d23928f4d21e1780d7b2ce5ad'
    )
    ,lst_unstake as (
    select
    block_timestamp::date as date
    ,tx_hash
    ,ORIGIN_FROM_ADDRESS as staker
    ,-1*DECODED_LOG:shares/1e18 as amount
    from avalanche.core.ez_decoded_event_logs
    where block_timestamp::date>='2023-04-05'
    and TX_STATUS='SUCCESS'
    and EVENT_REMOVED=false
    and CONTRACT_ADDRESS='0xa25eaf2906fa1a3a13edac9b9657108af7b703e3'
    and EVENT_NAME='Withdraw'
    -- and tx_hash='0xb25d2f873e17f9f1344d89e2d9eef4927043f54d23928f4d21e1780d7b2ce5ad'
    Last run: 30 days ago
    ($) Staking Distribution
    DELEGATORS
    PERCENTAGE
    1
    [11-100 ($)]1198678.25%
    2
    [less than 10 ($)]15159.89%
    3
    [101-500 ($)]12968.46%
    4
    [1,001-5,000 ($)]1921.25%
    5
    [More than 10,000 ($)]1731.13%
    6
    [501-1,000 ($)]1110.72%
    7
    [5,001-10,000 ($)]450.29%
    7
    239B
    18s