piperBase - NFT sales users
    Updated 2023-08-26
    SELECT
    TO_CHAR(BLOCK_TIMESTAMP, 'YYYY-MM-DD') AS "Date",
    COUNT(DISTINCT(seller_address)) AS "Number of Sellers",
    COUNT(DISTINCT(buyer_address)) AS "Number of Buyers",
    SUM("Number of Sellers") OVER (ORDER BY "Date") AS "Cumulative Number of Sellers",
    SUM("Number of Buyers") OVER (ORDER BY "Date") AS "Cumulative Number of Buyers"
    FROM
    base.nft.ez_nft_sales
    WHERE
    "Date" >= '2023-08-03' -- opensea starts on base
    GROUP BY 1
    ORDER BY 1 DESC