DATE_TRUNC('day', BLOCK_TIMESTAMP) AS DATE,

LABEL_TYPE,

COUNT(DISTINCT ORIGIN_FROM_ADDRESS) AS USERS

FROM kaia.core.fact_event_logs a

JOIN kaia.core.dim_labels b

ON a.CONTRACT_ADDRESS = b.address

WHERE TX_SUCCEEDED = 'TRUE'

AND label_type != 'token'

AND label_type is not null

AND block_timestamp::Date >= '2024-01-01'

GROUP BY 1, 2