token_name,

count(distinct purchaser) as buyers,

sum(a.sales_amount) as price

from solana.core.fact_nft_sales a left join solana.core.dim_nft_metadata b on a.mint = b.mint

where marketplace like '%magic eden%'

and not token_name is null

and block_timestamp::date >= '2022-01-01'

group by 1

order by 3 desc

limit 5