SELECT

DISTINCT

tx_hash,

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

'0x' || SUBSTR(topics[1], 27) AS from_address,

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

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

kaia.utils.udf_hex_to_int(data :: STRING) AS amount

FROM kaia.core.fact_event_logs

WHERE

contract_address = LOWER('0x2f0bcecce06b6eb32a83073984d0b793640aeaf6')

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

SELECT

LEFT(to_address, 6) || '...' || RIGHT(to_address, 4) AS minter,

COUNT(tx_hash) AS total_mints,

COUNT(DISTINCT nft_id) AS unique_nfts,

FROM mint_events

GROUP BY to_address

ORDER BY total_mints DESC

LIMIT 10;