flipside

    New users / active users per day
    SocioCryptoNew users / active users per day
    Updated 2023-03-15
    SELECT a.date,
    a.new_address as N_UNIQUE_NEW_WALLET,
    b.address as N_UNIQUE_WALLET
    FROM
    (SELECT date_trunc('day', f_txn) as date,
    COUNT (DISTINCT from_address) as new_address
    FROM
    (
    SELECT from_address,
    min(block_timestamp) as f_txn
    FROM gnosis.core.fact_transactions
    WHERE status = 'SUCCESS'
    GROUP by from_address
    )
    GROUP by date) a
    LEFT JOIN (
    SELECT date_Trunc('day', block_timestamp) as date,
    count(DISTINCT from_address) as address
    FROM gnosis.core.fact_transactions
    WHERE status = 'SUCCESS'
    GROUP by date
    )b
    ON a.date = b.date
    ORDER BY a.date
    Run a query to Download Data