SELECT

ORIGIN_FROM_ADDRESS AS swapper,

SUM(AMOUNT_USD) AS total_volume

FROM ronin.core.ez_token_transfers

WHERE ORIGIN_TO_ADDRESS = '0x5f0acdd3ec767514ff1bf7e79949640bf94576bd'

AND ORIGIN_FUNCTION_SIGNATURE = '0x3593564c'

AND SYMBOL = 'Ronke'

AND BLOCK_TIMESTAMP::date >= '2025-02-22'

GROUP BY ORIGIN_FROM_ADDRESS

),

volume_brackets AS (

SELECT

swapper,

total_volume,

CASE

WHEN total_volume < 10 THEN '<$10'

WHEN total_volume >= 10 AND total_volume < 100 THEN '$10 - $99'

WHEN total_volume >= 100 AND total_volume < 500 THEN '$100 - $499'

WHEN total_volume >= 500 AND total_volume < 1000 THEN '$500 - $999'

ELSE '≥ $1000'

END AS volume_range,

CASE

WHEN total_volume < 10 THEN 'Tiny Swapper (<$10)'

WHEN total_volume >= 10 AND total_volume < 100 THEN 'Small Swapper ($10 - $99)'

WHEN total_volume >= 100 AND total_volume < 500 THEN 'Medium Swapper ($100 - $499)'

WHEN total_volume >= 500 AND total_volume < 1000 THEN 'Large Swapper ($500 - $999)'

ELSE 'Whale Swapper (≥ $1000)'

END AS category_name

FROM swap_data

volume_range,

category_name,