date_trunc('day',block_timestamp) as date,

event_name,

label_subtype,

count(distinct origin_from_address) as count_users,

count(distinct tx_hash) as transactions

from gnosis.core.fact_event_logs e

join gnosis.core.dim_labels l on e.CONTRACT_ADDRESS= l.address

where block_timestamp >= current_date - 30

and EVENT_NAME != 'Approval'

group by 1,2,3