Sbhn_NPUFC_NFT stats
Updated 2022-10-20Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
with flowpricee as (
select TIMESTAMP::date as date, avg(price_usd) as flowprice
from flow.core.fact_prices
where symbol ='FLOW' and source ='coinmarketcap'
group by 1)
select count (distinct tx_id) as Sales_Count,
count (distinct nft_id) as Tokens_Count,
count (distinct buyer) as Buyers_Count,
count (distinct seller) as Sellers_Count,
count (distinct marketplace) as Markets_Count,
sum (case when currency ='A.ead892083b3e2c6c.FlowUtilityToken' then price*flowprice else price end) as Total_Sale_Volume,
avg (case when currency ='A.ead892083b3e2c6c.FlowUtilityToken' then price*flowprice else price end) as Average_Sale_Volume,
median (case when currency ='A.ead892083b3e2c6c.FlowUtilityToken' then price*flowprice else price end) as Median_Sale_Volume,
min (case when currency ='A.ead892083b3e2c6c.FlowUtilityToken' then price*flowprice else price end) as Min_Sale_Volume,
max (case when currency ='A.ead892083b3e2c6c.FlowUtilityToken' then price*flowprice else price end) as Maximum_Sale_Volume
from flow.core.ez_nft_sales t1 join flowpricee t2 on t1.block_timestamp::date = t2.date
where nft_collection = 'A.329feb3ab062d289.UFC_NFT'
and tx_succeeded = 'TRUE'
Run a query to Download Data