0xHaM-dTop Wallets copy
Updated 2025-02-22Copy Reference Fork
99
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
›
⌄
-- forked from Top Wallets @ https://flipsidecrypto.xyz/studio/queries/724e469e-2d28-4939-b15f-bf14b67f00e0
-- 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
)
, wallets as (
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
)
select
case
when n_nft_tokens = 1 then '1 NFT'
when n_nft_tokens = 2 then '2 NFT'
when n_nft_tokens = 3 then '3 NFT'
when n_nft_tokens = 4 then '4 NFT'
when n_nft_tokens = 5 then '5 NFT'
when n_nft_tokens = 6 then '6 NFT'
when n_nft_tokens = 7 then '7 NFT'
when n_nft_tokens = 8 then '8 NFT'
QueryRunArchived: QueryRun has been archived