SELECT
CHAIN_ID,
DATE_TRUNC('day', BLOCK_TIMESTAMP) AS transaction_date,
COUNT(TX_ID) AS transaction_count
FROM flow.core.fact_transactions;
WHERE BLOCK_TIMESTAMP >= DATEADD(day, -30, CURRENT_TIMESTAMP())
GROUP BY CHAIN_ID, transaction_date
ORDER BY transaction_date, CHAIN_ID;