hessShare of Transactions by New Users (30D)
    Updated 2025-05-29
    with new as ( select min(block_timestamp) as date,
    from_address
    from avalanche.core.fact_transactions
    group by 2
    )
    ,
    new_address as ( select DISTINCT from_address
    from new
    where date >= current_date - 30)
    ,
    final as (select count(DISTINCT(tx_hash)) as tx,
    from_address
    from avalanche.core.fact_transactions
    where from_address not in (select address from avalanche.core.dim_labels)
    and from_address in (select from_address from new_address)
    and block_timestamp::date >= current_date - 30
    group by 2)

    select tx,
    count(DISTINCT(from_address)) as users
    from final
    group by 1



    Last run: 3 months ago
    TX
    USERS
    1
    50022
    2
    9212
    3
    5671
    4
    16771
    5
    8492
    6
    1219
    7
    1185
    8
    3582
    9
    1544
    10
    20071
    11
    2631
    12
    2411
    13
    17311
    14
    43161
    15
    2932
    16
    4012
    17
    53261
    18
    5631
    19
    8591
    20
    10084
    ...
    687
    6KB
    35s