ADDRESS | NUM_MINTED | NUM_TRANSFERS_REGULAR | |
|---|---|---|---|
1 | 0x6cb787205ba97639e3255f98a698e0da6b016f69 | 0 | 44 |
2 | 0x2b9f230031d7cfa3f79e789927e80934c3e4ebc1 | 0 | 44 |
3 | 0x4fa862e33f5054fc024e7ddcdba331c8fe4bb252 | 1 | 8 |
4 | 0x0b24dc8537340dcf4ff89f522f32ceb6395ef396 | 0 | 5 |
5 | 0xb3a267eedfaef313f3d4d85c092a3677f5fa3936 | 1 | 4 |
6 | 0x82dcba7a8bf3aa462040038ecb3d5d90901676e8 | 0 | 4 |
7 | 0x265f5a9b3181ef516d755cb890a24a98e7d641ce | 0 | 4 |
8 | 0x72d74a290625e32fe77bd83dd59125071a10a0e6 | 0 | 2 |
JeffersSybil wallets public
Updated 2025-03-26
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 tx_hashes as
(
select
distinct m.tx_hash
from monad.testnet.fact_event_logs m
join monad.testnet.fact_transactions t
on m.tx_hash = t.tx_hash
-- join private_mint pm
-- on m.origin_from_address = pm.mint_address
where (m.contract_address = '0xe8f0635591190fb626f9d13c49b60626561ed145'
or (m.contract_address = '0x760afe86e5de5fa0ee542fc7b7b713e1c5425701' and m.origin_to_address = '0x224ecb4eae96d31372d1090c3b0233c8310dbbab'))
and m.block_timestamp >= '2025-02-19 16:00:00'
and t.tx_succeeded = TRUE
),
transfers as
(
select
m.block_timestamp,
m.tx_hash,
m.contract_address AS nft_contract,
m.origin_from_address,
m.origin_to_address,
m.topic_0,
m.topic_1,
m.topic_2,
CASE
when topic_3 = NULL
then 0
else TO_NUMERIC(utils.udf_hex_to_int(topic_3)) -- convert tokenid to numeric
END as token_id,
CASE
when m.contract_address = '0x760afe86e5de5fa0ee542fc7b7b713e1c5425701'
then TO_NUMERIC(utils.udf_hex_to_int(REPLACE(m.data, '0x0000000000000000000000000000000000000000000000', ''))) / POWER(10,18) -- make the hex WMON value numeric
else 0
END as data_converted,
Last run: 12 days ago
8
411B
70s