CryptoIcicleNEAR - 9. Developer Activity - Closed Pull Requests
Updated 2023-01-23
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
36
›
⌄
-- Payout is in NEAR and xMETRIC, where the top eligible scorers are paid the amounts below.
-- The first, second and third place submissions must have a score of 10 or higher to be eligible for higher payout amounts.
-- If there are not enough eligible submissions for a category, remaining funds will either be paid to lower tier submissions or reserved for future bounty programs.
-- Final determination of payouts and rankings are at the discretion of the MetricsDAO Bounty Operations Team.
-- Rank NEAR amount
-- First place 800 USD worth of NEAR tokens
-- Second place 300 USD worth of NEAR tokens
-- Third place 300 USD worth of NEAR tokens
-- 4th through 15th place 150 USD worth of NEAR tokens
-- 16th through 21st place 100 USD worth of NEAR tokens
-- With Electric Capital’s release of its annual report on developer activity, the topic of “developers” is a hot topic across crypto.
-- Produce a rich analysis of NEAR developer activity, using metrics and definitions of your choice to answer the questions:
-- How many developers are active on NEAR?
-- How active are they?
-- How this has changed over time?
-- Feel free to reference (and cite) the Electric Capital report to provide background, but the vast majority of your dashboard
-- should be original work that provides a supplemental view to that report.
-- select
-- *
-- from near.beta.github_activity
-- order by createdat
-- limit 100
select
date_trunc('{{date_range}}',closedat) as date,
count(distinct id) as n_prs,
count(distinct repo) as n_repos,
count(distinct author) as n_devs,
sum(n_prs) over (order by date asc rows between unbounded preceding and current row) as cum_n_prs
from near.beta.github_activity
where closedat is not null
group by 1
Run a query to Download Data