origin_from_address as sender,

'xDAI' as transfer,

count(distinct tx_hash) as tx_cnt

from gnosis.core.ez_xdai_transfers

where block_timestamp >= '2022-10-04'

and block_timestamp <= '2022-10-05'

group by 1,2

HAVING tx_cnt > 1000

UNION

select

origin_from_address as sender,

'Other Tokens' as transfer,

count(distinct tx_hash) as tx_cnt

from gnosis.core.fact_token_transfers

where block_timestamp >= '2022-10-04'

and block_timestamp <= '2022-10-05'

group by 1,2

HAVING tx_cnt > 1000

ORDER by 3 DESC