*

from

union all

select * from $query('82253da0-ced9-4298-8abb-ef7714d049c4')

union all

date_trunc('month',block_timestamp) as month,

count (DISTINCT signers[0]) as users

from solana.core.fact_events

where block_timestamp::date >= '2024-10-01'

--and block_timestamp::date<= '2024-09-30'

group by 1

select substr(month,0,10) as date, users as active_users,

lag(active_users,1) over (order by date asc) as lag,

active_users-lag as change,

round(( change / lag ) * 100 , 2 ) as x,

cast(x as decimal(18,2)) as Change_percentage from f order by date asc