Flipside Teamdist Active NEAR Projects Over Time
Updated 2024-10-16
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
31
32
33
34
35
›
⌄
-- 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