SELECT

contract_address

FROM monad.testnet.fact_event_logs

WHERE topic_0 IN (

'0xc3d58168c5ae7397731d063d5bbf3d657854427343f4c083240f7aacaa2d0f62',

'0x4a39dc06d4c0dbc64b70b5eb2aa10c99d1887e3f0adf967c6fbbfb89c4a79e11'

)

AND block_timestamp >= '2025-02-19'

GROUP BY contract_address

),

decoded_erc1155_mints AS (

SELECT

origin_from_address AS minter,

'0x' || SUBSTR(topics[2], 27) AS to_address,

l.contract_address AS contract_address,

ethereum.public.udf_hex_to_int(topics[3]) AS token_id,

l.block_timestamp AS block_timestamp,

l.tx_hash AS tx_hash,

l.event_index AS event_index

FROM monad.testnet.fact_event_logs l

WHERE topic_0 IN (

'0xc3d58168c5ae7397731d063d5bbf3d657854427343f4c083240f7aacaa2d0f62',

'0x4a39dc06d4c0dbc64b70b5eb2aa10c99d1887e3f0adf967c6fbbfb89c4a79e11'

)

AND l.contract_address IN (SELECT contract_address FROM erc1155_contracts)

AND l.block_timestamp >= '2025-02-19'

SELECT

COUNT(DISTINCT minter) AS total_minters,

COUNT(DISTINCT tx_hash) AS total_mints

FROM decoded_erc1155_mints;