MLDZMNOC4
Updated 2022-10-08
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
select
date_trunc('week',BLOCK_TIMESTAMP) as week,
count(tx_hash) as no_sale,
count(distinct BUYER_ADDRESS) as no_buyer,
sum(price_usd) as volume,
sum(CREATOR_FEE_USD) as Royalty_fee,
sum(PLATFORM_FEE_USD) as platform_fees,
avg(price_usd) as average_volume
from ethereum.core.ez_nft_sales
where PLATFORM_NAME='rarible'
group by 1
order by 1
Run a query to Download Data