Sushiswap Flash Bounties (Sushi's contribution to Polygon growth)

    Description of work: Goal ---> Since Sushiswap introduced polygon, many have adopted polygon to either swap or use other services. With this in mind, what is the contribution of Sushi to the growth of Polygon user base? Schema used ---> [polygon]. Table used ---> [polygon.events_emitted] and [polygon.transactions]. Method --->Number of transactions daily number of unique user (wallets), before Sushiswap introduced polygon. Number of transactions daily number of unique user (wallets), after Sushiswap introduced polygon. Number of transactions daily number of unique user (wallets), by assumptions ( If a Matic(polygon) wallet has interacted with sushi within its first 2 transactions then we can assume it was built to interact with sushi).

    What is the polygon platform?

    Polygon, formerly known as the Matic Network, is a protocol and framework for building and connecting Atrium-compatible blockchain networks. The protocol seeks to address some of Atrium's major constraints, including its operational capacity, poor user experience, and lack of community governance, using a new chain solution.

    Paligan is supported by Binance and Coinbase. The project seeks to widely accept cryptocurrencies and solve scalability problems in many Chinese blocks. Instead of being a simple scalable solution like the previous Matic network (which uses technology known as plasma to process out of-chain transactions before finalizing them in the main Atrium chain), Polygon is designed entirely for inter-blockchain collaboration. Is. Through Polygon, developers can set up predefined blockchain networks with features to suit their needs.

    db_img

    Change Matic network to Polygon

    In February 2021, Matic Network, a project to develop Atrium-based Layer 2 and China-based block proof-based solutions, announced that it was changing its brand to Paligan. While existing products and tokens remain largely unchanged, the new brand heralds a strategic shift to becoming a second-tier aggregator.

    Atrium-compatible networks, which aim to substantially reduce commissions and transaction times, have different names based on their scalability approaches. These include Layer 2s, Rollups, Sidechains, and Plasma Chains. As Atrium's core network faces overcrowding and high costs due to increased demand, popular solutions as well as users are looking for effective alternatives.

    In addition to its operating method, Polygon supports other Atrium scalability solutions, especially Optimistic Rollups, ZkRollups and StarkWare’s Validium. This strategy is implemented through the new Polygon SDK, which allows developers to build their own decentralized applications (DApps) on Atrium scalable infrastructure, without the need to select any specific technology. The Polygon platform intends to turn Atrium into a multi-chain system, and its core project team admits that this is not unlike other projects such as Polkadat, Kazmes or Avalanche. But they believe that this atrium-based strategy offers several significant advantages over competing systems.

    The Paligan strategy, if implemented successfully, could have major impacts on the atrium ecosystem. It is unknown at this time what he will do after leaving the post.

    Address the question

    First Step ---> Find out the date of Polygon introduced by Sushi's

    db_img

    To get the date of acceptance of Polygon by Sushi's, in the table ---> [polygon.events_emitted] based on ---> [where lower (contract_name) like '% sushiswap%'] filter and sort by day and sort in ascending order and get the first date ---> limit 1 (top 1)

    Loading...
    NOTE: On 2021-02-26 the Polygon has been accepted by Sushi's

    In the next step, we will examine the number of transactions per day and the number of wallet created on Polygon before 2021-02-26.

    Second Step ---> Number of transactions per day before 2021-02-26

    In this step, in the [polygon.transactions] table, we calculate the number of transactions daily before [2021-02-26].

    Loading...
    Loading...

    Number of user (wallet) create before 2021-02-26

    In this step, in the [polygon.transactions] table, we calculate the number of unique wallet before [2021-02-26].

    Loading...
    Loading...

    Third step ---> Number of transactions per day after 2021-02-26

    In this step, in the [polygon.transactions] table, we calculate the number of transactions daily after [2021-02-26].

    Loading...
    Loading...

    Number of new user (wallet) create after 2021-02-26

    In this step, in the [polygon.transactions] table, we calculate the number of new unique wallet created after [2021-02-26]. for address this part, we first get wallet address before [2021-02-26], then calculate the number of new unique wallet where ---> [from_address not in (select wallet_address from before_number_of_wallet_created)]

    Loading...
    Loading...

    According to the results, it can be seen that the number of daily transactions and the number of unique wallets created after [2021-02-26] has increased significantly, and this shows that after the acceptance of the polygon by sushi's The number of polygon users has greatly increased.

    Loading...

    We observed that the growth rate of the number of wallets on the polygon increased by 196% after [2021-02-26]

    Fourth step ---> Number of transactions per day on Sushi's (interact with sushi's)

    In this step, we calculate the number of daily transactions and Number of unique users (wallet) interact with sushi's performed for swap on Sushi's in the polygon. According to the hint, in the polygon.events_emitted table we calculate the transactions that:1 ---> Create for swap: [lower (event_name) like '% swap%'] or Create a "LogDeposit" to deposit to Bento: [(Lower (event_name) like '% logdeposit%')] [and] 2 ---> Sushi contract: [lower (contract_name) like '% sushiswap%'] or Bentobox address in polygon equal to: 0x0319000133d3ada02600f0875d2cf03d442c3367 [contract_address = '0x0319000133d3ada02600f0875d2cf03d442c3367']. After obtaining the address of the transactions in this query, I join it with the table [polygon.transactions] and assume that: If a Matic(polygon) wallet has interacted with sushi whithin its first 2 transactions then we can assume it was built to interact with sushi.

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

    Based on the results, it can be seen that out of 12 million newly created wallets, 1.5 million were created to swap sushi's (interact with sushi's), and show that sushi's has played an important role in the growth of Polygon. Also in daily transactions, transactions that were only for sushi's show a significant number