farid-c9j0VMUntitled Query
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
select project_name,
count (distinct tx_hash) as Sales
--sum (price_usd) as Total_Sales_Volume,
--sum (creator_fee_usd) as Total_Royalty_Fee,
from ethereum.core.ez_nft_sales
where platform_name = 'opensea'
and creator_fee_usd > 0 and project_name is not null and project_name != 'opensea'
and BLOCK_TIMESTAMP >= '2022-10-20'
group by 1
order by 2 desc
limit 10
Run a query to Download Data