MLDZMNMessi5
Updated 2022-12-23
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
select
PLATFORM_NAME as marketplace,
min(BLOCK_TIMESTAMP),
count(tx_hash) as no_sale,
count(distinct BUYER_ADDRESS) as buyer_no,
sum(price) as volume_ETH,
sum(price_usd) as volume_USD,
sum(CREATOR_FEE_USD) as Royalty_fee,
sum(PLATFORM_FEE_USD) as plat_fee,
avg(price_usd) as avg_volume
from ethereum.core.ez_nft_sales
where NFT_ADDRESS in (lower('0x3b6AfB8bdA297309738167B1711b69484c7c7eCA'), '0x3df25f701c97f8f95590c8dd7b0ce34d61e3b590')
group by 1
Run a query to Download Data