LABEL_TYPE | N_DAYS | N_TXS | |
|---|---|---|---|
1 | bridge | 86 | 7210712 |
2 | dex | 86 | 6875316 |
3 | dapp | 86 | 4033871 |
4 | defi | 86 | 4028715 |
5 | cex | 85 | 263507 |
6 | games | 86 | 127020 |
7 | nft | 86 | 39450 |
0xHaM-dSector 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
Last run: 30 days ago
7
137B
9s