PROJECT_NAME | N_DAYS | N_TXS | |
|---|---|---|---|
1 | layerzero | 86 | 7092144 |
2 | xpower | 86 | 3097591 |
3 | uniswap | 86 | 1860986 |
4 | traderjoe | 86 | 1457018 |
5 | trader | 86 | 1448652 |
6 | beefy finance | 86 | 1448598 |
7 | trader joe | 86 | 1447602 |
8 | pharaoh | 86 | 1421105 |
9 | odos | 86 | 1147906 |
10 | pangolin | 86 | 709848 |
11 | stars arena | 86 | 594545 |
12 | dexalot | 86 | 485557 |
13 | agora | 86 | 357187 |
14 | okx | 77 | 262757 |
15 | gmx | 86 | 254637 |
0xHaM-dProject Interaction
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
›
⌄
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
-- LABEL_TYPE,
PROJECT_NAME,
count(distinct block_timestamp::date) as n_days,
count(distinct tx_hash) as n_txs,
from avalanche.core.ez_decoded_event_logs
join avalanche.core.dim_labels on CONTRACT_ADDRESS = ADDRESS
where origin_from_address in (select origin_from_address eventTb)
and LABEL_TYPE != 'token'
and block_timestamp::date >= '2025-01-01'
group by 1
order by 3 desc
limit 15
Last run: 3 months ago
15
343B
6s