TOTAL_MINT_TRANSACTIONS | UNIQUE_RECIPIENTS | |
|---|---|---|
1 | 27435 | 27434 |
datavortexconstant-amaranth
Updated 2025-02-20
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
⌄
/*
WITH decoded_mints AS (
SELECT
-- Extract 'from' (must be zero address for minting)
'0x' || SUBSTR(topics[1], 27) AS from_address,
-- Extract 'to' (recipient of the minted NFT/token)
'0x' || SUBSTR(topics[2], 27) AS to_address,
-- The contract that minted the token
l.contract_address AS contract_address,
-- Extract tokenId (for ERC-721 mints)
ethereum.public.udf_hex_to_int(topics[3]) AS token_id,
-- Additional metadata
l.block_timestamp AS block_timestamp,
l.tx_hash AS tx_hash,
l.event_index AS event_index,
l.data AS raw_data
FROM monad.testnet.fact_event_logs l
WHERE l.contract_address = LOWER('0xb33D7138c53e516871977094B249C8f2ab89a4F4') -- Target contract
AND l.topics[0] = '0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef' -- ERC-721 Transfer (minting)
AND '0x' || SUBSTR(topics[1], 27) = '0x0000000000000000000000000000000000000000' -- Minting condition (from zero address)
)
SELECT * FROM decoded_mints;
*/
SELECT
COUNT(DISTINCT tx_hash) AS total_mint_transactions,
COUNT(DISTINCT '0x' || SUBSTR(topics[2], 27)) AS unique_recipients,
FROM monad.testnet.fact_event_logs
WHERE contract_address = LOWER('0x79911986ff0dD4B83CA241ECcc2eDcA31C056cD9')
AND '0x' || SUBSTR(topics[1], 27) IN ('0x0000000000000000000000000000000000000000', '0x0000000000000000000000000000000000000001');
Last run: 28 days ago
1
15B
2s