Ali3NTransactions and Users Over Time (Stablejack)
Updated 2025-02-04
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
›
⌄
with t2 as (
select '0x013b34dba0d6c9810f530534507144a8646e3273' as address,
union all
select '0x0363a3debe776de575c36f524b7877db7dd461db' as address
union all
select '0x698c34bad17193af7e1b4eb07d1309ff6c5e715e' as address,
union all
select '0xabe7a9dfda35230ff60d1590a929ae0644c47dc1' as address
)
select date_trunc (week,block_timestamp) as date,
count (distinct tx_hash) as Transactions,
count (distinct origin_from_address) as Active_Users,
sum (transactions) over (order by date) as Total_Transactions
from avalanche.core.ez_decoded_event_logs t1 join t2 on t1.origin_to_address = t2.address
group by 1
order by 1 desc
QueryRunArchived: QueryRun has been archived