keshanNFTx Highest Sales Volume
Updated 2022-06-10
99
1
2
3
4
5
6
7
8
9
10
›
⌄
with top_3 as (select project_name, sum(price_usd) as vol
from ethereum.core.ez_nft_sales where block_timestamp::date >= CURRENT_DATE - 60 and platform_name='nftx'
group by project_name
order by vol desc limit 3)
select block_timestamp::date as date, count(seller_address) as num_sellers, count(buyer_address) as num_buyers,
project_name, sum(price_usd) as price_usd, avg(price_usd) as avg_price
from ethereum.core.ez_nft_sales
where block_timestamp::date >= CURRENT_DATE - 60 and platform_name='nftx' and project_name in (select project_name from top_3)
group by date, project_name
Run a query to Download Data