SELECT date_trunc('day',block_timestamp) as days,
to_address,
from_address,
count(DISTINCT tx_hash) as trxs,
row_number() over (partition by days order by trxs DESC) as r
FROM gnosis.core.fact_transactions
WHERE block_timestamp >='2022-09-01'
GROUP BY 1, 2, 3
qualify r <= 5