DATE_TRUNC('day', BLOCK_TIMESTAMP) AS transaction_date,

COUNT(*) AS transaction_volume

FROM base.core.fact_transactions;

WHERE BLOCK_TIMESTAMP >= DATEADD(day, -30, CURRENT_TIMESTAMP)

GROUP BY transaction_date

ORDER BY transaction_date;