SELECT

logs.block_timestamp::date AS date,

labels.label_type AS type,

COUNT(DISTINCT ORIGIN_FROM_ADDRESS) as users,

COUNT(DISTINCT(logs.tx_hash)) AS number_of_transactions

FROM

arbitrum.core.fact_event_logs logs

JOIN

arbitrum.core.dim_labels labels

ON

logs.contract_address = labels.address

WHERE

labels.label_type IS NOT NULL

GROUP BY date, type