select count(tx_hash) as sales,
case
when price < 0.01 then '[0-0.01)'
when price >= 0.01 and price < 0.1 then '[0.01-0.1)'
when price >= 0.1 and price < 1 then '[0.1-1)'
when price >= 1 then '[> 1]'
END as intervals
from ethereum.core.ez_nft_sales
where currency_symbol = 'ETH'
and block_timestamp::date between '2021-12-18' and CURRENT_DATE
group by 2