MLDZMNrace3
Updated 2022-10-23Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
select--flow nft
date_trunc('week',block_timestamp) as week,
count(distinct SELLER) as sellers,
count(distinct buyer) as buyer_no,
sum(price) as volume_sale,
count(tx_id) as sale_no,
avg(price) as average_sale_price
from flow.core.fact_nft_sales
where TX_SUCCEEDED='TRUE' and CURRENCY='A.ead892083b3e2c6c.DapperUtilityCoin'
and NFT_COLLECTION='A.329feb3ab062d289.RaceDay_NFT'
group by 1
order by 1
Run a query to Download Data