kaibladeWeekly Number of Active Developers
Updated 2023-01-21
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
›
⌄
WITH deploy_actions As
(SELECT *
FROM near.core.fact_actions_events
WHERE action_name ILIKE '%deploy%'
),
deploy_tx AS
(SELECT *
FROM near.core.fact_transactions
WHERE tx_hash IN (SELECT tx_hash FROM deploy_actions)
),
weekly_dev AS
(SELECT DATE_TRUNC('week', block_timestamp) AS "Weeks",
COUNT (DISTINCT tx_signer) AS "Number of Developers"
FROM deploy_tx
GROUP BY "Weeks")
SELECT *,
(CASE
WHEN "Weeks" ILIKE '%2023%' THEN 'Year 2023'
WHEN "Weeks" ILIKE '%2022%' THEN 'Year 2022'
WHEN "Weeks" ILIKE '%2021%' THEN 'Year 2021'
WHEN "Weeks" ILIKE '%2020%' THEN 'Year 2020'
END) AS "Years"
FROM weekly_dev
-- WHERE tx_hash = '5TzgKyiaBhKUVii7vER3FQ4iKGg9my7RHfjwUzPLQMQS'
Run a query to Download Data