DATE_TRUNC ('HOUR' ,BLOCK_TIMESTAMP) AS hour,

monthname(BLOCK_TIMESTAMP) AS Month,

sum(TX_COUNT)/3600 AS TPS

from axelar.core.fact_blocks

where BLOCK_TIMESTAMP::date >= current_date - interval ' 3 months '

GROUP BY 1,2

ORDER BY 1 DESC