db_img

    Overview


    In this dashboard, I will answer this question from Flipside Crypto:

    • 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?

    \n

    Introduction


    What is Matic on Polygon?

    • MATIC is an ERC-20 token, meaning that it's compatible with other Ethereum-based digital currencies.
    • MATIC is used to govern and secure the Polygon network and to pay network transaction fees
    • Polygon uses a modified proof-of-stake consensus mechanism that enables consensus to be achieved with every block. (Achieving consensus using traditional proof-of-stake requires processing many blocks to achieve consensus.) The proof-of-stake method requires network participants to stake—agree to not trade or sell—their MATIC, in exchange for the right to validate Polygon network transactions. Successful validators in the Polygon network are rewarded with MATIC.

    what is Opensea?

    OpenSea is an American online non-fungible token (NFT) marketplace headquartered in New York City.

    The company was founded by Devin Finzer and Alex Atallah in 2017.[2][3]

    OpenSea offers a marketplace allowing for non-fungible tokens to be sold directly at a fixed price, or through an auction, based on the Ethereum ERC-721 standard, the layer-2 scaling solution for Ethereum Polygon, the KIP-7 standard for Klaytn, and the SPL standard for Solana.

    for more information you can read hear

    Method


    To solve this question, I first checked opensee transactions on Polygon in the flipside_prod_db.polygon.udm_events table. I noticed that each opensee transaction contains several transactions. And the point was that the transaction in which I could understand the name of the collection did not have the sale price, and in fact, I had to get the name of the collection and the price that was sold from two separate rows. For this, I first put the dollar volume of opensee transactions in a CTE. To get the volume of flipside_prod_db.polygon.udm_events, I selected this table and used the following conditions to limit the answers. TO_ADDRESS = '0xf715beb51ec8f63317d66f491e37e7bb048fcc2d' and TO_LABEL = 'opensea' and TO_LABEL_TYPE = 'nft' The above conditions bring opensee transactions. In addition, the question asked me to get the daily, monthly, etc. volume. For this, I used the date_trunc('day', block_timestamp) function.

    I also used the table flipside_prod_db.polygon.udm_events and polygon.core.dim_labels to find the names of the collections. I selected addresses whose CONTRACT_ADDRESS is equal to the polygon.core.dim_labels table information. In fact, have a transaction that is equal to the nft contract. Like the previous CTE of the date_trunc('day', block_timestamp) function. I also used it to get the date Then I joined the information of each CTE so that TX_ID = TX_ID and date = date to be sure of my answers. Then I put the collections whose total sales were more than 5,000 dollars into the CASE command and saved the rest to other collection so that I can do a better analysis.

    In order to find out what percentage of people their first transaction was related to nft, I used min(block_timestamp::date) and then separated the transactions that were in opensea with the case command.

    For the third part, I was very confused. I wanted to reduce the sales volume of those who bought from those who sold, but I couldn't think of any way. For this reason, I only collected the dollar amount of those who were sellers and arranged my answers in descending order and chose the first 10. I used all possible conditions for my query so that it does not give a wrong answer. TO_ADDRESS != '0xf715beb51ec8f63317d66f491e37e7bb048fcc2d' -- opensea main contract

    and TO_ADDRESS != '0x0000000000000000000000000000000000000000' --- mint condition

    and event_name = 'transfer' and event_type = 'erc20_transfer'

    and contract_address = '0x7ceb23fd6bc0add59e62ac25578270cff1b9f619' -- WETH contract and from_address != to_address

    In fact, I spent almost 2 days on this question and tried very hard to give correct answers... Thank you for reading!

    Chart & Analysis

    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...

    The graphs show the volumes sold in opensea on a daily, weekly, monthly , yearly basis ==lets Analysis it !

    • Observations show that the sales in certain time periods were more than 3000 dollars and these periods are related to certain collections.
    • For example, on August 25, 2021, sales started a short-term upward wave and continued to rise until September 1, 2021. In this process, the visitors collection started selling and on September 1, 2021, it had more than 12,000 dollars in sales from the 14,000 dollars that were sold on that day (the rest of the collections).
    • From November 8, 2021 to January 27, 2022, it can be said that sales of popular collections did not happen and the sales volume is below $6,000.
    • Or the adidas for prada collection sold more than $50,000 on its first day on January 28, 2022, marking the highest single-day sales record of all time.
    • A little passed and the next wave of nfts sales started on February 12, 2022 with the fancybirds collection In this wave, from the second day onwards, this collection has sold more than 10,000 dollars in several consecutive days.
    • It seems that the sales of nfts or even the best-selling launch collections from May 7, 2022, at the same time as what happened to Terra and the market falls, have decreased a lot!
    • In 2021, the day with the highest sales volume was on September 1, 2021, where $12.8 thousand of the $14.5 thousand sales were related to the visitors collection.
    • In 2022, the day with the highest volume of sales was on January 28, 2022, from $57.7 thousand, $56.9 thousand was related to the adidas for prada collection.
    • The visitors and ghetto granny club collections have been sold on most days of the year.

    • In 2021, the highest weekly sales volume was in the last week of August with an approximate volume of 53.55 thousand dollars and 167.4 Ethereum.
    • In 2022, the highest weekly sales volume was in the second week of February with an approximate volume of 137.57 thousand dollars and 118.73 ethereum (the price of ethereum in 2022 was different from 2021)
    • In 2021, the highest monthly sales volume was in September with an approximate volume of 87.11 thousand dollars and 353.62 Ethereum
    • In 2022, the highest monthly sales volume was in February with an approximate volume of 283.55 thousand dollars and 342.44 Ethereum (the price of Ethereum in 2022 was different from 2021)
    • In 2021, the highest annual sales volume with an approximate volume of 274.11 thousand dollars and 2669.11 Ethereum
    • In 2022, the largest annual sales volume with an approximate volume of 614.49 thousand dollars and 1971.42 Ethereum (the price of Ethereum in 2022 was different from 2021)
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    • The opposite chart shows the number of people whose first transaction was buying nft from Opensea
    • Observations show that only 0.6% of all people their first transaction was buying nft from Opensea,
    • this amount is equal to 10.94 million users.

    The graphs and figures above show which brokers have sold more nft in Opeansea.

    • 0x8b26320912935111300ddaeec15ea9a182ff6f1a

      In total, it has sold about 296.62 million dollars over time, and it can be said that this address has had the most sales among the top 5 addresses.

    • 0x29cad5c2747cbc6c9e37074128fbe679ba8bbd10 it has sold about 295.33 million dollars over time.

    • 0xc6d5ad3c4002a1b48d87b83939698660516ae142 it has sold about 187.48 million dollars over time.

    • 0x9bc428b353ddb00b37d78d6cbcf4afcf74419a4e it has sold about 186.94 million dollars over time.

    • 0xb0449ec1a8a60f95322617d6ed52e1ba1a7beb49 it has sold about 48.99 million dollars over time.

    Conclusion


    • In 2021, the highest weekly sales volume was in the last week of August with an approximate volume of 53.55 thousand dollars and 167.4 Ethereum.
    • In 2022, the highest weekly sales volume was in the second week of February with an approximate volume of 137.57 thousand dollars and 118.73 ethereum (the price of ethereum in 2022 was different from 2021)
    • In 2021, the highest monthly sales volume was in September with an approximate volume of 87.11 thousand dollars and 353.62 Ethereum
    • In 2022, the highest monthly sales volume was in February with an approximate volume of 283.55 thousand dollars and 342.44 Ethereum
    • In 2021, the highest annual sales volume with an approximate volume of 274.11 thousand dollars and 2669.11 Ethereum
    • In 2022, the highest annual sales volume with an approximate volume of 614.49 thousand dollars and 1971.42 Ethereum
    • Fancybirds collection has the highest sales with a total sales volume of 342.26 thousand dollars and 49.7% of the total sales.
    • only 0.6% (10.94m users ) of all polygon users their first transaction was buying nft from Opensea,
    • 0x8b26320912935111300ddaeec15ea9a182ff6f1a In total, it has sold about 296.62 million dollars over time, and it can be said that this address has had the most sales among the top 5 addresses.

    Contact data


    -> the writer : sajjadsmoke -> discord : sajjadsmoke#5567


    Thanks for reading !

    Loading...
    Loading...

    The charts above show the best-selling collections over time

    • Fancybirds collection has the highest sales with a total sales volume of 342.26 thousand dollars and 49.7% of the total sales.
    • the visitors with a total sales volume of 190.05 thousand dollars and 27.6% of the total sales.
    • adidas for prada with a total sales volume of 102.34 thousand dollars and 14.8% of the total sales.
    • cryptosharks with a total sales volume of 27.27 thousand dollars and 3.96% of the total sales.
    • wanderers with a total sales volume of 27.2 thousand dollars and 3.95% of the total sales.