block_timestamp::date as date,

EVENT_NAME,

ADDRESS_NAME,

count(distinct origin_from_address) as Users_Count,

count(distinct tx_hash) as tx_cnt,

sum(tx_cnt) over (partition by EVENT_NAME order by date) as cum_tx_cnt

from gnosis.core.fact_event_logs a join gnosis.core.dim_labels b on a.CONTRACT_ADDRESS= b.address

where block_timestamp >= '2022-05-17'

and EVENT_NAME != 'Approval'

group by 1,2,3