SELECT EVENT_DATA, TX_ID

from flow.core.fact_events

WHERE 1 = 1

AND EVENT_CONTRACT = 'A.329feb3ab062d289.RaceDay_NFT'

AND TX_SUCCEEDED = 1

AND EVENT_TYPE = 'Minted'

SELECT DATE_TRUNC('DAY', BLOCK_TIMESTAMP::DATE) AS "Day",

COUNT(DISTINCT a.EVENT_DATA:to) AS "NUMBER OF MINTERS",

COUNT(DISTINCT(a.EVENT_DATA:id)) AS "NUMBER OF MINTS",

SUM("NUMBER OF MINTERS") OVER (ORDER BY "Day" ASC) AS "COMULATIVE NUMBER OF MINTERS",

SUM("NUMBER OF MINTS") OVER (ORDER BY "Day" ASC) AS "COMULATIVE NUMBER OF MINTS"

FROM flow.core.fact_events A

LEFT OUTER JOIN B ON A.TX_ID = B.TX_ID

WHERE 1 = 1

AND B.EVENT_CONTRACT = 'A.329feb3ab062d289.RaceDay_NFT'

AND A.EVENT_TYPE = 'Deposit'

AND A.TX_SUCCEEDED = 1

group by "Day"

order by 1