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

) ,

Genopets as (

SELECT

COUNT(DISTINCT signers[0] ) users,

count (DISTINCT TX_ID ) num_transactions

FROM solana.core.fact_events

where program_id='StaKe9nb7aUjXpjpZ45o6uJBsZxj2BWCDBtjk8LCg2v'

and SUCCEEDED = true

),

Genopets_daily as (

SELECT BLOCK_TIMESTAMP::date daily ,

COUNT(DISTINCT signers[0] ) active_users,

count (DISTINCT TX_ID ) num_transactions ,

sum (num_transactions) over (order by daily) cum_transactions

FROM solana.core.fact_events

where program_id='StaKe9nb7aUjXpjpZ45o6uJBsZxj2BWCDBtjk8LCg2v'

and SUCCEEDED = true

group by 1 order by 1

select 'Dimension X' platform ,

round( avg(active_users) ) average_active_users ,

min (active_users) min_active_users ,