flipside

    THOR Chain: number of stake pools and validators per day
    peteerTHOR Chain: number of stake pools and validators per day
    Updated 2022-10-31
    select date_trunc('day', block_timestamp) as stake_date , count(distinct rune_address) as validator , count(distinct pool_name) as stake_pool
    from thorchain.core.fact_stake_events
    where date_trunc('day', block_timestamp)!=CURRENT_DATE
    group by 1



    Run a query to Download Data