flipside

    Solana - Solana NFT Project Feature: Primates Mint
    piperSolana - Solana NFT Project Feature: Primates Mint
    Updated 2022-07-17
    /*
    Twitter: @der_piper
    Discrod: piper#6707

    Solana - Solana NFT Project Feature

    Choose a NFT project from the following list and create a dashboard with the new
    Flipside dashboard layout that can refresh once a day highlighting at least 4 metrics
    of your choosing that helps show the "health" of the project. Note any noticeable
    trends or current events for the project. Highlight how liquidity is flowing in and
    out of the project and what types of buyers and sellers are interacting with the project.
    */


    WITH all_mints AS (
    SELECT
    DISTINCT(mint) AS mint
    FROM
    solana.core.dim_nft_metadata
    WHERE
    contract_name = 'Primates'
    )

    SELECT
    DATE_TRUNC('hour', block_timestamp) AS hour,
    COUNT(DISTINCT(tx_id)) AS number_of_mints,
    COUNT(DISTINCT(purchaser)) AS unique_minter,
    AVG(mint_price) AS average_mint_price
    FROM
    solana.core.fact_nft_mints
    WHERE
    mint in (SELECT mint FROM all_mints)
    GROUP BY hour
    ORDER BY hour ASC

    /* The End! */
    Run a query to Download Data