SELECT

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

ethereum.public.udf_hex_to_int(SUBSTRING(data, 3, 64))::NUMERIC / 1e18 AS amount_minted,

tx_hash,

block_timestamp

FROM mezo.testnet.fact_event_logs

WHERE contract_address = LOWER('0x637e22A1EBbca50EA2d34027c238317fD10003eB')

AND topics[0] = '0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef'

AND '0x' || SUBSTR(topics[1], 27) = '0x0000000000000000000000000000000000000000'

--AND ethereum.public.udf_hex_to_int(SUBSTRING(data, 3, 64))::NUMERIC / 1e18 > 0

AND block_timestamp >= '2025-04-01'

)

SELECT

COUNT(DISTINCT tx_hash) AS mint_tx_count,

COUNT(DISTINCT recipient) AS total_holders,

SUM(amount_minted) AS total_supply

FROM zero_mint_transfers;

/*

WITH zero_mint_transfers AS (

SELECT

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

ethereum.public.udf_hex_to_int(SUBSTRING(data, 3, 64))::NUMERIC / 1e18 AS amount_minted,

tx_hash,

block_timestamp

FROM mezo.testnet.fact_event_logs

WHERE contract_address = LOWER('0x637e22A1EBbca50EA2d34027c238317fD10003eB')

--AND topics[0] = '0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef' -- Transfer event signature

AND '0x' || SUBSTR(topics[1], 27) = '0x0000000000000000000000000000000000000000'

AND ethereum.public.udf_hex_to_int(SUBSTRING(data, 3, 64))::NUMERIC / 1e18 > 0

)