Block_timestamp :: DATE AS Date,

nft_collection_name,

collection_id,

COUNT(DISTINCT tx_id) AS Txn_count,

SUM(SALES_AMOUNT) AS sol_vol,

SUM(sol_vol)

OVER (PARTITION BY COLLECTION_ID ORDER BY Date) AS Cumul_sol_vol,

--Succeeded

from solana.nft.fact_nft_sales s

JOIN solana.nft.dim_nft_metadata l

ON s.mint = l.mint

WHERE NFT_Name LIKE '%Clayno%'

AND Date >= '2024-01-01'

AND nft_collection_name IS NOT NULL

GROUP BY 1, 2, 3

ORDER BY 6 DESC