flipside

    Try Quests to earn AVAXTry Quests to earn AVAX
    Share

    Dokyo : KPI Dashboard

    Dokyo isn't just a name or a brand; it's an innovative force, a collective-powered think tank. We're not here to simply challenge norms; we're redefining them. We believe in sharing innovation. We license ideas and intellectual property, empowering our vibrant community to contribute their creativity and insights. As we build groundbreaking products together, we ensure that the rewards are shared among our contributors.

    Introduction
    About me

    Using the avalanche.nft.ez_nft_transfers table and identifying the project_name as Dokyo and the nft_address as 0x54c800d2331e10467143911aabca092d68bf4166 for looking activity, the activity consisted of Mint and Other. Additionally, it also joined with the tx_hash to avalanche.core.ez_avax_transfers table for looking at how they paid with $AVAX and converted it into dollars.

    Joining the avalanche.core.fact_token_transfers table and found out the contract address of NFT marketplaces in the origin_to_address type on this table.

    • Hyperspace [ 0x398baa6ffc99126671ab6be565856105a6118a40 ]
    • Joepegs [ 0xae079eda901f7727d0715aff8f82ba8295719977 ]
    • Salvor [ 0xf65e9264aab3466b3753c172e6d1b340b485ebd9 and 0xd86456d9ccc6d4ed7402d041d7e391d145bb9865 ]
    • Opensea [ 0x00000000000000adc04c56bf30ac9d3c0aaf14dc ]

    Each of the above addresses uses a different command to purchase this collection, and some transactions can buy many NFT tokens with the wrong value. therefore using the avalanche.core.ez_decoded_event_logs table to look at the true price sold of each token of Dokyo.

    db_img
    Thank you for your time