select 'LaLiga Golazos' as project_name,

date_trunc (day,block_timestamp) as date,

count (distinct tx_id) as Mints_Count,

count (distinct event_data:id) as Minted_Tokens,

count (distinct event_data:editionID) as Editions_Count,

count (distinct proposer) as Minters_Count,

sum (mints_count) over (order by date) as Cumulative_Mints_Count,

sum (minted_tokens) over (order by date) as Cumulative_Minted_Tokens,

row_number () over (order by date) as Day_Counter

from flow.core.fact_events t1 join flow.core.fact_transactions using (tx_id)

where event_contract = 'A.87ca73a41bb50ad5.Golazos'

and event_type = 'MomentNFTMinted'

and tx_succeeded = 'TRUE'

group by 1,2