Top labels users interacted with

Afonso_DiazTop labels users interacted with

Updated 2025-05-15

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

label_type,

count(distinct tx_hash) as transactions,

count(distinct user) as users

from

main

group by 1

order by 2 desc

Last run: 10 days ago

193B

306s

flipside