group by block_timestamp::date)

, top5nftsales as (select sum(price), nft_collection from flow.core.fact_nft_sales

group by nft_collection

order by sum(price) desc

limit 5)

, compairtop5 as (select sum(price), block_timestamp::date,nft_collection from flow.core.fact_nft_sales where

nft_collection in (select nft_collection from top5nftsales)

group by block_timestamp::date,nft_collection)

select * from top5nftsales