-- Get the total volume of Base tokens per day for the month of September

SELECT

DATE(BLOCK_TIMESTAMP) AS day,

SUM(VALUE) AS total_volume_base_tokens

FROM base.core.fact_transactions

WHERE

MONTH(BLOCK_TIMESTAMP) = 9 -- Filter for September

AND YEAR(BLOCK_TIMESTAMP) = YEAR(CURRENT_DATE()) -- Filter for the current year

GROUP BY DATE(BLOCK_TIMESTAMP)

SELECT

AVG(total_volume_base_tokens) AS average_volume_base_tokens_september

FROM september_transactions;