0-MIDTransfer Distribution By Users
    Updated 2024-08-15
    with tab1 as (
    select
    FROM_ADDRESS
    ,count(distinct TX_HASH) as transfers
    from near.core.ez_token_transfers
    where BLOCK_TIMESTAMP::date>='2024-01-01'
    and TRANSFER_TYPE='nep141'
    group by 1
    )
    select transfers
    ,count(distinct FROM_ADDRESS) as users
    from tab1
    group by 1
    order by 1


    QueryRunArchived: QueryRun has been archived