COUNT(DISTINCT CONTRACT_ADDRESS) | TOTAL_MINTS | TOTAL_MINTERS | |
|---|---|---|---|
1 | 1283 | 429069 | 139137 |
datavortexerc 721
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
›
⌄
WITH erc721_contracts AS (
SELECT DISTINCT contract_address
FROM monad.testnet.fact_event_logs
where topic_0 = '0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef'
and ARRAY_SIZE(topics) = 4
),
decoded_mints AS (
SELECT
origin_from_address AS minters,
'0x' || SUBSTR(topics[1], 27) AS to_address,
'0x' || SUBSTR(topics[2], 27) AS from_address,
l.contract_address AS contract_address,
ethereum.public.udf_hex_to_int(topics[3]) AS token_id,
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 '0x' || SUBSTR(topics[1], 27) IN ('0x0000000000000000000000000000000000000001', '0x0000000000000000000000000000000000000000')
and l.contract_address IN (SELECT contract_address FROM erc721_contracts)
)
SELECT
count(distinct contract_address),
COUNT(DISTINCT tx_hash) AS total_mints,
COUNT(DISTINCT minters) AS total_minters
FROM decoded_mints
Last run: 28 days ago
1
22B
3s