flipside

    What Projects Fuel Adoption? 8
    jackguyWhat Projects Fuel Adoption? 8
    Updated 2023-06-13
    WITH tab1 as (
    SELECT
    token_name,
    COUNT(DISTINCT PURCHASER)
    FROM solana.core.fact_nft_sales
    LEFT outer JOIN solana.core.dim_nft_metadata
    ON solana.core.fact_nft_sales.mint = solana.core.dim_nft_metadata.mint
    WHERE not token_name is NULL
    GROUP BY 1
    ORDER BY 2 DESC
    LIMIT 30
    )

    SELECT
    date_trunc('week', block_timestamp) as day,
    CASE WHEN token_name in (SELECT token_name FROM tab1) then token_name ELSE 'Other' END as NFT,
    count(DISTINCT PURCHASER) as buyers,
    COUNT(DISTINCT tx_id) as buy_evetns
    FROM solana.core.fact_nft_sales
    LEFT outer JOIN solana.core.dim_nft_metadata
    ON solana.core.fact_nft_sales.mint = solana.core.dim_nft_metadata.mint
    GROUP BY 1,2
    Run a query to Download Data