drone-mostafaUntitled Query
Updated 2022-08-28
99
1
2
3
4
5
6
7
8
9
10
›
⌄
with Base as (select count(tx_hash) as TXN, count (DISTINCT seller_address) as sellers,
count (DISTINCT buyer_address) as Buyers, sum(price_usd) as Sale_USD, avg(price_usd) as AVG_Sale_USD
from ethereum.core.ez_nft_sales left outer join ethereum.core.dim_labels
on nft_address = address where label like 'cryptopunks' and price_usd is not null order by sale_usd DESC limit 10 )
select 'sellers' as type, sellers from Base UNION
select 'Buyers' as type, Buyers from Base
Run a query to Download Data