WEEKLY | TRANSACTIONS | WALLETS | |
|---|---|---|---|
1 | 2025-03-31 00:00:00.000 | 1594 | 875 |
2 | 2025-04-14 00:00:00.000 | 121583 | 11676 |
3 | 2025-04-07 00:00:00.000 | 87678 | 10711 |
4 | 2025-04-21 00:00:00.000 | 132938 | 13729 |
5 | 2025-03-17 00:00:00.000 | 66056 | 7371 |
6 | 2025-03-24 00:00:00.000 | 49282 | 6527 |
SniperDaily Number of Active Wallets
Updated 1 day ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
select
trunc(BLOCK_TIMESTAMP,'week') as weekly,
count(DISTINCT tx_hash) as transactions,
count(DISTINCT from_address) as wallets
from ronin.core.fact_transactions
where to_address in (
'0x77ce5148b7ad284e431175ad7258b54a64816da6',
'0x87a699a08d57142d46c909b7f2df49d44d87211f',
'0x9c76fc5bd894e7f51c422f072675c876d5998a9e',
'0xc69f7434d4b336e68acbbde4101b7990e7d6b3b3',
'0xdda950223ead838c21838109a2f550c964a23c5b',
'0xd42364171036dd7dabe2ba5efc368c896d03ce89',
'0x4079da822e8972982b8569e38cdf719a21069934',
'0xca3f4ee13c4def532b16b90ec5246138ef6d92bf'
)
and TX_SUCCEEDED = 'TRUE'
and BLOCK_TIMESTAMP::date>='2025-03-21'
group by 1
Last run: 1 day ago
6
238B
3s