SocioCryptothe average number of transactions per block
    Updated 2022-06-26
    --What's the average number of transactions per block? What's the max number of transactions we've seen in a block and the minimum?

    SELECT avg(tx_count) as avg_txns,
    max(tx_count) as max_txns,
    min(tx_count) as min_txns
    FROM avalanche.core.fact_blocks
    WHERE block_timestamp::date >= '2022-06-20'
    Run a query to Download Data