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

),

events as (

select TX_ID

from flow.core.fact_events

where EVENT_CONTRACT ilike '%Dimension%'

group by 1

),

DimensionX_daily as (

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

count (DISTINCT proposer) active_users ,

count (tx_id) num_transactions ,

sum (num_transactions) over (order by daily) cum_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 'Genopets' platform , avg(active_users) average_users_per_day,