from gnosis.core.fact_transactions

where block_timestamp::date between '2022-10-04' and '2022-10-8'

group by 1

order by 2 desc

limit 5)

select trunc(block_timestamp,'hour') as date, case when to_address = '0xc38d4991c951fe8bce1a12beef2046ef36b0fa4a' then 'Rinkeby'

else 'Other Platform' end as type, count(DISTINCT(tx_hash)) as total

from gnosis.core.fact_transactions

where block_timestamp::date between '2022-10-04' and '2022-10-08'

and from_address in (select from_address from top_user)

group by 1,2