date ,

round ( 100*(transactions-lag(transactions,1)over(order by date))/lag(transactions,1)over(order by date),2) as "transactions change %",

round ( 100*(active_addresses-lag(active_addresses,1)over(order by date))/lag(active_addresses,1)over(order by date),2) as "active_addresses change %",

round ( 100*(txn_per_user-lag(txn_per_user,1)over(order by date))/lag(txn_per_user,1)over(order by date),2) as "txn_per_user change %",

round ( 100*(txn_per_day-lag(txn_per_day,1)over(order by date))/lag(txn_per_day,1)over(order by date),2) as "txn_per_day change %",

round ( 100*(users_per_day-lag(users_per_day,1)over(order by date))/lag(users_per_day,1)over(order by date),2) as "users_per_day change %"

from

(select

date_trunc('week', BLOCK_TIMESTAMP)::date AS date,

count(TX_id) AS transactions,

count(distinct TX_FROM) AS active_addresses ,

transactions / active_addresses as txn_per_user ,

transactions / count(distinct BLOCK_TIMESTAMP::date ) as txn_per_day,

active_addresses / count(distinct BLOCK_TIMESTAMP::date ) as users_per_day,

from axelar.core.fact_transactions

where TX_SUCCEEDED='TRUE'

and BLOCK_TIMESTAMP between CURRENT_DATE - interval '2 months' and current_date

group by 1

order by date desc limit 1