from flow.core.fact_events

where EVENT_CONTRACT ilike '%Dimension%'

group by 1

select date_trunc(month,block_timestamp)::date monthly,

count (DISTINCT proposer) active_users ,

count (DISTINCT tx_id) num_transactions ,

sum (num_transactions) over (order by monthly ) transactions_growth

from flow.core.fact_transactions

where tx_id in (select tx_id from events )

and TX_SUCCEEDED = true

group by 1 order by 1