with mints as (
select *
from flow.core.fact_events
where event_type = 'Minted'
and event_contract = 'A.329feb3ab062d289.RaceDay_NFT'
and tx_succeeded = 1
)
select a.block_timestamp::date as day,
count(distinct(a.event_data:to)) as minters_num,
count(distinct(a.event_data:id)) as mints_num
from flow.core.fact_events a
left outer join mints
on a.tx_id = mints.tx_id
and a.event_data:id = mints.event_data:id
and a.event_contract = mints.event_contract
where a.event_type = 'Deposit'
and a.tx_succeeded = 1
group by day
order by day asc