program_id as program,

count(distinct tx_id) as transactions

aleo.core.fact_transitions

where block_timestamp < '2025-01-01'

group by 1

order by 2 desc

limit 10