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