case

when bal < 0.01 then '01. <0.01 ETH'

when bal >= 0.01 and bal < 0.05 then '02. 0.01 - 0.05 ETH'

when bal >= 0.05 and bal < 0.1 then '03. 0.05 - 0.1 ETH'

when bal >= 0.1 and bal < 0.3 then '04. 0.1 - 0.3 ETH'

when bal >= 0.3 and bal < 0.6 then '05. 0.3 - 0.6 ETH'

when bal >= 0.6 and bal < 1 then '06. 0.6 - 1 ETH'

when bal >= 1 and bal < 5 then '07. 1 - 5 ETH'

when bal >= 5 and bal < 10 then '08. 5 - 10 ETH'

when bal >= 10 and bal < 20 then '09. 10 - 20 ETH'

when bal >= 20 and bal < 40 then '10. 20 - 40 ETH'

when bal >= 40 and bal < 80 then '11. 40 - 80 ETH'

when bal >= 80 and bal < 100 then '12. 80 - 100 ETH'

when bal >100 then '13. >100 ETH'

end as label

(select address,

sum(amount_usd) as bal_usd,

sum(amount) as bal

from

(select date(block_timestamp) as datetime,

to_address as address,

amount,

amount_usd

from ink.core.ez_native_transfers

union all

select date(block_timestamp) as datetime,

from_address,

-amount,

-amount_usd

from ink.core.ez_native_transfers)

group by 1)

group by 2

order by 2