0xHaM-dUntitled Query
    Updated 2022-11-22
    select
    date_trunc('{{Frequency}}',min_date)::date as date,
    count(buyer_address) as new_users,
    sum(new_users) over (order by date ) as total_new_users
    from (select buyer_address, min(block_timestamp) as min_date
    from ethereum.core.ez_nft_sales
    where nft_address = '0x629a673a8242c2ac4b7b8c5d8735fbeac21a6205'
    and price_usd > 0
    group by 1)
    group by 1
    order by 1 desc
    Run a query to Download Data