MLDZMNartg1
Updated 2023-04-13
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
select
count(tx_hash) as no_sale,
count(distinct BUYER_ADDRESS) as buyer_no,
sum(price) as ETH_value,
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 price_usd is not NULL
and CREATOR_FEE_USD is not null
and NFT_ADDRESS=lower('0x60bb1e2AA1c9ACAfB4d34F71585D7e959f387769')
Run a query to Download Data