select
date_trunc('week', BLOCK_TIMESTAMP) :: date AS date,
--monthname(BLOCK_TIMESTAMP) AS Month,
count(TX_id) AS "transactions ",
count(distinct TX_FROM) AS "active addresses"
from
axelar.core.fact_transactions
where
TX_SUCCEEDED = 'TRUE'
and BLOCK_TIMESTAMP >= '2024-01-01'
group by
1