select

min_month,

count(proposer) as new_users,

sum(new_users) over (order by min_month asc) as cumulative_total_users

from (

select

proposer,

date_trunc('month',min(block_timestamp)) as min_month

from flow.core.fact_transactions

group by proposer

)

group by min_month

),

active_users as (

select

date_trunc('month',block_timestamp) as monthly,

count(distinct proposer) as monthly_active_users

from flow.core.fact_transactions

group by monthly

),

active_users_comparison as (

select

min_month,

new_users,

monthly_active_users,

cumulative_total_users,

100* monthly_active_users / cumulative_total_users as percentage_of_total_wallet

from cumulative