Flipside Teamdist Active NEAR Projects Over Time
    Updated 2024-10-16
    -- forked from dist Active NEAR Projects Over Time copy @ https://flipsidecrypto.xyz/edit/queries/65c3d994-da5c-4366-9ee9-c34043ba02e7

    with near_projects as
    (select ADDRESS, initcap(ADDRESS_NAME) as ADDRESS_NAME,
    initcap(PROJECT_NAME) as PROJECT_NAME,
    initcap(LABEL_TYPE) as LABEL_TYPE
    from near.core.dim_address_labels
    where LABEL_TYPE not in ('cex','token') and PROJECT_NAME is not null
    ),

    projects_events as (
    select BLOCK_TIMESTAMP, SIGNER_ID, METHOD_NAME, RECEIVER_ID, ADDRESS_NAME, PROJECT_NAME, LABEL_TYPE, TX_HASH, DEPOSIT/1e24 as Volume
    from near.core.fact_actions_events_function_call
    join near_projects
    on RECEIVER_ID=ADDRESS
    where RECEIPT_SUCCEEDED=true
    )


    select PROJECT_NAME as "Project",
    count(*) as "Contract Calls",
    count(distinct tx_hash) as "Transaction",
    count(distinct SIGNER_ID) as "Users",
    sum(volume) as "Volume ($NEAR)",
    avg(volume) as "Average Volume ($NEAR)"
    from projects_events
    where BLOCK_TIMESTAMP>='{{starting_date}}'
    group by 1
    order by "Users" desc
    limit 10



    QueryRunArchived: QueryRun has been archived