MLDZMNTop purchasers in the selected period
    Updated 2023-10-23
    select
    buyer_address as "Buyer",
    count(distinct tx_hash) as "Count of purchase",
    Count(distinct project_name) as "Purchased collections",
    round(sum(price_usd),2) as "Total purchase volume (USD)",
    round(avg(price_usd),2) as "Average purchase price (USD)",
    round(sum(TOTAL_FEES_USD),2) as "Total paid fee (USD)",
    round("Total paid fee (USD)"/"Total purchase volume (USD)"*100,2) as "Share of paid fee (%)"


    from avalanche.core.ez_nft_sales
    group by 1
    order by 4 DESC
    limit 100
    Run a query to Download Data