MLDZMNgsrd7
Updated 2022-11-06
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
select
BLOCK_TIMESTAMP::date as day,
CASE
when CREATOR_FEE<>0 then 'With royalty'
else 'Without royalty'
end as gp,
count(tx_hash) as no_sale,
count(distinct BUYER_ADDRESS) as no_buyer,
sum(price_usd) as volume
from ethereum.core.ez_nft_sales
where BLOCK_TIMESTAMP>=CURRENT_DATE- {{Time_period}}
group by 1,2
Run a query to Download Data