Moeaxl txns %
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
26
27
28
29
›
⌄
select
date ,
round ( 100*(transactions-lag(transactions,1)over(order by date))/lag(transactions,1)over(order by date),2) as "transactions change %",
round ( 100*(active_addresses-lag(active_addresses,1)over(order by date))/lag(active_addresses,1)over(order by date),2) as "active_addresses change %",
round ( 100*(txn_per_user-lag(txn_per_user,1)over(order by date))/lag(txn_per_user,1)over(order by date),2) as "txn_per_user change %",
round ( 100*(txn_per_day-lag(txn_per_day,1)over(order by date))/lag(txn_per_day,1)over(order by date),2) as "txn_per_day change %",
round ( 100*(users_per_day-lag(users_per_day,1)over(order by date))/lag(users_per_day,1)over(order by date),2) as "users_per_day change %"
from
(select
date_trunc('week', BLOCK_TIMESTAMP)::date AS date,
count(TX_id) AS transactions,
count(distinct TX_FROM) AS active_addresses ,
transactions / active_addresses as txn_per_user ,
transactions / count(distinct BLOCK_TIMESTAMP::date ) as txn_per_day,
active_addresses / count(distinct BLOCK_TIMESTAMP::date ) as users_per_day,
from axelar.core.fact_transactions
where TX_SUCCEEDED='TRUE'
and BLOCK_TIMESTAMP between CURRENT_DATE - interval '2 months' and current_date
group by 1
)
order by date desc limit 1
Auto-refreshes every 24 hours
QueryRunArchived: QueryRun has been archived