SELECT

DATE_TRUNC('minute', block_timestamp) AS minute,

COUNT(DISTINCT from_address) AS active_addresses

FROM MONAD.testnet.fact_transactions

WHERE block_timestamp >= '2025-02-19 14:00:00' -- شروع از ۱۹ فوریه ساعت ۱۴:۰۰

GROUP BY 1

SELECT

minute,

active_addresses,

AVG(active_addresses) OVER (ORDER BY minute ROWS BETWEEN 29 PRECEDING AND CURRENT ROW) AS moving_avg_30min

FROM active_addresses_per_minute

ORDER BY minute DESC;