SELECT
split_part(NFT_COLLECTION, '.', 3) AS NFT_COLLECTION,
split_part(CURRENCY, '.', 3) AS CURRENCY,
SUM(PRICE) AS volume, COUNT(*) AS Number
FROM flow.core.fact_nft_sales
WHERE BLOCK_TIMESTAMP::date >= CURRENT_DATE - 7
GROUP BY 1,2
ORDER BY 3 DESC