select
date_trunc('{{Timeframe}}',BLOCK_TIMESTAMP) AS date,
count(distinct TX_HASH) AS "transactions number",
count(distinct FROM_ADDRESS) "unique active users number",
sum(TX_FEE) AS "Fee Amount"
from gnosis.core.fact_transactions where STATUS='SUCCESS'
group by 1