N_TXS | N_USERS | AVG_TXS_PER_USER | |
|---|---|---|---|
1 | 29532 | 3526 | 8.375496 |
0xHaM-dTotal
Updated 2025-03-27
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 Sector Interaction copy @ https://flipsidecrypto.xyz/studio/queries/cb3ddaa7-0c9d-4678-86e3-6a77afd8bbae
WITH eventTb AS (
select
block_timestamp,
tx_hash,
origin_from_address,
from avalanche.core.ez_decoded_event_logs
where origin_to_address in (
'0x013b34dba0d6c9810f530534507144a8646e3273'
,'0x0363a3debe776de575c36f524b7877db7dd461db'
,'0x698c34bad17193af7e1b4eb07d1309ff6c5e715e'
,'0xabe7a9dfda35230ff60d1590a929ae0644c47dc1'
,'0x8a63943ac3f394ed73c7b06fecf3a81bc11b840e'
,'0x46080cd724102ac0e1d4d1fb45474d14e175a8f9'
,'0xb79a06e4cbf379f4676983d1a6d83e996c3a63c4'
)
)
select
count(distinct tx_hash) as n_txs,
count(distinct origin_from_address) as n_users,
n_txs/n_users as avg_txs_per_user,
from eventTb
Last run: 3 months ago
1
23B
15s