flipside

    naughty-salmon
    Mrftinaughty-salmon
    Updated 2025-02-13
    WITH all_signers AS (
    SELECT DISTINCT
    s.value::string as signer
    FROM eclipse.core.fact_transactions,
    LATERAL FLATTEN(input => signers) s
    WHERE succeeded = TRUE
    )

    SELECT
    COUNT(*) as "Total Unique Users"
    FROM all_signers
    Last run: about 1 month ago
    Total Unique Users
    1
    		5548920
    1
    11B
    109s