MasiMonthly Number of Users and Transactions
Updated 2024-10-19
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
select trunc(block_timestamp::date,'month') as monthly,
case when block_timestamp::date >= '2023-01-01' and block_timestamp::date < '2023-04-01' then 'Q1-2023'
when block_timestamp::date >= '2023-04-01' and block_timestamp::date < '2023-07-01' then 'Q2-2023'
when block_timestamp::date >= '2023-07-01' and block_timestamp::date < '2023-10-01' then 'Q3-2023'
when block_timestamp::date >= '2023-10-01' and block_timestamp::date < '2024-01-01' then 'Q4-2023'
when block_timestamp::date >= '2024-01-01' and block_timestamp::date < '2024-04-01' then 'Q1-2024'
when block_timestamp::date >= '2024-04-01' and block_timestamp::date < '2024-07-01' then 'Q2-2024'
when block_timestamp::date >= '2024-07-01' and block_timestamp::date < '2024-10-01' then 'Q3-2024'
when block_timestamp::date >= '2024-10-01' and block_timestamp::date < '2025-01-01' then 'Q4-2024' end as breakdown,
count(DISTINCT from_address) as users,
count(DISTINCT tx_hash) as transactions,
sum(transactions) over (partition by breakdown order by monthly asc) as "Cumulative"
from avalanche.core.fact_transactions
where block_timestamp::date >= '2023-01-01'
and STATUS = 'SUCCESS'
group by 1,2
order by 1 asc