event_type,

count(distinct x.tx_id) as transactions

from flow.core.fact_events x

where block_timestamp>=CURRENT_DATE-7

group by 1

order by 2 desc

limit 10