philosophical-azure

Echo5577philosophical-azure

Updated 2025-05-12

SELECT

TO_CHAR(DATE_TRUNC('month', BLOCK_TIMESTAMP_HOUR), 'Month YYYY') AS month_name,

SUM(UNIQUE_SENDER_COUNT) AS unique_senders

FROM

aptos.stats.ez_core_metrics_hourly

WHERE

YEAR(BLOCK_TIMESTAMP_HOUR) = YEAR(CURRENT_DATE())

AND MONTH(BLOCK_TIMESTAMP_HOUR) <= 9 -- To include only months up to September

GROUP BY

DATE_TRUNC('month', BLOCK_TIMESTAMP_HOUR), -- Group by the same expression used in the SELECT

month_name

ORDER BY

DATE_TRUNC('month', BLOCK_TIMESTAMP_HOUR); -- Order by the same expression

Last run: 13 days ago

121B

flipside