headitmanagerNumber of Transactions per month
Updated 2022-07-02
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
with active_users as (select count(1) as tcount, tx_receiver as address from mdao_near.transactions
where block_timestamp::date > current_date - interval '30 days'
group by address
having tcount>=1)
, total_active_users as (select count(distinct address) from active_users)
, number_of_transactions_daily as (select count(tx_receiver),block_timestamp::date from mdao_near.transactions where tx_receiver in (select address from active_users)
and block_timestamp::date > current_date - interval '90 days'
group by block_timestamp::date)
, number_of_transactions_monthly as (select count(tx_receiver),monthname(block_timestamp::date) from mdao_near.transactions where tx_receiver in (select address from active_users)
and block_timestamp::date > current_date - interval '90 days' and block_timestamp::date < '2022-07-01'
group by monthname(block_timestamp::date))
select * from number_of_transactions_monthly
Run a query to Download Data