Pmisha-bmlMdxuniqe.users
    Updated 2022-06-03
    select
    date_trunc('day',BLOCK_TIMESTAMP) as dt,
    count(distinct TX_FROM) as active_user,
    sum(active_user) over (order by dt asc) as cum_active
    from osmosis.core.fact_transactions
    where tx_id is not NULL
    and TX_STATUS='SUCCEEDED'
    and BLOCK_TIMESTAMP>='2022-01-01'
    group by 1
    Run a query to Download Data