flipside

    number of daily transactions and unique addresses on Polygon (1)
    kitlunanumber of daily transactions and unique addresses on Polygon (1)
    Updated 2022-07-13
    SELECT
    BLOCK_TIMESTAMP::date as "date",
    COUNT (*) AS transactions,
    COUNT (DISTINCT FROM_ADDRESS) AS unique_addresses
    FROM flipside_prod_db.polygon.transactions
    WHERE "date" BETWEEN '2021-01-01' AND CURRENT_DATE - 1
    GROUP BY "date"
    ORDER BY "date"
    Run a query to Download Data