WITH trace_stats AS (
SELECT
COUNT(*) AS total_traces,
SUM(value) AS total_gas_used
FROM monad.testnet.fact_traces
WHERE block_timestamp >= '2025-02-19 15:00'
AND TX_SUCCEEDED
AND gas_used IS NOT NULL
)
SELECT
total_traces,
total_gas_used,
ROUND(total_gas_used / NULLIF(total_traces, 0), 2) AS avg_gas_per_trace
FROM trace_stats