with maintable as (

select to_address,

sum (amount) as Received_Amount

from avalanche.core.ez_token_transfers

where contract_address = '0xb8d7710f7d8349a506b75dd184f05777c82dad0c'

and from_address = '0x30f587903ef022774f5e35151e0e73c196bd755d'

and origin_function_signature = '0x3b439351'

and block_timestamp > '2024-12-29 23:52:50.000'

group by 1)

select case when Received_Amount < 100 then '< 100 $ARENA'

when Received_Amount > 100 and Received_Amount <= 1000 then '100 - 1,000 $ARENA'

when Received_Amount > 1000 and Received_Amount <= 10000 then '1,000 - 10,000 $ARENA'

when Received_Amount > 10000 and Received_Amount <= 100000 then '10,000 - 100,000 $ARENA'

when Received_Amount > 100000 and Received_Amount <= 1000000 then '100,000 - 1,000,000 $ARENA'

else '1,000,000 $ARENA'

end as type,

count (distinct to_address) as Receivers

from maintable

group by 1

order by 2 desc