TOTAL_MINTERS | TOTAL_MINTS | |
|---|---|---|
1 | 457896 | 1489192 |
datavortexMinters
Updated 2025-02-22
999
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 erc1155_contracts AS (
SELECT
contract_address
FROM monad.testnet.fact_event_logs
WHERE topic_0 IN (
'0xc3d58168c5ae7397731d063d5bbf3d657854427343f4c083240f7aacaa2d0f62',
'0x4a39dc06d4c0dbc64b70b5eb2aa10c99d1887e3f0adf967c6fbbfb89c4a79e11'
)
AND block_timestamp >= '2025-02-19'
GROUP BY contract_address
),
decoded_erc1155_mints AS (
SELECT
origin_from_address AS minter,
'0x' || SUBSTR(topics[2], 27) AS to_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
FROM monad.testnet.fact_event_logs l
WHERE topic_0 IN (
'0xc3d58168c5ae7397731d063d5bbf3d657854427343f4c083240f7aacaa2d0f62',
'0x4a39dc06d4c0dbc64b70b5eb2aa10c99d1887e3f0adf967c6fbbfb89c4a79e11'
)
AND l.contract_address IN (SELECT contract_address FROM erc1155_contracts)
AND l.block_timestamp >= '2025-02-19'
),
erc721_contracts AS (
SELECT
contract_address
FROM monad.testnet.fact_event_logs
WHERE topic_0 = '0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef'
AND ARRAY_SIZE(topics) = 4
Last run: 28 days ago
1
18B
3s