2844Applications on Algorand-TOTAL
    Updated 2022-07-01

    SELECT 'SECOND HALF OF 2021' AS "PERIOD" ,COUNT(DISTINCT BLOCK_ID) AS "TOTAL BLOCK",COUNT (TX_ID) AS "TOTAL TRASACTIONS",
    COUNT(DISTINCT SENDER) AS "UNIQUE USERS",
    "TOTAL TRASACTIONS"/ "TOTAL BLOCK" AS "AVG TRANCATIONS PER BLOCK", COUNT(DISTINCT APP_ID) AS "NUMBER OF APP"
    from flipside_prod_db.algorand.application_call_transaction
    WHERE BLOCK_TIMESTAMP::DATE >= '2021-06-01' AND BLOCK_TIMESTAMP::DATE<'2022-01-01'
    UNION

    SELECT 'FIRST HALF OF 2022' AS "PERIOD" ,COUNT(DISTINCT BLOCK_ID) AS "TOTAL BLOCK",COUNT (TX_ID) AS "TOTAL TRASACTIONS",
    COUNT(DISTINCT SENDER) AS "UNIQUE USERS",
    "TOTAL TRASACTIONS" / "TOTAL BLOCK" AS "AVG TRANCATIONS PER BLOCK",COUNT(DISTINCT APP_ID) AS "NUMBER OF APP"
    from flipside_prod_db.algorand.application_call_transaction
    WHERE BLOCK_TIMESTAMP::DATE>= '2022-01-01' AND BLOCK_TIMESTAMP::DATE<'2022-07-01'

    Run a query to Download Data