select

play_type,

e.*

from flow.core.fact_events e

inner join flow.core.dim_topshot_metadata b on e.EVENT_DATA:momentID=b.nft_id

where EVENT_CONTRACT ilike '%TopShot'

and TX_SUCCEEDED = true

and EVENT_TYPE like 'MomentMinted'

)

select

date_trunc(month,block_timestamp)::date as months,

play_type,

count(*) as moments,

sum(moments)over(partition by play_type order by months rows between unbounded preceding and current row ) as cumulative_moments_mint

from base

group by 1, 2

order by 1