flipside

    Try Quests to earn cryptoTry Quests to earn crypto
    Share

    User Activity

    NFTX is a platform for creating liquid markets for illiquid Non-Fungible Tokens (NFTs). Users deposit their NFT into an NFTX vault and mint a fungible ERC20 token (vToken) that represents a claim on a random asset from within the vault. In this dashboard, we examine the activity of users in these vaults

    db_img

    Overview

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

    • Analyze user activity providing and removing liquidity from NFTX vaults. Which three vaults have seen the most activity over the past 60 days?
      • Are there any similarities between these vaults or NFT projects?
    • Explain and visualize your findings.

    Introduction

    NFTX is a platform for making ERC20 tokens that are backed by NFT collectibles. These tokens are called funds, and (like all ERC20s) they are fungible and composable. With NFTX, it is possible to create and trade funds based on your favorite collectibles such as CryptoPunks, Axies, CryptoKitties, and Avastars, right from a DEX like Uniswap.

    There are two types of funds on NFTX:

    • D1 funds (input) have a 1:1 backing between a single NFT contract and an ERC20 contract. For example, if Alice owns 2 PUNK-ZOMBIE, that means she can redeem exactly two random zombie CryptoPunks at any moment. Another example would be Alice owning 1 AXIE-MYSTIC-2, giving her the ability to redeem one random Axie with two Mystic parts.

    • D2 funds (top-level) are Balancer pools which combine D1 funds. For example, AVASTR will be a D2 fund which combines three different D1 Avastar input funds (AVASTR-BASIC, AVASTR-RANK-30 & AVASTR-RANK-60). The point of this is to offer more diverse exposure without requiring users to hold multiple tokens.

    When a new fund is created, the account which sends the transaction is designated as the fund manager. This allows the creator to change fund parameters like fees, supplier incentives, and NFT eligibility. When the creator is done modifying the fund they can then “finalize” it which gives up their control to increase trustlessness.

    Method

    1. > To solve this question and understand how users generate liquidity, I went to the NFTX.io site and opened two transactions in the Activity section.

    • > One related to the Provide of liquidity. (staking NFT)

      • >And another Remove from liquidity. (Unstaking NFT)
    1. > Based on the information I received, I wrote my query.

    • >I used ethereum.core.fact_event_logs table for this, but the problem was that it did not name the NFT Collection.

      • >For this reason, I gave each transaction with ethereum.core.ez_nft_transfers Join table.
    1. > Then I connected my two CTEs, one for Provide and the other for Remove, with the union all command.
    Loading...

    • The chart above shows the activity Based on the number of transactions of the vault both in terms of providing and removing liquidity.

    • These vaults have been most active in the last 60 days.

    • milady vault is common to other vault and has provided both providing and removing liquidity.

      • The highest number of providing is related to the milady vault.

      • The lowest number of providing is related to goblintown vault.

      • The highest number of removes is related to milady vault.

      • The lowest number of removes is for lostboy vault.

    Loading...

    • The chart above shows 3 of the highest selling NFT collections in dollars.

    • If we want to compare with providing and removing liquidity.

    • Milady collection its sales volume in the last 60 days has affected its providing and removing liquidity.

    Loading...

    • The chart above shows the activity Based on the Unique address of the vault both in terms of providing and removing liquidity.

    • These vaults have been most active in the last 60 days.

    • Again milady vault is common to other vault and has provided both providing and removing liquidity.

      • In this comparison, each address is 1 time providing and removing liquidity.

    Conclusions

    1. Milady collection In all respects, it has been the most active in the last 60 days.

    2. The highest number of providing is related to the milady vault. 876 transactions .

    3. The highest number of removes is related to milady vault.127 transactions .

    4. milady total dollar sales volume over the past 60 days has increased with the amount of providing and removing liquidity.

    Milady Maker is a collection of 10,000 generative pfpNFT's in a neochibi aesthetic inspired by street style tribes. Milady Maker is a collection of 10,000 generative pfpNFT's in a neochibi aesthetic inspired by street style tribes.

    about milady

    db_img
    • In the picture above, you can see 4 examples of MILADY collection that are in NFTX
    • image Source
      This Link

    Chart & Analyze;