2844POLYGON OVERALL
    Updated 2022-07-13
    SELECT 'JULY' AS "PERIOD" ,COUNT (TX_ID) AS "TRANSACTIONS",COUNT (DISTINCT FROM_ADDRESS) AS "UNIQUE USERS", SUM (FEE) AS "FEES", AVG(FEE) AS "AVERAGE TX FEE"
    FROM flipside_prod_db.polygon.transactions
    WHERE BLOCK_TIMESTAMP::DATE >= '2022-07-01'
    UNION

    SELECT 'REST OF THE YEAR' AS "PERIOD" ,COUNT (TX_ID) AS "TRANSACTIONS",COUNT (DISTINCT FROM_ADDRESS) AS "UNIQUE USERS",SUM (FEE) AS "FEES", AVG(FEE) AS "AVERAGE TX FEE"
    FROM flipside_prod_db.polygon.transactions
    WHERE BLOCK_TIMESTAMP::DATE < '2022-07-01' AND BLOCK_TIMESTAMP::DATE >= '2022-01-01'




    Run a query to Download Data