saadiq2023-06-12 02:08 PM
    Updated 2023-06-12
    WITH numbers AS (
    SELECT
    SEQ4() AS num
    FROM
    TABLE (GENERATOR(ROWCOUNT => 1000)) -- Assuming less than 1000 days
    ),
    dates AS (
    SELECT
    DATEADD(DAY, num, '2023-03-01') AS date
    FROM
    numbers
    WHERE
    DATEADD(DAY, num, '2023-03-01') BETWEEN '2023-03-26' AND CURRENT_DATE
    ),
    DELTAS AS (
    SELECT
    *
    FROM
    ethereum.core.ez_balance_deltas
    WHERE
    user_address IN (
    SELECT
    DISTINCT user_address
    FROM
    ethereum.core.ez_balance_deltas
    WHERE
    contract_address IN ('0x23581767a106ae21c074b2276d25e5c3e136a68b')
    )
    AND (
    contract_address IN ('0x23581767a106ae21c074b2276d25e5c3e136a68b')
    /* proof contracts: MB */
    )
    )
    SELECT
    d.date,
    count(distinct subquery.user_address) as user_count
    Run a query to Download Data