SELECT
DATE_TRUNC('day', block_timestamp) AS day,
COUNT(tx_hash) AS total_transactions,
SUM(value) AS total_value_transacted,
SUM(tx_fee) AS total_fees
FROM
avalanche.core.fact_transactions
WHERE
block_timestamp BETWEEN '2023-07-01' AND '2023-08-31'
GROUP BY
day
ORDER BY
day;