sum(price) as "volume",

case when marketplace = 'A.c1e4f4f4c4257510.Market' then 'Top Shot Market'

when marketplace = 'A.c1e4f4f4c4257510.TopShotMarketV3'then 'Top Shot Market V3'

end as top_shot_market

from flow.core.fact_nft_sales

where nft_collection like '%TopShot'

and tx_succeeded = 'TRUE'

group by 2