mariyaSellers Breakdown based on total transactions
Updated 2022-11-11
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
›
⌄
with top_10 as ( select nft_address , sum(price_usd) as volume
from ethereum.core.ez_nft_sales
where price_usd is not null and block_timestamp::date >= CURRENT_DATE - 180
group by 1
order by 2 desc
limit 10)
,
final as ( select seller_address,project_name, count(DISTINCT(tx_hash)) as total_sales, count(DISTINCT(buyer_address)) total_buyer,
count(DISTINCT(seller_address)) as total_seller, sum(price_usd) as total_volume, avg(price_usd) as avg_price,
count(DISTINCT(tokenid)) as total_nfts
from ethereum.core.ez_nft_sales a join ethereum.core.dim_labels b on a.nft_address = b.address
where nft_address in ( select nft_address from top_10)
and block_timestamp::date >= CURRENT_DATE - 180
group by 1,2)
select project_name , count(DISTINCT(seller_address)) as seller,
case when total_nfts = 1 then '1 NFT'
when total_nfts = 2 then '2 NFTs'
when total_nfts = 3 then '3 NFTs'
when total_nfts = 4 then '4 NFTs'
when total_nfts >= 5 then '=+ 5 NFTs' end as type
from final
where project_name is not null
group by 1,3
Run a query to Download Data