count(distinct trader) as luna_seller,

case

when (FROM_AMOUNT/pow(10,6)) <= 10 then 'less than 10'

when (FROM_AMOUNT/pow(10,6)) > 10 and (FROM_AMOUNT/pow(10,6)) <= 100 then '10-100'

when (FROM_AMOUNT/pow(10,6)) > 100 and (FROM_AMOUNT/pow(10,6)) <= 1000 then '100-1000'

when (FROM_AMOUNT/pow(10,6)) > 1000 and (FROM_AMOUNT/pow(10,6)) <= 10000 then '1000-10000'

when (FROM_AMOUNT/pow(10,6)) > 10000 and (FROM_AMOUNT/pow(10,6)) <= 100000 then '10000-100000'

when (FROM_AMOUNT/pow(10,6)) > 100000 then 'more than 100000'

end as distribution

from terra.core.ez_swaps

where FROM_CURRENCY = 'uluna'

and TX_SUCCEEDED = 'TRUE'

and BLOCK_TIMESTAMP::date = '2023-01-09'

group by 2