Polygon | Daily Transactions and Unique Addresses
The number of daily transactions and unique addresses on Polygon, beginning July 1, 2022.
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
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.
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).