Eman-RazDistribution of Users By Staking Count
    Updated 2025-03-05
    with tab1 as (select origin_from_address, count(distinct tx_hash), case
    when count(distinct tx_hash)=1 then 'n=1 Txn'
    when count(distinct tx_hash)=2 then 'n=2 Txn'
    when count(distinct tx_hash)>=3 and count(distinct tx_hash)<=10 then '3-10 Txns'
    when count(distinct tx_hash)>=11 and count(distinct tx_hash)<=50 then '11-50 Txns'
    when count(distinct tx_hash)>=51 and count(distinct tx_hash)<=100 then '51-100 Txns'
    when count(distinct tx_hash)>100 then '>100 Txns'
    end as "Staking Txns Count"
    from monad.testnet.fact_traces
    where from_address=origin_from_address
    and to_address='0x2c9c959516e9aaedb2c748224a41249202ca8be7'
    and origin_to_address=to_address and origin_function_signature='0xd5575982'
    and type='CALL' and trace_address='ORIGIN' and trace_succeeded='TRUE' and block_timestamp::date>='2025-02-18'
    group by 1)

    select "Staking Txns Count", count(distinct origin_from_address) as "Number of Stakers"
    from tab1
    group by 1
    Last run: 14 days ago
    Staking Txns Count
    Number of Stakers
    1
    n=1 Txn445601
    2
    n=2 Txn77316
    3
    >100 Txns2406
    4
    3-10 Txns98634
    5
    11-50 Txns15894
    6
    51-100 Txns1690
    6
    119B
    12s