flipside

    harsh-apricot
    Mrftiharsh-apricot
    Updated 2025-07-31
    SELECT
    COUNT(DISTINCT REGEXP_SUBSTR(fee_msg['transition']['outputs'][0]['value'], 'aleo[\\w]+')) AS "Total unique users"
    FROM aleo.core.fact_transactions
    WHERE tx_succeeded = TRUE;

    Last run: about 2 months ago
    Total unique users
    1
    		1874697
    1
    11B
    23s