Polygon | Daily Transactions and Unique Addresses

    The number of daily transactions and unique addresses on Polygon, beginning July 1, 2022.

    db_img

    Polygon is an interoperability protocol as well as a framework that works on the Ethereum blockchain. Polygon and Ethereum differ mainly in relation to their functionality, market cap, transaction speeds, gas fees, scalability, and consensus algorithms

    One of the main advantages for a user of Polygon is the extremely low fees relative to other blockchains, especially in comparison with its parent, Ethereum mainnet.

    P.S.: Polygon is a sidechain of Ethereum.

    The key table for this dashboard is:

    polygon.core.fact_transactions

    Query at a glance:

    SELECT 
      BLOCK_TIMESTAMP :: date AS date, 
      COUNT(DISTINCT FROM_ADDRESS) AS unique_addresses, 
      SUM(unique_addresses) OVER(
        ORDER BY 
          date ROWS BETWEEN UNBOUNDED PRECEDING 
          AND CURRENT ROW
      ) AS cumulative_addresses, 
      COUNT(TX_HASH) AS transactions, 
      SUM(transactions) OVER(
        ORDER BY 
          date ROWS BETWEEN UNBOUNDED PRECEDING 
          AND CURRENT ROW
      ) AS cumulative_transactions, 
      AVG(transactions) OVER (
        ORDER BY 
          date ROWS BETWEEN 5 PRECEDING 
          AND CURRENT ROW
      ) AS transactions_MA5, 
      SUM(TX_FEE) AS fees_paid, 
      AVG(TX_FEE) AS average_fee, 
      SUM(fees_paid) OVER(
        ORDER BY 
          date ROWS BETWEEN UNBOUNDED PRECEDING 
          AND CURRENT ROW
      ) AS cumulative_paid_fees 
    FROM 
      polygon.core.fact_transactions 
    WHERE 
      date >= '2022-07-01' 
      AND date < CURRENT_DATE 
    GROUP BY 
      date 
    ORDER BY 
      date DESC
    
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...

    As you can see, the slope of the cumulative transactions line is greater than the slope of the cumulative count of addresses.

    This is an inevitable phenomenon. Simultaneously with the growth of the network based on the number of users, transactions and interactions go up.

    On the other hand, there is a hidden coefficient that multiplies the count of current active addresses to achieve the count of transactions.

    Loading...
    Loading...
    Loading...
    Loading...

    As an unexpected result, we can figure users' greedy mode out.

    When the average fee goes up, users try to have more transactions. Maybe, it’s a cognitive error (Something like Fear Of Missing Out, AKA FOMO).

    MA5

    The 5-day Moving Average shows that we have an explicit drop on July 9th.

    One of the side effects of a bear market could be the reluctance of users to interact with networks.