2844POLYGON DAILY
    Updated 2022-07-13
    SELECT BLOCK_TIMESTAMP::DATE as "DATE" ,COUNT (TX_ID) AS "TRANSACTIONS",COUNT (DISTINCT FROM_ADDRESS) AS "UNIQUE USERS", SUM (FEE) AS "FEES", AVG(FEE) AS "AVERAGE TX FEE",
    CASE
    WHEN BLOCK_TIMESTAMP::DATE <'2022-07-01' then 'REST OF THE YEAR'
    WHEN BLOCK_TIMESTAMP::DATE >='2022-07-01' then 'JULY'
    END AS "PERIOD"
    FROM flipside_prod_db.polygon.transactions
    WHERE BLOCK_TIMESTAMP::DATE >= '2022-01-01'
    GROUP BY 1
    ORDER BY 1 DESC





    Run a query to Download Data