Abbas_ra21Gnosisi pt2: stats over Time : transcations and users
    Updated 2022-10-16
    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