Afonso_DiazTop projects users interacted with
    Updated 2025-02-24
    WITH main AS (
    SELECT
    tx_hash,
    block_timestamp,
    origin_from_address AS user,
    origin_to_address as contract_address,
    label_type,
    label_subtype,
    project_name
    FROM kaia.core.fact_event_logs
    left join
    kaia.core.dim_labels on address = origin_to_address
    where
    label_subtype not in ('token_contract')
    and label_type != 'token'
    )

    select
    contract_address,
    project_name,
    count(distinct tx_hash) as transactions,
    count(distinct user) as users
    from
    main
    group by 1, 2
    order by 3 desc
    limit 10
    QueryRunArchived: QueryRun has been archived