mrnnptrcParallel Avatars - Sales - Unique Buyer and Seller Count
    Updated 2024-07-08
    select
    block_timestamp :: date as sale_date,
    count(distinct seller_address) as unique_seller_count,
    count(distinct buyer_address) as unique_buyer_count
    from
    ethereum.nft.ez_nft_sales
    where
    nft_address = '0x0fc3dd8c37880a297166bed57759974a157f0e74'
    and block_timestamp :: date >= dateadd('day', - {{n_days}}, current_date)
    and block_timestamp :: date < current_date
    and price_usd > 0
    group by
    1
    order by
    1 desc


    QueryRunArchived: QueryRun has been archived