LTirrellnear_citizens_users-near
Updated 2022-10-03
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
30
31
32
33
34
35
36
›
⌄
with active_users_30d as (
select
distinct t.tx_signer as users
from
flipside_prod_db.mdao_near.transactions t
where
t.block_timestamp :: date >= current_date - 30
),
active_user_activity as (
select
t.block_timestamp :: date as datetime,
count(t.tx_hash) as active_users_tx,
count(distinct t.tx_signer) as active_users,
active_users_tx / active_users as tx_per_active_users
from
flipside_prod_db.mdao_near.transactions t
where
datetime >= current_date -90
and t.tx_signer in (
select
users
from
active_users_30d
)
group by
datetime
),
all_user_activity as (
select
t.block_timestamp :: date as datetime,
count(t.tx_hash) as all_users_tx,
count(distinct t.tx_signer) as all_users,
all_users_tx / all_users as tx_per_all_users
from
flipside_prod_db.mdao_near.transactions t
where
Run a query to Download Data