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'

),

swapper_totals AS (

SELECT

origin_from_address,

SUM(amount0_used) AS total_volume

FROM base

GROUP BY origin_from_address

),

categorized AS (

SELECT

origin_from_address,

total_volume,

CASE

WHEN total_volume >= 100000 THEN '🐳 Mega Whale'

WHEN total_volume >= 50000 THEN '🐋 Whale'

WHEN total_volume >= 10000 THEN '🐬 Dolphin'

WHEN total_volume >= 1000 THEN '🐟 Fish'

WHEN total_volume >= 100 THEN '🐢 Crab'

WHEN total_volume >= 10 THEN '🦐 Shrimp'