DATE_TRUNC('{{Granularity}}', BLOCK_TIMESTAMP) AS Date,

COUNT(DISTINCT TX_HASH) AS TRANSACTIONS,

SUM(TRANSACTIONS) OVER (ORDER BY DATE) AS CUMULATIVE_TXNS,

COUNT(DISTINCT FROM_ADDRESS) AS UNIQUE_ADDRESS,

SUM(UNIQUE_ADDRESS) OVER (ORDER BY DATE) AS CUMULATIVE_UNIQUE_ADDRESSES,

SUM(TX_FEE) AS TOTAL_TXN_FEE

FROM base.core.fact_transactions

GROUP BY 1

ORDER BY 1 DESC