date_trunc('day', block_timestamp) AS day,

COUNT(DISTINCT CASE WHEN tx_succeeded = 'TRUE' THEN tx_hash END) * 100.0

/ COUNT(DISTINCT tx_hash) AS "tx Success Rate %"

FROM monad.testnet.fact_transactions

WHERE block_timestamp > '2025-02-18 00:00:00.000'

GROUP BY day

ORDER BY day;