siavashjActive Projects on Near Horizon
Updated 2023-06-24
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
›
⌄
with labels as (
select
address,
label_type,
project_name
from near.core.dim_address_labels
),
base as (
select
date_trunc('week',block_timestamp) as date,
count(distinct tx_hash) as activity,
method_name as action,
label_type,
project_name
from near.horizon.fact_decoded_actions
join labels on signer_id = address
where block_timestamp >= current_date - interval '{{Left_Weeks}} week'
group by 1,3,4,5
having activity > 1
)
select
date,
activity as "Activity",
action,
label_type,
project_name
from base
where project_name is not null
Run a query to Download Data