farid-c9j0VMTop 10 wallets purchasing DeGods
    Updated 2023-03-27
    WITH secondary_sale AS (
    SELECT block_timestamp::date as date, tx_id, n.mint, purchaser, SALES_AMOUNT, project_name
    FROM solana.fact_nft_sales n LEFT OUTER JOIN solana.dim_nft_metadata m ON n.mint = m.mint
    WHERE SUCCEEDED = 'TRUE' and project_name = 'DeGods'
    )

    SELECT purchaser, COUNT(DISTINCT mint) as num_mints
    FROM secondary_sale
    GROUP BY 1
    ORDER BY 2 DESC
    LIMIT 10

    Run a query to Download Data