DATE_TRUNC('DAY', BLOCK_TIMESTAMP) AS day,

monthname(BLOCK_TIMESTAMP) AS Month,

sum(TX_COUNT)/86400 AS Daily_TPS

FROM axelar.core.fact_blocks

WHERE BLOCK_TIMESTAMP::date >= current_date - INTERVAL '3 months'

GROUP BY 1, 2

ORDER BY 1 DESC;