MLDZMNsandsale1
Updated 2023-04-07
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
--0x5cc5b05a8a13e3fbdb0bb9fccd98d38e50f90c38
--sandbox's lands
select
distinct CURRENCY_SYMBOL,
count(distinct tx_hash) as sale_no,
count(distinct BUYER_ADDRESS) as buyer_no,
count(distinct SELLER_ADDRESS) as seller_no,
count(distinct TOKENID) as no_nfts,
sum(price_usd) as volume,
sum(CREATOR_FEE_USD) as Royalty_fee,
sum(PLATFORM_FEE_USD) as plat_fee,
avg(price_usd) as avg_volume,
--Royalty_fee/volume*100 as percentage_royalty_fee,
buyer_no/count(distinct date_trunc(day, block_timestamp)) as average_buyer_day,
volume/count(distinct date_trunc(day, block_timestamp)) as average_volume_day,
Royalty_fee/count(distinct date_trunc(day, block_timestamp)) as average_volume_day
from ethereum.core.ez_nft_sales
where NFT_ADDRESS='0x5cc5b05a8a13e3fbdb0bb9fccd98d38e50f90c38'
group by 1 having CURRENCY_SYMBOL is not null
Run a query to Download Data