1SELECT 
2  (SELECT SUM(metric_transaction_count) 
3   FROM "@xrpscan.xrp_ledger.metrics") as total_transactions_processed,
4  
5  (SELECT COUNT(*) 
6   FROM "@xrpscan.xrp_ledger.balances" 
7   WHERE balance > 0) as active_accounts,
8  
9  (SELECT SUM(balance) / 1000000 
10   FROM "@xrpscan.xrp_ledger.balances") as total_xrp_in_circulation,
11  
12  (SELECT AVG(metric_ledger_interval) 
13   FROM "@xrpscan.xrp_ledger.metrics" 
14   WHERE date >= CURRENT_DATE - INTERVAL '30 days') as avg_ledger_close_time_seconds,
15  
16  (SELECT AVG(metric_accounts_created)
17   FROM "@xrpscan.xrp_ledger.metrics"
18   WHERE date >= CURRENT_DATE - INTERVAL '30 days') as daily_new_accounts_avg_30d,
19  
20  (SELECT (SUM(result_tessuccess) / SUM(metric_transaction_count)) * 100
21   FROM "@xrpscan.xrp_ledger.metrics") as transaction_success_rate_percent