WITH WhDAILY_TRANSACION AS

SELECT DATE_TRUNC('DAY', BLOCK_TIMESTAMP) AS Limited_Level,

COUNT(TX_HASH) AS TransactionCount

From blast.core.fact_transactions

WHERE STATUS = 'SUCCESS'

GROUP by Limited_Level

SELECT TO_CHAR(Limited_Level, 'MON-DD') AS Text_Date, TransactionCount

FROM WhDAILY_TRANSACION

ORDER BY Limited_Level