from flow.core.fact_events

where EVENT_CONTRACT ilike '%Dimension%'

group by 1

),

daily as (

select date_trunc(day,block_timestamp)::date daily,

count (DISTINCT proposer) active_users ,

count (tx_id) transactions

from flow.core.fact_transactions

where tx_id in (select tx_id from events )

and TX_SUCCEEDED = true

group by 1 order by 1

)

select

round( avg(active_users) ) average_active_users ,

min (active_users) min_active_users ,

max (active_users) max_active_users ,

median (active_users) median_active_users ,

round( avg(transactions) ) average_transactions ,

min (transactions) min_transactions ,

max (transactions) max_transactions ,

median (transactions) median_transactions

from daily