2844showing unique Taiyo Robotics buyers over time on Magic Eden
    Updated 2022-04-02
    SELECT fact_nft_sales.purchaser as buyer , COUNT(fact_nft_sales.sales_amount) AS N_NFTs, MIN(fact_nft_sales.block_timestamp) AS BUY_DATE
    from solana.fact_nft_sales INNER JOIN solana.dim_nft_metadata
    WHERE fact_nft_sales.mint = dim_nft_metadata.mint
    AND fact_nft_sales.program_id = 'M2mx93ekt1fmXSVkTrUL9xVFHkmME8HTUi5Cyc5aF7K'
    AND fact_nft_sales.succeeded = 'true'
    AND fact_nft_sales.block_timestamp >= '2022-03-12'
    AND dim_nft_metadata.contract_name = 'Taiyo Robotics'
    GROUP BY purchaser
    order by buy_date desc

    Run a query to Download Data