BUYER | NUM_NFTS | PERCENTAGE_NFT | NFTS_OWNED | |
|---|---|---|---|---|
1 | 0xa7c904ec671a7279275b7c93104748cfdb0249ae | 5 | 1.50% | [
63,
14,
124,
20,
155
] |
2 | 0x74d4e9d1312b34ab9ba58c6b1524b33297822cf1 | 2 | 0.60% | [
187,
321
] |
3 | 0xe86851f5dd2507430761b6ce70bd5617dbf66cdc | 2 | 0.60% | [
3,
256
] |
4 | 0x0245daf2e303bd4e47acb88c87913a047c9ad6c5 | 2 | 0.60% | [
180,
109
] |
5 | 0x4e882851edfcfad4121d4737b427bfad0c80d327 | 2 | 0.60% | [
27,
331
] |
6 | 0xa468c7065c748b508e698a36f9e5c7ccbbb2cae5 | 2 | 0.60% | [
21,
207
] |
JeffersTop holders
Updated 2025-03-28
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
where (m.contract_address = '0xed52e0d80f4e7b295df5e622b55eff22d262f6ed' -- include all txs related to the NFT address
or (m.contract_address = '0x760afe86e5de5fa0ee542fc7b7b713e1c5425701' and m.origin_to_address = '0x224ecb4eae96d31372d1090c3b0233c8310dbbab')) -- include txs that involve a payment for a NFT on Magic Eden
and m.block_timestamp >= '2025-03-03 18:33:00' -- start of minting phase
and t.tx_succeeded = TRUE
),
transfers as -- this part decodes hexadecimal values to numeric and make sure only the relevant tx hashes are included
(
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,
t.value as MON_value,
t.tx_fee as gas_fee
Last run: 28 days ago
6
408B
83s