Team9-miniproject2-<Lockdown Lemmings> analysis

"Lockdown Lemmings" is an NFT effort that captures the spirit and problems of the global lockdown period. This digital art series comprises one-of-a-kind, algorithmically created lemmings that each depict a different part of quarantine life with distinct, colorful designs. The project's goal is to build a community based on shared pandemic experiences, providing both a creative outlet and a historical reflection using blockchain technology. Collectors can own, trade, and participate in a burgeoning ecosystem commemorating an extraordinary period in contemporary history. In this dashboard, we have curated five distinct queries to dissect the complexities of Lockdown Lemmings from multiple angles, each chosen to highlight a different aspect of the project. These queries are not just statistical examinations but also are strategic lenses through which we can observe and interpret the nuanced behaviors and economic realities of the NFT landscape.

We want to identify the top 10 NFT projects by sales volume and have understanding of which NFTs generating the most revenue since this step can help in understanding market preferences.

Then we want to focus on a specific project named Lockdown Lemmings since one of the team member used to hear about this project. We want to analyze the distribution over time. Specificsally, we analyze how prices have changed over time for Lockdown Lemmings. We use a CTE to group sales by selling date and calculate average, minimum, and maximum prices. We Identify trends in pricing.

We want to find out what is the highest purchase amout of Lockdown Lemmings. So we identify wallets that have purchased multiple NFTs from this project. We use the CTE to count purchases per wallet.By doing this, we think may be we could reveal investor loyalty.

We want to analyze the total sales both in ETH and USD, along with transaction fees over time, segmented by sale date. By doing this, we can have a detailed overview of how revenue and transaction costs are trending over time, It helps in understanding how effectively the platform is generating revenue and the cost implications of transactions.

We want to calculate the total volume of all sales and the total revenue generated from creator commissions for Lockdown Lemmings, understanding how much revenue creators can receive from this project.

flipside

flipside

Team9-miniproject2-<Lockdown Lemmings> analysis