MLDZMNMarketplace2
Updated 2023-09-01
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
select
date_trunc('hour',BLOCK_TIMESTAMP) as date,
PLATFORM_NAME as marketplace,
count(tx_hash) as sale_no,
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,
avg(avg_volume) OVER (partition by marketplace ORDER BY date ROWS BETWEEN 7 PRECEDING AND CURRENT ROW) as MA_7_Days,
sum(buyer_no) over (partition by marketplace order by date) as cum_buyers,
sum(sale_no) over (partition by marketplace order by date) as cum_sale,
sum(volume_usd) over (partition by marketplace order by date) as cum_volume
from ethereum.core.ez_nft_sales
where NFT_ADDRESS='0x790b2cf29ed4f310bf7641f013c65d4560d28371'
group by 1 ,2
Run a query to Download Data