WITH t0 AS (

SELECT DATE_TRUNC('minute', t.block_timestamp) AS minute

, CASE

WHEN t.block_timestamp <= '2023-01-10 18:00:00' THEN 'Gods WL'

WHEN t.block_timestamp <= '2023-01-10 19:00:00' THEN 'Private WL'

ELSE '$BONK WL' END AS phase

, COUNT(1) AS n_minted

FROM solana.core.fact_transactions t

JOIN solana.core.fact_nft_mints m

ON m.tx_id = t.tx_id

JOIN solana.core.dim_labels l

ON l.address = m.mint

WHERE t.block_timestamp >= '2023-01-10'

AND m.block_timestamp >= '2023-01-10'

AND t.block_timestamp <= '2023-01-11'

AND m.block_timestamp <= '2023-01-11'

AND t.succeeded

AND l.label = 'bonkz'

GROUP BY 1, 2

SELECT *

, SUM(n_minted) OVER (ORDER BY minute) AS cumu_n_minted

FROM t0