symbol,

case

when usd_value_now <= 10 then 'less than $10'

when usd_value_now > 10 and usd_value_now <=100 then'between $10 - $100'

when usd_value_now > 100 and usd_value_now <=1000 then'between $100 - $1000'

when usd_value_now > 1000 and usd_value_now <=10000 then'between $1000 - $10000'

when usd_value_now > 100000 and usd_value_now <=100000 then'between $10000 - $100000'

else'more than $100000'

end as volume,

count(distinct user_address) as holders

from ethereum.core.ez_current_balances

where contract_address in

(lower('0x95ad61b0a150d79219dcf64e1e6cc01f0b64c4ce'), --shiba

lower('0x6982508145454ce325ddbe47a25d4ec3d2311933'), --pepe

lower('0xcf0c122c6b73ff809c693db761e7baebe62b6a2e'), --floki

lower('0x6B89B97169a797d94F057F4a0B01E2cA303155e4')) --chad

group by 1,2