SELECT

TRUNC(block_timestamp, 'week') AS date,

currency,

SUM(price) AS total_value

FROM

flow.nft.ez_nft_sales

WHERE tx_succeeded = TRUE

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

SELECT *

FROM currency_usage

WHERE date < TRUNC(CURRENT_DATE, 'hour')

ORDER BY date ASC;