FROM_ADDRESS,

count(distinct TX_HASH) as tx_count

from

gnosis.core.fact_transactions

where

BLOCK_TIMESTAMP::date between '2022-10-05' and '2022-10-08'

and FROM_ADDRESS not in (select address from gnosis.core.dim_labels)

group by 1

order by tx_count desc limit 20