MLDZMNbag9
Updated 2022-10-30
99
1
2
3
4
5
6
7
8
9
10
›
⌄
select
PROJECT_NAME as NFT,
count(TX_ID) as sale_no,
count(distinct PURCHASER) as buyer_no,
sum(SALES_AMOUNT) as volume
from solana.core.fact_nft_sales s left outer join solana.core.dim_nft_metadata b on s.mint=b.mint
where SUCCEEDED='TRUE'
and marketplace in ('hyperspace')
group by 1 having NFT is not null
order by 4 desc limit 10
Run a query to Download Data