mlharb, count of active users1
Updated 2022-09-08Copy Reference Fork
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
›
⌄
select date_trunc('day', block_timestamp) as day,
count(distinct(active_user)) as active_users,
'before Nitro' as type
from (select block_timestamp,
origin_from_address as active_user,
event_inputs:value/1e6 as transaction_size
from arbitrum.core.fact_event_logs
where block_timestamp >= '2022-08-26'
and block_timestamp < '2022-08-31'
and event_inputs:value > 0
)
group by 1, 3
UNION
select date_trunc('day', block_timestamp) as day,
count(distinct(active_user)) as active_users,
'after Nitro' as type
from (select block_timestamp,
origin_from_address as active_user,
event_inputs:value/1e6 as transaction_size
from arbitrum.core.fact_event_logs
where block_timestamp > '2022-08-31'
and event_inputs:value > 0
)
group by 1, 3
Run a query to Download Data