Introduction

OpenSea is one of the main markets for non-fungible tokens (NFTs) and has become an integral part of the decentralized ecosystem. NFTs are tokens that prove the ownership of a digital asset, be it a work of art or a video game.

methods

1-In the first method, I use the flipside_prod_db.polygon.udm_events table.

2-In the second method, I use the polygon.core.fact_token_transfers table And I used the token prices from the ethereum.core.fact_hourly_token_prices table.

And in both methods, I used two wallet addresses

0x8de9c5a032463c561423387a9648c5c7bcc5bc90and 0x5b3256965e7c3cf26e11fcaf296dfc8807c01073as the addresses that collect the fees.

Method 1

Method 2

Note: in this method, all data have been available since 2022-06-06 and have been reviewed.

Result:

As you know, I used old tables in this method and they have problems, taking these mistakes into account, we go to the numbers. As you can see, OpenSea has earned $13.77M usd by taking 2.5% fee on the Polygan network in its own NFT market, and the highest amount in one day is 117.17K usd on June 28, 2022.

But in general, due to the problems of these tables, I explored more in the new table, even though there is less information in the time frame.

I considered two possibilities here. The first is that OpenSea has not yet sold the tokens it has received, and the second possibility is that OpenSea will convert the tokens into dollars at the same moment by means of bots.

Well, if OpenSea had sold at that moment, it would have earned 327k dollars in this period of time, and if it had not sold the tokens, it would have earned a total of 423k dollars from these sales.

According to the numbers and this table, the highest earnings of OpenSea from NFT sales fees in Polygan network is on June 15, 2022 with $11,816k, which is twice the daily average, and the lowest daily earnings is on June 24, 2022 with The number is 2701 dollars, which is approximately 43.7% less than the daily average, and in this period, OpenSea is on average every day 5825 dollars is earned from these 2.5% fees in Polygan network.

In this section, We check which tokens generated the most fees.

As you can see in the charts, the majority of OpenSea's income is from Weth. The income earned by this token is 305 thousand dollars, which is 95.3% of the total income. And in the second place is the Dai token with 15 thousand dollars and a total percentage of 4.73% of the total income, and in the third place is the revv token and in the fourth place is usdc. Note: All these numbers are based on dollar volume.

In this part, we will check two addresses,

0x8de9c5a032463c561423387a9648c5c7bcc5bc90 and 0x5b3256965e7c3cf26e11fcaf296dfc8807c01073

which are responsible for storing sales items. As you can see, Wallet 0x8de9c5a032463c561423387a9648c5c7bcc5bc90has been activated since June 15, 2022, and in this time period, it has collected more fees than the older wallet.

The total fees stored in Wallet 0x8de9c5a032463c561423387a9648c5c7bcc5bc90is 212.71 thousand dollars, which is 66.4% of the total. Also, the total fees stored in the wallet 0x5b3256965e7c3cf26e11fcaf296dfc8807c01073is 107.67 thousand dollars, which is 33.6% of the total fees.

As you can see from the graphs, this 0x5b3256965e7c3cf26e11fcaf296dfc8807c01073 address has faded in recent days.