date(closed_at)as date,

sum(TRANSACTION_COUNT) as total_transactions,

sum(OPERATION_COUNT) as total_operations

from stellar.core.fact_ledgers

group by date

order by date desc;