Try Quests to earn cryptoPolygon - Daily Transactions and Unique Addresses
Description of Work
> In this bounty, we want to examine Daily Transactions and Unique Addresses on Polygon from July 2022 onwards and we want to know that Polygon is still growing, has reached a plateau, etc.
To do this, we consider the following:
- Total number of transaction on Polygon, beginning July 1, 2022
- Total number of unique addresses on Polygon, beginning July 1, 2022
- Daily transaction on Polygon, beginning July 1, 2022
- Daily unique addresses on Polygon, beginning July 1, 2022
- Daily transactions and unique addresses in the first 10 days of each month in 2022 - To compare growth and plateau
- Comparison of transactions and unique addresses with MATIC price in 2022
Note
- We use transactions table in polygon schema and fact_hourly_token_prices table in ethereum.core schema for get MATIC price
- For find transactions we
count(distinct tx_hash)in transactions table - For find unique addresses we
count(distinct from_address)in transactions table - Currently, in the month of July, we have little data to compare the growth and whether Polygon has reached a plateau, so in order to have a better analysis:
- We will compare the data of the first 10 days of each month in 2022 with the first 10 days of the current month (July).
- Because we may not have the current day's data completely, we use the following condition for the month of July:
block_timestamp::date < current_date - 1→ The day before
Conclusion of part 1
- The total number of transactions from July 1 is 25484809, of which 24199552 were successful (94.95%) and 1285257 were unsuccessful (5.05%)
- The total number of unique addresses that have transacted from July 1 is 982124 unique addresses.
Conclusion of part 2
> According to the results obtained from the total number of unique addresses and transactions since the first of July, it is clear that a same trend is observed on a daily basis in the number of transactions and unique addresses, and no sharp growth or significant decline is observed, so for comparison Better, we compare the first 10 days of July with 10 days of other months in 2022 for the number of transactions and unique addresses.
Conclusion of part 3
- According to the results obtained from the comparison of the number of transactions and unique addresses on a daily basis in the first 10 days of each month in 2022, it is clear that the number of transactions has been decreasing since the beginning of the year in the first 10 days of each month in each month, but it is clear is that there is a constant trend and there are no signs of sharp growth
> An interesting point that can be seen is that transactions and unique addresses, both in general and on a daily basis, have grown in the first ten days of July compared to the previous month, June, but not a sharp growth (maybe the data in the database for the first ten days of June It is not complete) but in the month of July, the number of transactions and the number of unique addresses have a constant trend on a daily basis
Conclusion of part 4
> According to the comparison of the price of MATIC and the number of transactions and unique addresses, it is clear that since the beginning of 2022, the price of MATIC has been in a downward trend and the number of transactions and unique addresses is also in a downward trend, but there is no relationship between the number of transactions and unique addresses and the price of MATIC in some places It is clear that the price of MATIC has decreased, but the number of transactions has increased, and on the contrary, according to what can be seen, the number of transactions and unique addresses have been going through a steady trend recently (July).
Final Conclusion
According to the analysis of the number of transactions and unique addresses in the month of July (==recent and the first 10 days==), the number of transactions and unique addresses are going through a steady trend and no evidence of growth is observed, and it can be said that Polygon has reached a plateau, also from the comparison of the number Unique transactions and addresses in the first 10 days of every month in 2022, with the first 10 days of this month (July), we concluded that the number of transactions and addresses in the first 10 days has a constant trend and no growth has been observed compared to previous months, but Compared to the month of June has been growth, it can be seen that the data in the database is not complete