mmdrezatop 20 active users by the most count of transfer
    Updated 2022-10-17
    with tab as (
    select date_trunc ('week',block_timestamp) as date,
    sender as senders,
    count (distinct tx_id) as transfer_count
    from osmosis.core.fact_transfers
    where tx_status = 'SUCCEEDED'
    group by 1,2
    having transfer_count >= 20)

    select
    senders,
    sum(transfer_count) as count_transfer
    from tab
    group by senders order by count_transfer desc
    limit 20



    Run a query to Download Data