WITH Mints AS (
SELECT
DATE_TRUNC('DAY', BLOCK_TIMESTAMP) AS date,
COUNT(*) AS daily_minted_nfts,
SUM(COUNT(*)) OVER (ORDER BY DATE_TRUNC('DAY', BLOCK_TIMESTAMP)) AS cumulative_minted_nfts
FROM flow.core.fact_events
WHERE
event_contract = 'A.e5bf4d436ca23932.BBxBarbiePack'
AND EVENT_TYPE = 'Mint'
AND TX_SUCCEEDED = 'true'
GROUP BY date
)
SELECT
date,
daily_minted_nfts,
cumulative_minted_nfts
FROM
Mints
ORDER BY
date;