LABEL_TYPE,

ORIGIN_FROM_ADDRESS as user,

ROW_NUMBER() OVER (PARTITION BY ORIGIN_FROM_ADDRESS ORDER BY block_timestamp ASC) as step

FROM avalanche.core.fact_event_logs

JOIN avalanche.core.dim_labels on CONTRACT_ADDRESS = ADDRESS

WHERE LABEL_TYPE not in ('cex','token','operator')

AND BLOCK_TIMESTAMP::date > '2024-12-16 17:00:00.000'

QUALIFY step <= 10

SELECT

LABEL_TYPE as sector,

step,

COUNT(DISTINCT user) as n_users

FROM first10_steps

GROUP BY 1, 2

ORDER BY 2