sum(amount_usd) as usd

from avalanche.core.ez_token_transfers

where to_address in ('0xe3c983013b8c5830d866f550a28fd7ed4393d5b7',

'0x203e9101e09dc87ce391542e705a07522d19df0d',

'0xa53e127bfd9c4d0310858d9d5fcdf1d2617d4c41',

'0x1d8bd363922465246a91b7699e7b32babf5fef62',

'0x8f1dea444380a2ddc5e6669f508d235401caee5f',

and symbol in ('BTC.b','AUSD','SolvBTC','sAVAX','COQ','ggAVAX')

and block_timestamp::date >= '2024-10-07'

group by from_address

select case when usd<100 then 'Less Than 100$'

when usd>=100 and usd<1000 then '100$ - 1000$'

when usd>=1000 and usd<10000 then '1000$ - 10000$'

else 'More Than 10000$' end as splitter,

count( from_address) as users

from base

group by splitter