SELECT case
when price_usd < 0.00001 then '0$ - 0.00001$'
when price_usd < 0.0001 then '0.00001$ - 0.0001$'
when price_usd < 0.001 then '0.0001$ - 0.001$'
when price_usd < 0.01 then '0.001$ - 0.01$'
when price_usd < 0.1 then '0.01$ - 0.1$'
when price_usd < 1 then '0.1$ - 1$'
when price_usd < 10 then '1$ - 10$'
else 'Greater than 10$' end as price_range,
count(*) as quantity_of_ASAs,
max(price_usd)
FROM algorand.prices_swap
WHERE date_trunc('hour',block_hour) = date_trunc('hour',cast('2022-04-27T12:00:00' as date))
AND swaps_in_hour > 0
GROUP BY price_range
ORDER BY price_range asc