-- 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

AND YEAR(BLOCK_TIMESTAMP) = YEAR(CURRENT_DATE())

GROUP BY DATE(BLOCK_TIMESTAMP)

SELECT

day,

total_volume_base_tokens

FROM september_transactions

ORDER BY day ASC;