Top Wallets copy

0xHaM-dTop Wallets copy

Updated 2025-02-22

-- 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'

Last run: about 1 month ago

155B

12s