tomilayoright-lavender
    Updated 2024-09-29
    SELECT
    COUNT(DISTINCT user_address) AS Total_Active_Users
    FROM (
    SELECT
    FROM_ADDRESS AS user_address
    FROM
    kaia.core.fact_transactions;
    WHERE
    BLOCK_TIMESTAMP >= DATEADD(DAY, -90, CURRENT_DATE)
    AND TX_SUCCEEDED = TRUE
    UNION

    SELECT
    TO_ADDRESS AS user_address
    FROM
    kaia.core.fact_transactions
    WHERE
    BLOCK_TIMESTAMP >= DATEADD(DAY, -90, CURRENT_DATE)
    AND TX_SUCCEEDED = TRUE
    ) AS active_users;

    QueryRunArchived: QueryRun has been archived