SELECT

TRUNC(block_timestamp, 'week') AS date,

nft_collection,

COUNT(*) AS sales_count,

SUM(price) AS total_value

FROM

flow.nft.ez_nft_sales

WHERE tx_succeeded = TRUE

GROUP BY TRUNC(block_timestamp, 'week'), nft_collection

SELECT *

FROM top_collections

WHERE date < TRUNC(CURRENT_DATE, 'hour')

ORDER BY total_value DESC, sales_count DESC;