Team13_miniproject2_Hashmask_analysis

    Hashmasks are ancient traits and memories of the first travelers to Earth. Their journey here was long and hard. The "Hashmasks" NFT Market Analysis Dashboard is a sophisticated analytical tool designed to provide deep insights into the dynamics of the Hashmasks NFT market. This dashboard utilizes detailed SQL queries to extract and visualize data from the Ethereum blockchain, focusing on sales, transaction trends, participant behavior, and fee distributions across various platforms. The goal is to equip stakeholders—including collectors, investors, and analysts—with robust data to make informed decisions regarding their involvement in the Hashmasks ecosystem. Objectives Trend Analysis: Understand how sales trends, both weekly and monthly, have evolved over time to predict future market movements. Market Participation: Gauge buyer and seller activity to identify market liquidity, engagement levels, and potential saturation points. Financial Insights: Analyze the distribution of fees among platforms, creators, and transactions to evaluate the cost-effectiveness and profitability of transactions within the Hashmasks market. Visual Presentation: Leverage graphical representations to simplify the understanding of complex data and highlight key trends and anomalies that may require further investigation.

    Loading...
    Loading...

    This query aims to provide a comprehensive overview of weekly market activity for Hashmasks NFTs. It tracks the total sales amount, the number of transactions, the count of unique tokens sold, and the participant counts (both buyers and sellers). The purpose is to identify weekly trends in sales volumes and participant engagement, which can help in understanding market dynamics such as liquidity, buying enthusiasm, and selling pressures.

    Insights

    The data shows extreme variability in sales, with values ranging from nearly zero to over $695,000, which indicates inconsistent sales performance.

    A strong correlation exists between the number of transactions and buyers, but these factors do not strongly correlate with the total sales amount, suggesting more transactions or buyers don’t always result in higher sales.

    Loading...

    The focus of this query is on monitoring the average transaction prices and the total number of transactions per month. This analysis is crucial for spotting pricing trends and understanding how transaction volumes fluctuate over time. It helps stakeholders gauge market responsiveness to external influences and internal dynamics, aiding in long-term strategy development.

    Insights

    February 2021 saw a surge in NFT prices with the average price reaching approximately $30,656, alongside a high sales volume.

    In March 2021, the sales volume remained high, but the average NFT price reduced significantly to around $4,710, indicating a market correction after February's peak.

    Weekly Sales and Participant Analysis
    Monthly Sales Performance
    Loading...
    Loading...
    Platform Fee Analysis

    This query analyzes the average fees associated with different platforms (platform fee, creator fee, transaction fee) where Hashmasks are sold. Understanding the fee structure is vital for both buyers and sellers as it impacts the total cost of transactions and the net revenue from sales. The analysis can influence decisions on which platforms might be more financially advantageous for different stakeholders.

    Insights

    'Blur' has an unusually high average transaction fee compared to its other fees, indicating expensive transaction costs for its users.

    'Rarible' charges a very high platform fee with no fees going to creators, suggesting a business model that favors platform revenue over creator earnings.

    db_img
    db_img
    db_img
    Loading...
    Loading...
    Price Distribution in Recent Sales
    Loading...

    This query segments the sales of Hashmasks NFTs into distinct price categories within a recent time frame (e.g., the last 90 days). The purpose is to analyze the distribution of transaction values, which helps in identifying the most common pricing tiers in which NFTs are being bought and sold. This insight can guide both buyers and sellers on price positioning and market expectations, and also indicate the presence of premium versus standard pricing trends

    Insights

    The highest sales in a single week were around $695,011.69 with only 22 transactions, indicating a few high-value sales.

    A strong correlation (0.96) exists between the number of transactions and buyers, suggesting more buyers generally lead to more transactions.

    Mint and Sales Join Analysis
    db_img

    This query segments the sales of Hashmasks NFTs into distinct price categories within a recent time frame (e.g., the last 90 days). The purpose is to analyze the distribution of transaction values, which helps in identifying the most common pricing tiers in which NFTs are being bought and sold. This insight can guide both buyers and sellers on price positioning and market expectations, and also indicate the presence of premium versus standard pricing trends.

    Insights

    Platform Dominance: Opensea dominates the NFT market with 247,294 transactions, significantly more than other platforms, indicating its popularity among users.

    Consistent Mint Prices: Average mint prices for NFTs are similar across platforms, ranging from $755 to $858, suggesting a uniform market valuation of NFTs at the minting stage across different trading platforms.

    Loading...