Question:

Q3. How popular are NFTs on Polygon? Track daily volume over the past month/year/etc.

How many Polygon users started off with NFTs? Who made the most profit?

Overview of essay:

In this essay the popularity of NFTs on Polygon has been established. By the use of new table of Flipside community for Polygon ecosystem, the daily volume of trading NFTs on Polygon has been presented. Furthermore, the accounts on Polygon that start using ecosystem by NFTs have been discovered. After that the profit of accounts on Polygon found based on difference of total sale and total buy.

Note: The data on new tables returns results only for 40 days so in this essay the study made for the last 40 days.

Approach:

The methodology of this essay contains the following steps:

1. First we should identify the events for NFT trading

   event_inputs:from as seller

   event_inputs:to as purchaser

   event_inputs:tokenId as token_id

   contract_address as nft_address

   from Polygon.core.fact_event_logs

2. In the second step track daily volume, count of trades and unique purchasers.

3. The collected fee for NFT trades on Polygon addressed by

   sum(TX_FEE) as FEE_MATIC,

   from polygon.core.fact_transactions inner join tb1 using(tx_hash)

4. Identification of Polygon accounts started off by NFTs with

   ROW_NUMBER() OVER (partition by purchaser order by BLOCK_TIMESTAMP) as t_n

   where t_n=1 -- stands for first transaction

5. Profit of wallets

   sale_volume-bought_volume as profit

Key findings 1:

1. The daily volume of NFT trades on Polygon has been tracked by MATIC and USD value.
2. The movement of daily volume has consistent behavior with little increasing slope.
3. The average price of NFTs on Polygon has growing trend in the past 40 days and biggest average price occurred on July 15th.
4. Like Daily volume, the count of NFT trades on Polygon has growing attitude overall.
5. The Daily paid fee by trading NFTs on Polygon reveals the inconsistent movement with high paid fee on June 15th by 2730 MATIC.
6. The USD value of paid fee depends on various factors like count of transactions, congestion of network and price of MATIC.

Key findings 2:

1. About 12.54k unique account created for NFT trades on Polygon and we said that based on the considering their first transaction on NFT trades.
2. The daily created accounts for NFT trades on Polygon reveals that the highest accounts created on June 15th with 985 unique users.
3. As mentioned in the Approach section, the total profit of wallets estimated by difference of total sell and buy.
4. According to the table and bar graph related to accounts with most profit, the account with more than 834k $ stands in the first rank and gain the largest profit from trading NFTs on Polygon.