count (distinct tx_hash) as TX_Count,

sum (event_inputs:value/1e18) as Claimed_Ape_Volume,

rank() over (order by Claimed_Ape_Volume desc) as rank_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'

group by 1

order by Claimed_Ape_Volume DESC

limit 10