DATE_TRUNC('day', block_timestamp) AS date,

COUNT(fact_transactions_id) AS total_transactions,

COUNT(CASE WHEN tx_succeeded THEN fact_transactions_id ELSE NULL END) AS successful_transactions,

COUNT(CASE WHEN tx_succeeded THEN fact_transactions_id ELSE NULL END) / COUNT(fact_transactions_id) * 100 AS success_rate

kaia.core.fact_transactions

GROUP BY

DATE_TRUNC('day', block_timestamp)

ORDER BY

date;