• Q1. Count and plot the number of daily transactions and unique addresses on Polygon, beginning July 1, 2022.
• In your estimation, discuss whether Polygon is still growing, has reached a plateau, etc.

Introduction

• Polygon is a second layer of the Ethereum network created in order to make easier the blockchain network, allowing speedy transactions and work as a low-cost ecosystem.
• Matic is the cryptocurrency of Polygon, which enables governance, pays fees and can be staked.

Methodology

Using Flipside’s data banks tables:

• flipside_prod_db.polygon.transactions
• polygon.core.fact_transactions

Polygon data is being migrated in Flipside, with an unique category for Polygon, so there may be discrepances in the records, which is the reason why i’ll be using both tables to find addresses and transactions.

• Disclaimer: All the queries have their respective credits in the SQL, i’ll provide my own analysis based on their data.

Analysis

• This is the main reason i’m using both tables, because polygon data is being migrated there is this problem that a lot of “old_users” doesn’t have their “old_data” in the new polygon tables, which makes the same as the “new_users” in the new polygon tables, in other words, their first record of transaction is from July 1 in the new tables, making as “new_users” and causing the big spike.
• Thanks to the Polygon old tables is possible to see that there is a spike of new users in July 6, and afterwards a new record of new users in July 11.

• Regarding new users, in the graph above, in June 27, is the biggest spike of new users in Polygon. Although there is some valleys afterwards, in the recent days there is an uptrend in new users.
• Every day from July there is more than 190k unique users interacting with Polygon, making more than 1 million of unique addresses doing transactions only in this month.
• In the case of transactions, every day there is more than 2 millions of transactions made in Polygon, with a fail rate below the daily 10%.

Summary

• There is more than 1M of unique users and 28M of transactions made only in the first Half of July.
• Considering that the biggest spike of new users were in June 27, Polygon is still growing, with a lot of activity in this month.