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,

DATE_TRUNC('hour', l.block_timestamp) AS hour,

l.tx_hash AS tx_hash

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'

),

erc721_contracts AS (

SELECT

contract_address

FROM monad.testnet.fact_event_logs

WHERE topic_0 = '0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef'

AND ARRAY_SIZE(topics) = 4

AND block_timestamp >= '2025-02-19'