0xHaM-ddistribution in Selected
    Updated 2024-04-16
    with tab1 as (
    SELECT
    ifnull(LABEL, VALIDATOR_ADDRESS) as stake_pool,
    DELEGATOR_ADDRESS as staker_cnt,
    avg(CASE
    WHEN action in ('delegate', 'redelegate') THEN amount
    ELSE amount*-1 END)/1e6 as NEAR_staked
    FROM axelar.gov.fact_staking LEFT JOIN axelar.gov.fact_validators on VALIDATOR_ADDRESS = address
    WHERE VALIDATOR_ADDRESS LIKE '{{Validator}}'
    AND block_timestamp::date >= '{{Since_Date}}'
    and block_timestamp::date <= CURRENT_DATE - 1
    GROUP BY 1,2
    ORDER BY 1 DESC
    )
    SELECT
    CASE
    WHEN NEAR_staked < 10 THEN 'a. < 10 NEAR'
    WHEN NEAR_staked BETWEEN 10 and 50 THEN 'b. 10 ~ 50 NEAR'
    WHEN NEAR_staked BETWEEN 50 and 100 THEN 'c. 50 ~ 100 NEAR'
    WHEN NEAR_staked BETWEEN 100 and 500 THEN 'd. 100 ~ 500 NEAR'
    WHEN NEAR_staked BETWEEN 500 and 1000 THEN 'e. 500 ~ 1000 NEAR'
    WHEN NEAR_staked > 1000 THEN 'f. > 1000 NEAR'
    END as distribution,
    COUNT(DISTINCT staker_cnt) as staker_cnts
    FROM tab1
    GROUP by 1

    QueryRunArchived: QueryRun has been archived