ErsvanApplications created in the first 6 months of 2022
    Updated 2022-06-30
    SELECT DATE_TRUNC('DAY',BLOCK_TIMESTAMP) AS DAY, COUNT(APP_ID) Apps_created FROM (
    SELECT
    B.BLOCK_TIMESTAMP,
    A.APP_ID
    FROM
    flipside_prod_db.algorand.app AS A
    JOIN flipside_prod_db.algorand.block AS B ON B.BLOCK_ID = A.CREATED_AT
    WHERE
    APP_ID IN (
    SELECT APP_ID FROM (
    SELECT APP_ID, NUM FROM (
    SELECT
    APP_ID,
    COUNT(*) AS NUM
    FROM flipside_prod_db.algorand.application_call_transaction
    GROUP BY APP_ID
    )
    WHERE NUM > 1000
    )
    )
    ORDER BY 1 ASC
    )
    WHERE DAY BETWEEN '2022-01-01' AND '2022-04-30'
    GROUP BY DAY
    ORDER BY DAY ASC
    Run a query to Download Data