Description of Work

In this bounty, we want to examine the NFTs of the Polygon network, for this we will do the following:

Track daily volume over the past month
How popular are NFTs on Polygon?
How many Polygon users started off with NFTs?
Who made the most profit?

Note

We use the polygon.core schema, fact_transactions and fact_event_logs tables

We use the schema ==polygon.core== and the data related to the tables is available to us from ==2022-06-06== onwards and we do all our calculations and analyzes from 2022-06-06 onwards.

We got the some idea from this Dashboard to deal with this bounty

Method

To do this, we first obtain the list of transactions for the sale of NFTs in the fact_event_logs table in the ==polygon.core== schema, provided that:

event_inputs:tokenId is not null
- NFT transactions
event_name = 'Transfer' and event_inputs:from!='0x0000000000000000000000000000000000000000'and event_inputs:to!='0x0000000000000000000000000000000000000000' and matic_value>0
- NFT sales transfer
Then we do our calculations for the Number of Sales, Volume of Sales, Number of Sellers, Number of Buyers, Profit, etc. on a daily and overall basis.

\

1 → Summary of NFT analysis at Polygon from ==2022-06-06

Conclusion of part 1

From 2022-06-06 onwards, the total number of NFT sales in Polygon is 67064 with a volume of 4123934 MATIC, of which 12786 unique buyers and 13514 unique sellers have been recorded in this period.

2 → Track daily volume from ==2022-06-06== onwards

Conclusion of part 2

From 2022-06-06 onwards, the total number of NFT sales and the sales volume of NFT shows a constant and the same trend, also the number of sellers has a constant and the same trend, but on Jun 15 we see more buyers than other days with a number of 1436 buyer
On Jun 10, we see the lowest transaction and activity for buying and selling NFT

3 → How popular are NFTs on Polygon? ==(From 2022-06-06 onwards)

Conclusion of part 3

As of 2022-06-06, the most popular NFT collection by sales volume (MATIC) includes (Overall and daily):
- League of Kingdoms ITEM with 2387495 MATIC
- ZED Horse with 532825 MATIC
- NFT SKY with 91634 MATIC
As of 2022-06-06, the most popular NFT collection by number of sales includes:
- League of Kingdoms ITEM with 19323 sales
- ZED Horse with 12692 sales
- Galaxy OAT with 3578 sales
\

4 → Number of Polygon users that started off with NFTs

To address this section, we want to calculate the number of wallet addresses in Polygon whose first transaction was related to the transfer, purchase or sale of NFT, so we need all transactions made in Polygon in order to get the correct result in this section. So, we use the events_emitted table in the polygon schema and do the following:
- First we get the first NFT transaction for each wallet
  - sellect wallet and min(block_timestamp) and ‘Start with NFT‘ as type where transaction related to NFT → Pseudocode
- Then we get first ==non-NFT== transaction for each wallet
  - select wallet and min(block_timestamp) and ‘Start with Other tx‘ as type where transaction not related to NFT → Pseudocode
- Finally, among the obtained results, we count the addresses (count (distinct wallet)) whose first transaction was related to NFT (started with NFT):
  - row_number() over(partition by wallet order by min_block_timestamp) as row_num → where row_num = 1 and type = ‘Start with NFT‘→ ==Pseudocode
View full query

Conclusion of part 4

The total number of unique addresses that have transacted on the Polygon network is 44085563, of which 10835915 unique addresses have started the first transaction with NFT, about 24.57% of the total number of addresses and 33249648 of the addresses have started with other transactions i.e. 74.43%
The highest number of addresses that made their first transaction for NFT are on Apr 19 2022 and Apr 18 2022, followed by Mar 26 2022.
- The reason for the increase in the number of users from Apr 2022 can be due to the following fund:
  - Polygon Upcoming NFT Drops \n

5 → Who made the most profit? ==(From 2022-06-06 onwards)

To do this part, we define profit as follows:
- Profit: The amount of NFT sales (in MATIC) for each address minus the amount of NFT purchases (in MATIC) for each address
So we first get the amount of NFT buying and selling for each address, then we subtract these two values and get the addresses that have the most profit.

Observations

According to our definition of profit in NFT, the top wallets with the highest amount of profit (in MATIC) include:

0xdf7369390396e1f9aabdc708d91434880219a878 with 68081 MATIC has had the most profit from NFTs since 2022-06-06
0x235e12fcd728d894ab867d13179ae872badbe30e with 58472 MATIC is the second most profitable NFT since 2022-06-06
0xeaffe16544de0c8708d5ad17928b8663cb425c63 with 55758 MATIC is the third most profitable NFT since 2022-06-06

Conclusion of part 5

From 2022-06-06 onwards, the address 0xdf7369390396e1f9aabdc708d91434880219a878 has had the highest amount of profit. It is interesting that this wallet has had the highest amount of purchases and the highest amount of sales during this time period, and the highest NFT activity (buying, selling and profiting) related to This is the address
- polygonscan

Final Conclusion

> * According to the results and analysis of NFTs in Polygon since 2022-06-06, the total number of NFT sales has been 67.1k, the sales volume is 4.12M MATIC, which has been done by 12.79k buyers and 13.51k sellers, also the largest amount The NFT sale is on Jun 14, the highest number of sales is on Jul 4, and the highest number of NFT buyers is on Jun 15. > > > * In this time frame, the most popular NFT set in terms of number and sales volume is related to League of Kingdoms ITEM with a volume of 2387495 MATIC and 19323 sales. > * Since the beginning, from 44085563 unique addresses on Polygon, 10835915 addresses have started their first transaction with NFT. > * Also, since 2022-06-06, the address 0xdf7369390396e1f9aabdc708d91434880219a878 has had the highest amount of buying, selling and profiting in NFTs on Polygon

flipside