MahrooUntitled Query
Updated 2022-10-29
99
1
2
3
4
5
6
7
8
9
10
›
⌄
select initcap(coalesce(address_name,project_name,null)) as Collection,
count (distinct tx_id) as Sales_Count,
count (distinct purchaser) as Purchasers_Count,
sum (sales_amount) as Sales_Volume
from solana.core.fact_nft_sales t1 full outer join solana.core.dim_nft_metadata t2 on t1.mint = t2.mint
full outer join solana.core.dim_labels t3 on t1.mint = t3.address
where marketplace = 'hyperspace' and collection is not null
group by 1
order by 4 DESC
limit 10
Run a query to Download Data