siavashjTop Projects on Near
Updated 2023-06-24
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
with labels as (
select
address,
label_type,
project_name
from near.core.dim_address_labels
)
select
count(distinct tx_hash) as activity,
count(distinct signer_id) as active_user,
project_name
from near.core.fact_actions_events_function_call
join labels on receiver_id = address
where block_timestamp >= current_date - interval '{{Left_Weeks}} week'
group by 3
order by 2 desc
limit 10