alirsop-06-16dao
Updated 2022-12-24
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
select DATE_TRUNC('Day',BLOCK_TIMESTAMP) as Date, PLATFORM_NAME--,nvl(PROJECT_NAME,NFT_ADDRESS)as PROJECT_NAME,NFT_ADDRESS,EVENT_TYPE,
,sum(CREATOR_FEE_USD) as Royalty,sum(PRICE_USD ) as Volume, --,royalty / PRICE * 100 as Royality_Percent
row_number() over (order by royalty DESC) as Rank,
count(distinct buyer_address) as unique_Buyer_count,
count(distinct tx_hash) as sales_count,
count (distinct seller_address) as unique_Seller_count
from ethereum.core.ez_nft_sales
where PLATFORM_NAME in ('opensea','looksrare','rarible','x2y2','blur') and date(BLOCK_TIMESTAMP)>='2022-10-19' and
date(BLOCK_TIMESTAMP)<CURRENT_DATE
group by 1,2
order by date
Run a query to Download Data