nnnnnnflow_nftmarket daily sale
    Updated 2024-03-13
    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;