Afonso_DiazUntitled Query
Updated 2023-01-29
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
select
initcap(address_name) as nft_name,
count(distinct tx_id) as txns_count,
sum(sales_amount) as volume
from solana.core.fact_nft_sales a
join solana.core.dim_labels b
on a.mint = b.address
where succeeded = 1
and marketplace = 'exchange art'
and block_timestamp > current_date - 90
group by 1
order by 3 desc
limit 10
Run a query to Download Data