MLDZMNbag9
    Updated 2022-10-30
    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