superflydefeated-chocolate
    Updated 2024-11-04
    SELECT
    date_trunc('day', s.BLOCK_TIMESTAMP) AS day,
    COUNT(DISTINCT s.ORIGIN_FROM_ADDRESS) AS active_users
    FROM
    ethereum.nft.ez_nft_sales AS s
    JOIN
    ethereum.nft.ez_nft_transfers AS t ON s.TX_HASH = t.TX_HASH
    WHERE
    t.PROJECT_NAME = 'Redacted Remilio Babies'
    GROUP BY
    day
    ORDER BY
    day DESC;

    QueryRunArchived: QueryRun has been archived