shreexTotal Metrics Magic Eden
    Updated 2022-09-28
    select
    count(distinct purchaser) as distinct_buyers,
    count(distinct seller) as distinct_sellers,
    count(distinct contract_name) as unique_nft_collections,
    count(*) as sales
    from solana.core.fact_nft_sales sales left join solana.core.dim_nft_metadata meta on meta.mint=sales.mint
    where marketplace in ('magic eden v1','magic eden v2') and block_timestamp >= '2022-07-01'
    Run a query to Download Data