siavashjTop Projects on Near
    Updated 2023-06-24
    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