m0rt3zaYaww & Solanart - popular NFT collections
    Updated 2022-09-27
    WITH sales AS (
    SELECT
    a.sales_amount,
    a.tx_id,
    b.project_name
    FROM solana.core.fact_nft_sales as a JOIN solana.core.dim_nft_metadata as b ON a.mint = b.contract_address
    WHERE marketplace IN ('yawww', 'solanart') AND block_timestamp > CURRENT_DATE - 90
    )
    SELECT project_name, count(DISTINCT tx_id), sum(sales_amount)
    FROM sales
    GROUP BY project_name

    Run a query to Download Data