date_trunc(week,date) as date

,case

when nft_count between 1 and 5 then '1-5 NFTs'

when nft_count between 6 and 10 then '6-10 NFTs'

when nft_count between 11 and 15 then '11-15 NFTs'

when nft_count between 16 and 20 then '16-20 NFTs'

when nft_count between 21 and 30 then '21-30 NFTs'

when nft_count between 31 and 40 then '31-40 NFTs'

when nft_count between 41 and 50 then '41-50 NFTs'

when nft_count between 51 and 75 then '51-75 NFTs'

when nft_count between 76 and 100 then '76-100 NFTs'

when nft_count > 100 then 'more than 100 NFTs'

end as OWNERSHIP_BUCKET,

count(DISTINCT buyer) as USERS_IN_BUCKET

(select block_timestamp::date as date, buyer, count(distinct nft_id) as nft_count

from flow.nft.ez_nft_sales

where nft_collection = 'A.e4cf4bdc1751c65d.AllDay'

and tx_succeeded = true

group by date,buyer) as user_nft_counts

group by

date,ownership_bucket

order by

date