What is going to be shown in this dashboard?

Q6. Find the wallet that collects Opensea fees. Make a dashboard showing how much Opensea has earned through Polygon transactions. 

Method

• Using table polygon.udm_events, wallets (1) 0xad79e2ea4424781ec61c52cd2464f6ad525e2a5d, (2) 0x5b3256965e7c3cf26e11fcaf296dfc8807c01073, and (3) 0x0eb9198b6375d5deb55101dc7b82ad6654d3301b' were identified as the main wallets that collected Opensea fees.

  \

• In the following, some data related to income earned in the form of WETH by Opensea through polygon transactions are visualized. The reason why these fees are shown in WETH is that is used by users to do their transactions on OpenSea.

• As it is seen, the lowest amount of fees and the fewest number of transactions is for May to Aug, 2022. After it, we have a gradual increase in the number of transactions that has also an increase in the amount of fees.
• After a peak point on Jan 3, 2022 (transactions = 101.506k, total amount of fee= 21.62509 ETH), there is a sharp increased on Jan 4, 2022 (transactions = 58.269k, total amount fee = 14.77916ETH).
• Then we have the highest daily number of transactions as well as the amount of ETH spent as fees on Jan 15, 2022 ( transactions = 111.834 k, total amount of fee = 26.04837 ETH)
• From Feb 28, 2022, there is a decline in both the daily number of transactions and fees spent up to date that can be inferred as the bad bearish situation dominated to the market.

• This graph shows the cumulative amount of fees spent from May, 2021 to Jul, 2022. As it is clear the amount of fees obtained from buying and selling NFTs on Opensea has experienced a considerable increase, so that the cumulative amount of fees on May, 2021 has been increased from 0.48 ETH to 5,278.99 ETH on Jul 21, 2022.

• ZED RUN Legacy is the first NFT that has provided the highest amount of fees (Total fee in USD = 2914242.49955533, Total fee in ETH = 967.954275952; 47.9%), followed by Crypto Unicorn Market (Total fee in USD = 722318.081302736, Total fee in ETH = 242.554212334; 11.9%), and DeRace Horses (Total fee in USD = 329502.611472781, Total fee in ETH = 113.700554432; 5.78%) as the second and third top NFTs, respectively.