date_trunc('day', block_timestamp) as day,

count(*) as mints,

count(DISTINCT decoded_log:to) as minters,

count(DISTINCT tx_hash) as mint_events

from base.core.ez_decoded_event_logs

WHERE decoded_log:from LIKE '0x0000000000000000000000000000000000000000'

and not decoded_log:tokenId is NULL

GROUP BY 1