vendettaComparison of unique users and fee volume
    Updated 2024-08-02
    select
    BLOCK_TIMESTAMP::date as day,
    SUM(TX_FEE_PRECISE) as Fee_Volume,
    COUNT(DISTINCT FROM_ADDRESS) as Unique_users,

    from base.core.fact_transactions


    WHERE STATUS ='SUCCESS'

    GROUP BY 1


    QueryRunArchived: QueryRun has been archived