SELECT

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

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

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'

recipient AS holder,

SUM(amount_minted) AS total_minted

FROM zero_mint_transfers

GROUP BY recipient

ORDER BY total_minted DESC

LIMIT 50;