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'