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 >= CURRENT_DATE - interval '6 months'

group by 1

qualify row_number()over(order by date desc ) = 2