BUYER | NUM_NFTS | PERCENTAGE_NFT | NFTS_OWNED | |
|---|---|---|---|---|
1 | 0x0e5329bdbb481514f19af1a5d46eda39d6718a87 | 6 | 1.20% | [
272,
430,
258,
255,
278,
249
] |
2 | 0x2b9f230031d7cfa3f79e789927e80934c3e4ebc1 | 6 | 1.20% | [
286,
431,
276,
279,
283,
251
] |
3 | 0xa01b073564360c5e6854f0fd0a19ce179e870338 | 5 | 1.00% | [
149,
122,
244,
304,
376
] |
4 | 0x265f5a9b3181ef516d755cb890a24a98e7d641ce | 4 | 0.80% | [
405,
462,
467,
468
] |
5 | 0xe2b3780f12da5c1cf5891eb37aa20b74666b3dc3 | 4 | 0.80% | [
395,
131,
449,
440
] |
6 | 0x0b24dc8537340dcf4ff89f522f32ceb6395ef396 | 3 | 0.60% | [
409,
411,
413
] |
7 | 0x5c33d65de92917dae2220194caa5ae43e84d9f6f | 2 | 0.40% | [
72,
455
] |
8 | 0xf712ea96540310ae609b22017861ebd394ffae1a | 2 | 0.40% | [
307,
425
] |
9 | 0xb1aa11bb98e70000aac020045bc011db35097163 | 2 | 0.40% | [
454,
445
] |
10 | 0xe2cf2f121115f383f9a78a803a1652d5ca7a4a05 | 2 | 0.40% | [
301,
355
] |
11 | 0xff455291aa6fcf1b8e0587057d0d709455a58baa | 2 | 0.40% | [
96,
422
] |
12 | 0x2bd290fdb00f5f87bef9dc5bf8f0cca28f697dfe | 2 | 0.40% | [
400,
265
] |
13 | 0x4d9057eedb6d4397788b4830ec7619451adf99b9 | 2 | 0.40% | [
458,
441
] |
14 | 0x2c1f4df355e7d244b860621b4f428ad1fd975bb0 | 2 | 0.40% | [
285,
421
] |
JeffersTop holders
Updated 2025-03-23
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: about 1 month ago
14
1001B
79s