flipside

0xHaM-dTop Wallets

Updated 2025-02-22

-- OPEN EDITION CHOGSTAR

with mintEvent as (

select

BLOCK_TIMESTAMP,

TX_HASH,

CONTRACT_ADDRESS,

ORIGIN_FROM_ADDRESS,

ORIGIN_TO_ADDRESS,

ORIGIN_FUNCTION_SIGNATURE,

ethereum.public.udf_hex_to_int(TOPIC_3)::string as token_id,

from monad.testnet.fact_event_logs

where TOPIC_0 = '0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef'

and CONTRACT_ADDRESS = lower('0xb33D7138c53e516871977094B249C8f2ab89a4F4')

and TX_SUCCEEDED = true

)

select

ORIGIN_FROM_ADDRESS as wallet_address,

-- count(distinct ORIGIN_FROM_ADDRESS) as n_minters,

count(distinct token_id) as n_nft_tokens,

from mintEvent

group by 1

order by 2 desc

limit 1000

Last run: about 2 months ago

	WALLET_ADDRESS	N_NFT_TOKENS
1	0x6aec4e6b363673b5d2c697301743482a2cf7a847	10
2	0x20609ba220eb16fcb62ded1f71790e8bdee0e141	10
3	0x617166130316f4089e1d1d17e5111a839ceb73dc	10
4	0x9f2adef7ae56dc8c6e423461ff6a3f9bc654d43d	10
5	0xb4bc6efcbc1c4d147b89f04500a121827932bf09	10
6	0xb022bd743bfbac24abbe21ca811aaed2351d7752	10
7	0xe40ae974251dbfa96123bd3e2a749cf9b946a2b0	10
8	0x08d0c6da76bed1887def74537805888b475d31d7	10
9	0x719139719322cd7360be66b602268c89a24b6dd9	10
10	0xff71512c84096f55cdf5c5f3d3c6ace99b56fef0	10
11	0xa1d328796da875cd71454f42bb757fb94d66c7bb	10
12	0x1cee0016143fbd02c27c994e5fe603484d912f2e	10
13	0x1705d7444728761c10ac3040a1f668860089709f	10
14	0x7d9c5d248c138776e21efdd02ed20b5f404d3755	10
15	0x26a1c373e39910edaa2cef5221ba2fd05e847bf6	10
16	0x9ae55fbaf76dfd299d071eec3a78a9f226802d2c	10
17	0x2baaad95356c93d06efde34e4ecf220452adb2ef	10
18	0x8a4ddddd9718a97929958b09f2e02ea5fc0d37bd	10
19	0x69876c31a27edf11bfd0dbab6e13bcdb3f49f0a0	10
20	0xbb9b97404c5b0f17a7ead6ade2382ca62d5bf802	10

...

1000

49KB

6s