flipside

    New users / active user per day
    SocioCryptoNew users / active user per day
    Updated 2024-01-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 tx_sender) as new_address
    FROM
    (
    SELECT tx_sender,
    min(block_timestamp) as f_txn
    FROM terra.core.fact_transactions
    WHERE tx_succeeded = 'TRUE'
    GROUP by tx_sender
    )
    GROUP by date) a
    LEFT JOIN (
    SELECT date_Trunc('day', block_timestamp) as date,
    count(DISTINCT tx_sender) as address
    FROM terra.core.fact_transactions
    WHERE tx_succeeded = 'TRUE'
    GROUP by date
    )b
    ON a.date = b.date
    WHERE a.date < current_date
    ORDER BY a.date DESC

    QueryRunArchived: QueryRun has been archived