mmdrezaNumber of Weekly active users that made 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 count (distinct senders) as active_senders
    from tab



    Run a query to Download Data