SELECT

origin_from_address AS minter,

MIN(DATE_TRUNC('day', block_timestamp)) AS first_mint_date

FROM monad.testnet.fact_event_logs

WHERE origin_to_address = '0x66e40f67afd710386379a6bb24d00308f81c183f'

AND contract_address = '0x66e40f67afd710386379a6bb24d00308f81c183f'

AND topic_0 = '0xc3d58168c5ae7397731d063d5bbf3d657854427343f4c083240f7aacaa2d0f62'

GROUP BY origin_from_address

SELECT

DATE_TRUNC('day', e.block_timestamp) AS mint_date,

COUNT(DISTINCT CASE WHEN f.first_mint_date = DATE_TRUNC('day', e.block_timestamp) THEN e.origin_from_address END) AS new_users,

COUNT(DISTINCT CASE WHEN f.first_mint_date < DATE_TRUNC('day', e.block_timestamp) THEN e.origin_from_address END) AS returning_users

FROM monad.testnet.fact_event_logs e

LEFT JOIN first_mint f ON e.origin_from_address = f.minter

WHERE e.origin_to_address = '0x66e40f67afd710386379a6bb24d00308f81c183f'

AND e.contract_address = '0x66e40f67afd710386379a6bb24d00308f81c183f'

AND e.topic_0 = '0xc3d58168c5ae7397731d063d5bbf3d657854427343f4c083240f7aacaa2d0f62'

AND e.tx_succeeded = TRUE

GROUP BY mint_date

ORDER BY mint_date ASC