mmdrezatop20 active users
    Updated 2022-10-17
    with tab as (
    select date_trunc ('week',block_timestamp) as date,
    tx_from as Users,
    count (distinct tx_id) as transactions_count
    from osmosis.core.fact_transactions
    where tx_status = 'SUCCEEDED'
    group by 1,2
    having transactions_count >= 20)

    select
    users,
    sum(transactions_count) as tx_count
    from tab
    group by users order by tx_count desc
    limit 20


    Run a query to Download Data