select date_trunc('day',block_timestamp) as date,
event_name,
count(DISTINCT tx_hash) as txs,
row_number() over (partition by date order by txs DESC) as r
from gnosis.core.fact_event_logs
where block_timestamp >= '2022-10-01'
and event_name is not null
group by 1,2
qualify r <= 10