METHODOLOGY:

1. Aggregated Metrics by Platform First, I aimed to get a snapshot of the performance of different NFT platforms starting from January 1, 2024. To achieve this, I aggregated key metrics for each platform. I categorized platforms based on their names—standardizing them into groups like 'Opensea', 'Blur', and others. I then calculated metrics such as total sales, unique buyers, unique sellers, total sales in USD, and various fee-related metrics. The resulting summary provided a clear view of how each platform performed in terms of sales volume, average sale prices, and total fees.

2. Aggregated Metrics Across All Platforms Next, I consolidated the metrics across all platforms to understand the overall performance without focusing on individual platforms. Using the results from the first step, I aggregated metrics to compute cumulative totals and averages. This included calculating the total number of sales, unique buyers, and sellers, as well as the total and average sales volume. Additionally, I assessed the minimum and maximum sale prices and provided a breakdown of total fees. The output was a comprehensive view summarizing the performance across all platforms collectively.

3. Daily Cumulative Metrics by Platform For a more detailed analysis, I examined how the metrics evolved over time. I calculated daily metrics for each platform, including sales volume, number of buyers and sellers, and fees. By applying window functions, I computed cumulative values for each day, partitioned by platform. This approach allowed me to track the performance of each platform as it accumulated over time. The final output included daily metrics along with cumulative totals, providing insights into how each platform's performance changed over the analyzed period.

Visualizations Aggregated Metrics by Platform:

Bar Chart: I used bar charts to compare total sales, unique buyers, and other key metrics across different platforms. Pie Chart: A pie chart helped visualize the distribution of fees among platforms. Aggregated Metrics Across All Platforms:

Pie Chart: A pie chart illustrated the share of total sales or fees attributed to each platform. KPI Dashboard: I created a KPI dashboard to display cumulative metrics in a consolidated view. Daily Cumulative Metrics by Platform:

Line Chart: I employed line charts to visualize trends over time for metrics like sales volume and the number of buyers. Area Chart: Area charts showed the cumulative growth of sales and fees by platform over time.

By using these approaches, I aimed to provide both a high-level snapshot of overall performance and detailed insights into trends and cumulative growth. This methodology ensures a comprehensive understanding of NFT sales dynamics, benefiting stakeholders by offering both aggregated and time-based perspectives.

My Flipside URL: https://flipsidecrypto.xyz/m3ji/dashboards

X: @0xm3ji

Discord: meji_

Email: defimeji@gmail.com

We greatly appreciate your support! If you found this dashboard valuable, kindly share it with your network and express your appreciation by clicking the 💖 in the top right corner. Your feedback and recommendations are precious to me. Thank you! 🙏

In the rapidly growing world of NFTs, understanding which platforms are driving market trends is key. This analysis delves into Ethereum’s NFT sales data from 2024 onward to uncover how platforms like OpenSea, Blur, and Rarible are performing in this competitive landscape. By aggregating key metrics such as total sales, unique buyers, and fees, we gain a clear view of each platform's strengths. Moving beyond a static snapshot, we explore how daily cumulative trends unfold, revealing the momentum behind each marketplace.

This analysis isn't just about numbers; it’s about understanding the story behind them. By breaking down the data, we see who’s leading the charge, where the money flows, and how users engage across different NFT platforms. Whether you're a trader, an analyst, or a digital art enthusiast, these insights offer a compelling look at the forces shaping the NFT market on Ethereum today. Let’s unravel the digital tapestry of NFTs and see which platforms are set to shape tomorrow’s blockchain frontier.