ErsvanGeneral average in calls to applications per block in the last 6 months of 2021
    Updated 2022-06-30
    SELECT AVG(AVG_CALL_PER_BLOCK) FROM (
    SELECT DAY, AVG(CALLS) AS AVG_CALL_PER_BLOCK FROM(
    SELECT
    DATE_TRUNC('DAY',BLOCK_TIMESTAMP) AS DAY,
    BLOCK_ID,
    COUNT(TX_ID) AS CALLS
    FROM flipside_prod_db.algorand.application_call_transaction
    WHERE BLOCK_TIMESTAMP BETWEEN '2021-06-30' AND '2021-12-31'
    GROUP BY DAY, BLOCK_ID
    ORDER BY 2 DESC
    )
    GROUP BY DAY
    ORDER BY 1 DESC
    )
    Run a query to Download Data