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

SUM(VALUE) AS TXN_VOL_ETH,

SUM(TXN_VOL_ETH) OVER (ORDER BY DATE) AS CUMULATIVE_TXN_VOL

FROM base.core.fact_transactions

WHERE VALUE < 1e6

GROUP BY 1

ORDER BY 1 DESC