block_timestamp::date as date,

count(distinct TRANSACTION_HASH) / (24 * 60 * 60) as tps,

count(distinct transaction_hash) as txs,

count(distinct account) as accounts,

txs / count(distinct block_timestamp::date) as avg_tx_per_day,

(sum(CASE WHEN successful THEN 1 ELSE 0 end) * 100) / txs as success_rate

from stellar.core.fact_transactions

where block_timestamp >= '2025-01-01'

group by 1