hessTop Project Types
    Updated 2023-07-08
    with new as ( select min(block_timestamp) as date, from_address, label_type
    from arbitrum.core.fact_token_transfers a join arbitrum.core.dim_labels b on a.to_address = address
    group by 2,3)
    ,
    final as ( select trunc(date,'month') as month , label_type, count(DISTINCT(from_address)) as user,
    sum(user) over (partition by label_type order by month asc) as cum_user
    from new
    group by 1,2
    having user > 50 )

    select label_type, sum(user) as new_users
    from final
    where month >= '2023-01-01'
    group by 1
    order by 2 desc
    limit 12




    Run a query to Download Data