select
split_part(nft_collection, '.', -1) as nft_collection,
sum(price) as total_volume
from flow.core.fact_nft_sales
where nft_collection in ('A.0b2a3299cc857e29.TopShot','A.e4cf4bdc1751c65d.AllDay','A.329feb3ab062d289.UFC_NFT','A.8b148183c28ff88f.Gaia','A.f2af175e411dfff8.MetaPanda','A.e4cf4bdc1751c65d.PackNFT')
and currency='A.ead892083b3e2c6c.DapperUtilityCoin'
--there is only 224 transactions with flow token for topshot
group by nft_collection
ORDER BY total_volume desc