YEAR | MONTH | YEAR_MONTH | COMMITS_COUNT | |
|---|---|---|---|---|
1 | 2024 | 2 | 2024-02 | 1507 |
2 | 2024 | 1 | 2024-01 | 2471 |
3 | 2023 | 12 | 2023-12 | 2563 |
4 | 2023 | 11 | 2023-11 | 4536 |
5 | 2023 | 10 | 2023-10 | 5211 |
6 | 2023 | 9 | 2023-09 | 5554 |
7 | 2023 | 8 | 2023-08 | 6940 |
8 | 2023 | 7 | 2023-07 | 5971 |
9 | 2023 | 6 | 2023-06 | 5257 |
10 | 2023 | 5 | 2023-05 | 4042 |
11 | 2023 | 4 | 2023-04 | 8004 |
12 | 2023 | 3 | 2023-03 | 4448 |
13 | 2023 | 2 | 2023-02 | 6479 |
14 | 2023 | 1 | 2023-01 | 3986 |
15 | 2022 | 12 | 2022-12 | 2581 |
16 | 2022 | 11 | 2022-11 | 885 |
17 | 2022 | 10 | 2022-10 | 355 |
messariAtlas - MonthlyCommits
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(*) AS commits_count
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
413B
3s