COUNT(DISTINCT tx_id) AS txs,

COUNT(DISTINCT tx_from) AS users,

SUM(fee / 1e6) AS fees,

AVG(fee / 1e6) AS avg_fee,

MAX(fee / 1e6) AS max_fee,

MIN(fee / 1e6) AS min_fee,

PERCENTILE_CONT(0.5) WITHIN GROUP (ORDER BY fee / 1e6) AS median_fee,

SUM(CASE WHEN TX_Succeeded = 'TRUE' THEN 1 ELSE 0 END) AS success_txs,

SUM(CASE WHEN TX_Succeeded != 'TRUE' THEN 1 ELSE 0 END) AS failed_txs,

(SUM(CASE WHEN TX_Succeeded = 'TRUE' THEN 1 ELSE 0 END) * 100.0 / COUNT(DISTINCT tx_id)) AS success_rate,

(SUM(CASE WHEN TX_Succeeded != 'TRUE' THEN 1 ELSE 0 END) * 100.0 / COUNT(DISTINCT tx_id)) AS failure_rate

FROM lava.core.fact_transactions

WHERE block_timestamp > '2024-07-30 11:00:00.000'