select

origin_from_address,

sum(value) AS total_swap_value

from

monad.testnet.fact_event_logs e

join

monad.testnet.fact_transactions t

on

e.tx_hash = t.tx_hash

where

e.contract_address = '0x760afe86e5de5fa0ee542fc7b7b713e1c5425701'

and e.origin_to_address = '0x760afe86e5de5fa0ee542fc7b7b713e1c5425701'

and e.origin_function_signature = '0xd0e30db0'

and e.block_timestamp::date >= '2025-02-19 04:00:00'

group by

origin_from_address

holder_class,

count(distinct origin_from_address) as num_of_users

select origin_from_address,

case

when total_swap_value >= 500 then 'Whales(500+ MON)'

when total_swap_value >= 100 and total_swap_value < 500 then 'Sharks(100-499 MON)'

when total_swap_value >= 10 and total_swap_value < 100 then 'Dolphins(10-99 MON)'

when total_swap_value >= 1 and total_swap_value < 10 then 'Fish(1-9 MON)'

else 'Minnows(<1 MON)'

end as holder_class

balances)

group by holder_class;