0xHaM-dOverview Validators in Total
    Updated 2024-12-23
    select
    'Total' as Status,
    count(distinct address) as validators_count,
    sum(balance) as total_balance
    from near.gov.fact_staking_pool_daily_balances
    where date >= '2023-01-01'
    GROUP by 1
    UNION
    select
    'Q4-2024' as Status,
    count(distinct address) as validators_count,
    sum(balance) as total_balance
    from near.gov.fact_staking_pool_daily_balances
    where date >= '2024-10-01'
    AND date < '2025-01-01'
    GROUP by 1


    QueryRunArchived: QueryRun has been archived