SELECT

origin_from_address,

CASE

WHEN CAST(decoded_log:_amount0In AS INTEGER) > 0

THEN CAST(decoded_log:_amount0In AS INTEGER) / POWER(10, 6)

ELSE CAST(decoded_log:_amount0Out AS INTEGER) / POWER(10, 6)

END AS amount0_used

FROM ronin.core.ez_decoded_event_logs

WHERE

contract_address = '0x4f7687affc10857fccd0938ecda0947de7ad3812'

AND origin_to_address = '0x5f0acdd3ec767514ff1bf7e79949640bf94576bd'

AND origin_function_signature = '0x3593564c'

AND event_name = 'Swap'

AND block_timestamp >= '2024-11-20'

SELECT

origin_from_address AS swapper,

COUNT(*) AS swap_count,

ROUND(SUM(amount0_used), 2) AS total_volume

FROM base

GROUP BY origin_from_address

ORDER BY total_volume DESC

LIMIT 10;