nnnnnnflow_nftmarket daily sale
Updated 2024-03-13
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
select trunc(block_timestamp,'day') as date,
marketplace,
-- count(colume_name) count all non-null value
-- distinct() filter the duplicate , show unqiue values
count(DISTINCT tx_id) as sale,
count(DISTINCT buyer) as buyer,
count(DISTINCT seller) as seller,
sum(price) as volume
FROM
flow.nft.ez_nft_sales
where nft_collection = 'A.329feb3ab062d289.UFC_NFT' and price >0
-- the range of now-3months
and block_timestamp > current_date - interval '3 months'
group by 1,2
order by 1 asc;