mariyaMagic Eden top 20 Whales
    Updated 2022-04-17
    WITH sales as (
    SELECT PURCHASER, SUM(SALES_AMOUNT) total_sales, COUNT(*) AS sale_count
    FROM solana.fact_nft_sales
    WHERE SUCCEEDED = 'TRUE'
    AND DATE(BLOCK_TIMESTAMP) >= '2022-03-01' and marketplace = 'magic eden v1' or marketplace = 'magic eden v2' and succeeded = 'TRUE'
    GROUP BY PURCHASER
    )
    SELECT top 20 *
    FROM sales
    where sale_count >= 50
    ORDER BY total_sales DESC
    Run a query to Download Data