SniperDaily Number of Active Wallets by NFT
Updated 2025-03-23
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
›
⌄
select
trunc(BLOCK_TIMESTAMP,'day') as daily,
case
when contract_address = '0x77ce5148b7ad284e431175ad7258b54a64816da6' then 'Rod'
when contract_address = '0x9c76fc5bd894e7f51c422f072675c876d5998a9e' then 'Chests'
when contract_address = '0x4079da822e8972982b8569e38cdf719a21069934' then 'Fish'
when contract_address = '0xdda950223ead838c21838109a2f550c964a23c5b' then 'DailyCheckIn'
-- when contract_address = '0x3fa1e076bd4e7f4b7469ad1646332c09b275082d' then 'Founders Pass'
else 'other'
end as "Contracts",
-- EVENT_NAME,
--*
count(DISTINCT tx_hash ) as txs,
count(DISTINCT origin_from_address ) as wallets ,
-- count (DISTINCT token_id) as nfts
from ronin.core.ez_decoded_event_logs where
CONTRACT_ADDRESS in (
'0x4079da822e8972982b8569e38cdf719a21069934',--fish
'0x9c76fc5bd894e7f51c422f072675c876d5998a9e',--chests
'0x77ce5148b7ad284e431175ad7258b54a64816da6',--rods
-- '0x3fa1e076bd4e7f4b7469ad1646332c09b275082d'-- Fishing Frenzy Founders Pass
'0xdda950223ead838c21838109a2f550c964a23c5b'
)
and TX_SUCCEEDED='TRUE'
and BLOCK_TIMESTAMP::date>= '2025-03-21'
-- and EVENT_NAME in ('RodMintedBatch','Transfer')
-- and origin_from_address ='0x32c7ddB397E621C06377f7b620c1cac9C3A04f44'
-- limit 20
group by 1,2
QueryRunArchived: QueryRun has been archived