select

tx_hash,

block_timestamp,

seller_address,

buyer_address,

total_price as price,

total_price_usd as price_usd,

platform_fee,

platform_name,

tokenid,

aggregator_name

from

aptos.nft.ez_nft_sales

where

project_name ilike '%loonies%'

case

when price_usd < 10 then 'a. <$10'

when price_usd < 50 then 'b. $10 - $49'

when price_usd < 100 then 'c. $50 - $99'

when price_usd < 500 then 'd. $100 - $499'

when price_usd < 1000 then 'e. $500 - $999'

else 'f. $1,000+'

end as volume_type,

count(distinct tx_hash) as transactions

main

group by 1

order by 1