nitsNew Buyers ens
    Updated 2022-12-10
    SELECT date(first_use) as day, count(DISTINCT buyer_address) as total_buyers,
    sum(total_buyers) over (order by day) as cum_buyers
    from
    (SELECT buyer_address, min(block_timestamp) as first_use
    from
    ethereum.core.ez_nft_sales
    where (nft_address ilike '0x57f1887a8bf19b14fc0df6fd9b2acc9af147ea85')
    GROUP by 1)
    where date(first_use) >= CURRENT_DATE - {{n}}
    GROUP by 1
    -- LIMIT 100
    Run a query to Download Data