Moeaxl txns t
Updated 2024-12-22
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
select
date_trunc('week', BLOCK_TIMESTAMP)::date AS date,
monthname(BLOCK_TIMESTAMP) AS Month,
count(TX_id) AS "transactions ",
count(distinct TX_FROM) AS "active addresses "
from axelar.core.fact_transactions
where TX_SUCCEEDED='TRUE'
and BLOCK_TIMESTAMP between CURRENT_DATE - interval '6 months' and current_date
group by 1,2
QueryRunArchived: QueryRun has been archived