Solana Bounties (Metaplex Bot Free)

Description of work: Metaplex is a collection of tools, smart contracts, and more designed to make the process of creating and launching NFTs easier. While initially focused on supporting the needs of the arts and entertainment industry our plans extend far beyond that to all use cases where an NFT may add value. First step: ---> We want find how many bot transactions and thus how much SOL has Metaplex captured after April 29th. Second step: ---> We want to find the Bot tax that implemented by Metaplex on Bot mints. Last Step: ---> Display when these transactions occurred over time and if there were certain wallets that have been discovered to be guilty of botting the network.

What is Solana?

Metaplex is built on Solana not only because of scalability, but also because Solana has many other great features, including "Proof of History". Solana has a great reputation to launch NFT's in part because of the work of the Metaplex team. Initally a Solana initative, we were spun out in order to achieve our goal of creating a best in class NFT creator experience.

What is Metaplex?

Metaplex is a collection of tools, smart contracts, and more designed to make the process of creating and launching NFTs easier. While initially focused on supporting the needs of the arts and entertainment industry our plans extend far beyond that to all use cases where an NFT may add value.

Currently our two major projects are:

1 ---> Metaplex Storefront - a generalizable NFT selling standard 2 ---> The Candy Machine v2™ - a Profile Picture (PFP) focused tool that works like the gumball-style candy machines of old

What's next for Metaplex?

Metaplex have big plans. Based on the response from the Metaplex Community, we see a bright future and lots of demand for the tools and services that help people everywhere create awesome NFT projects. Currently, metaplex remaining hyper focused on building great experiences for NFT creators and developers starting with creator storefronts and helping creators distribute NFTs to their communities via auctions, instant sales, NFTs, and even more.

1- Bot transactions details by day

To address this part, we used the [Solana] schema, and [sloana.fact_nft_mints] table, in first query we find Metaplex [PROGRAM_ID] by ---> [MINT_PRICE = 0.01]. The addresses of Metaplex mint are [cndy3Z4yapfJBmL3ShUp5exZKqR3z33thTzeNMm2gRZ]. Then in the [fact_nft_mints] table we get the list of mints done by Metaplex and select its [tx_ids] ---> Finally, in the [fact_transactions] table, based on the [tx_id] we obtained, we get the number of bots, the number of transactions by the bots, the amount of sol captured by Metaplex, provided that it is [cast(log_messages as string) like '%Candy Machine Botting is taxed at%'], on a daily basis from 2022-04-29.

According to the results and graphs, the more transactions by bots, the more sol is captured by Metaplex.

flipside