flipside

    Number of traders that bought same NFT more than once
    OneDataAnalystNumber of traders that bought same NFT more than once
    Updated 2022-10-21
    WITH t1 AS(
    SELECT PURCHASER AS trader, MINT AS NFT, Count(*) AS sell_counts
    FROM solana.core.fact_nft_sales
    WHERE MINT IS NOT NULL
    GROUP By 1,2
    HAVING sell_counts > 1
    )

    SELECT COUNT(DISTINCT Trader)
    FROM t1
    Run a query to Download Data