flipside

    transactions are done in a block on average on Ploygon
    arctic-night-foxtransactions are done in a block on average on Ploygon
    Updated 2022-07-27
    WITH Base AS (
    SELECT
    COUNT (DISTINCT TX_HASH) AS transactions_number
    FROM
    polygon.core.fact_transactions
    WHERE BLOCK_TIMESTAMP::DATE >= '2022-01-01'
    AND STATUS = 'SUCCESS'
    GROUP BY BLOCK_NUMBER)


    SELECT
    AVG(transactions_number)
    FROM
    Base
    Run a query to Download Data