YEAR | MONTH | YEAR_MONTH | DEVS | |
|---|---|---|---|---|
1 | 2024 | 2 | 2024-02 | 90 |
2 | 2024 | 1 | 2024-01 | 159 |
3 | 2023 | 12 | 2023-12 | 243 |
4 | 2023 | 11 | 2023-11 | 222 |
5 | 2023 | 10 | 2023-10 | 206 |
6 | 2023 | 9 | 2023-09 | 202 |
7 | 2023 | 8 | 2023-08 | 207 |
8 | 2023 | 7 | 2023-07 | 218 |
9 | 2023 | 6 | 2023-06 | 206 |
10 | 2023 | 5 | 2023-05 | 141 |
11 | 2023 | 4 | 2023-04 | 180 |
12 | 2023 | 3 | 2023-03 | 172 |
13 | 2023 | 2 | 2023-02 | 93 |
14 | 2023 | 1 | 2023-01 | 65 |
15 | 2022 | 12 | 2022-12 | 74 |
16 | 2022 | 11 | 2022-11 | 45 |
17 | 2022 | 10 | 2022-10 | 59 |
messariAtlas - MonthlyDevs
Updated 2024-01-04
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
SELECT
EXTRACT(YEAR FROM BLOCK_TIMESTAMP) AS year,
EXTRACT(MONTH FROM BLOCK_TIMESTAMP) AS month,
TO_CHAR(BLOCK_TIMESTAMP, 'YYYY-MM') AS year_month,
COUNT(DISTINCT SIGNER_ID) AS devs
FROM
near.social.fact_widget_deployments
GROUP BY
EXTRACT(YEAR FROM BLOCK_TIMESTAMP),
EXTRACT(MONTH FROM BLOCK_TIMESTAMP),
TO_CHAR(BLOCK_TIMESTAMP, 'YYYY-MM')
ORDER BY
year DESC,
month DESC;
Last run: about 1 year ago
17
392B
3s