Dimension X Activity Analysis

📖Introduction
🟢 What is Flow?
Flow is a blockchain designed for scalability without the need for sharding techniques, which enables low-cost, high-speed transactions and is suitable for decentralized applications such as NFT markets and crypto-based video games. Flow was designed by Dapper Labs, who decided to solve the problems of other blockchains by building a blockchain designed for games and other interactive experiences. Dapper now uses Flow for all of his projects, including NBA TopShot, but other developers can use it as well.
🔴 What is Dimension X?
Dimension X is a new RPG based on a play-to-earn, blockchain underpinning. Dimension X is one of Flow's hottest NFT games where users can create a team of heroes to go on quests and battle enemies. Each quest is a competition with other hero teams.
🧠Purposes of Dashboard
In this dashboard, we analyze Dimension X activity. This dashboard consists of 4 parts: In the first part, the sale of Dimension X NFTs is analyzed. The volume and number of transactions of buying and selling NFTs as well as the performance of buyers and sellers are examined in this section. Gamers can stake their NFTs, so in the second part, we examined the status of staking and unstaking NFTs in this game. Gamers can also mint their heroes, so in the third part we went to review NFTs minting. Finally, in the fourth part, we also analyzed the deposit and withdrawal status of NFTs.
🧱 Methodology
We took help from Flipsidecrypto database to extract the data. We used the flow.core.ez_nft_sales
table to check the buying and selling status of Dimension X NFTs. To receive information about buying and selling NFTs in this game, the condition NFT_COLLECTION='A.e3ad6030cbaff1c2.DimensionX'
was considered. On the other hand, using the flow.core.fact_events
table, information about mint, stake, unstake, deposit and withdraw was received. The total fees paid related to mint, deposit, withdraw, stake and unstake transactions were also calculated by joining two tables flow.core.fact_events
and flow.core.fact_transactions
.