Afonso_DiazTop projects users interacted with
    Updated 2025-05-10
    with

    main as (
    select
    tx_hash,
    block_timestamp,
    from_address as user,
    to_address as contract_address,
    label as project_name,
    label_type,
    tx_fee
    from
    ink.core.fact_transactions
    left join
    ink.core.dim_labels on address = to_address
    where
    tx_succeeded
    and label_subtype not in ('token_contract')
    and label_type != 'token'
    )

    select
    project_name,
    count(distinct tx_hash) as transactions,
    count(distinct user) as users
    from
    main
    group by 1
    order by 2 desc
    limit 10


    Last run: 18 days ago
    PROJECT_NAME
    TRANSACTIONS
    USERS
    1
    layer3 cube62567143207
    2
    slipstream position nft v1.216396716474
    3
    uniswap v3 positions nft-v110737240395
    4
    hanft5822020754
    5
    zns connect4398242026
    6
    nfts2me owners3023024078
    7
    0x1df2...50c1456c87c71edf9fb199d52411521808
    8
    guild pin2066520661
    9
    bronze supporter pin77386616
    10
    0x900b...7dfbd01f26fe6f90a9faaa19e67976755
    10
    362B
    2s