flipside

    [NEAR][2023] Block Producers per day
    TheLaughingMan[NEAR][2023] Block Producers per day
    Updated 2023-02-09
    SELECT
    date_trunc('day', BLOCK_TIMESTAMP) as ddate
    , COUNT(DISTINCT block_author) as validators
    from near.core.fact_blocks
    GROUP BY ddate ORDER BY ddate
    Run a query to Download Data