count (distinct tx_hash) as trxs,

sum (event_inputs:value/1e18) as Ape_volume

from ethereum.core.fact_event_logs

where origin_to_address = '0x025c6da5bd0e6a5dd1350fda9e3b6a614b205a1f'

and event_name = 'Transfer'

and origin_function_signature = '0x48c54b9d'

and tx_status = 'SUCCESS'

and address in (select origin_from_address

from (select a.block_timestamp,

origin_from_address,

a.tx_hash,

contract_address

from ethereum.core.fact_event_logs a join (select block_timestamp,

origin_from_address as receiver,

tx_hash,

event_inputs:value/1e18 as Volume

from ethereum.core.fact_event_logs

where origin_to_address = '0x025c6da5bd0e6a5dd1350fda9e3b6a614b205a1f'

and event_name = 'Transfer'

and origin_function_signature = '0x48c54b9d'

and tx_status = 'SUCCESS') b on a.origin_from_address = b.receiver

and a.block_timestamp > b.block_timestamp

where contract_address = '0x4d224452801aced8b2f0aebe155379bb5d594381'

)

)

group by 1

order by 3 DESC

limit 10