SELECT

date_trunc('day', block_timestamp) AS date,

origin_from_address

FROM berachain.testnet.ez_decoded_event_logs

WHERE contract_address = '0xbb57539243c4d35265fbf4b2f17d67219200450f'

AND contract_name = 'Beranames'

AND event_name = 'Mint'

AND ORIGIN_FUNCTION_SIGNATURE = '0x3d30c7f6'

),

contract2_minters AS (

SELECT

date_trunc('day', block_timestamp) AS date,

origin_from_address

FROM berachain.testnet.ez_decoded_event_logs

WHERE contract_address = '0x9826e5daa4d28a9b97d0f5a3377fcc7927c99a91'

AND contract_name = 'Beranames'

AND event_name = 'NameRegisteredWithRecord'

AND ORIGIN_FUNCTION_SIGNATURE = '0xeeb144da'

AND TX_SUCCEEDED = 'TRUE'

),

daily_all_minters AS (

SELECT date, origin_from_address FROM contract1_minters

UNION

SELECT date, origin_from_address FROM contract2_minters

),

daily_unique_minters AS (

SELECT

date,

COUNT(DISTINCT origin_from_address) AS unique_minters_count

FROM daily_all_minters

GROUP BY date

),