pouya_22Unique Users - Cumulative unique users number
    Updated 2022-06-07
    with unique_users as (select block_timestamp::date as date, count(distinct tx_from) as number_of_unique_users
    from osmosis.core.fact_transactions
    where tx_status = 'SUCCEEDED'
    group by date)

    select date, sum(number_of_unique_users) over(order by date) as cumulative_unique_users
    from unique_users
    Run a query to Download Data