FULL_DATE | MONTH | DAY | COMMITS_COUNT | |
|---|---|---|---|---|
1 | 2024-02-11 00:00:00.000 | 2 | 11 | 35 |
2 | 2024-02-10 00:00:00.000 | 2 | 10 | 57 |
3 | 2024-02-09 00:00:00.000 | 2 | 9 | 95 |
4 | 2024-02-08 00:00:00.000 | 2 | 8 | 169 |
5 | 2024-02-07 00:00:00.000 | 2 | 7 | 188 |
6 | 2024-02-06 00:00:00.000 | 2 | 6 | 238 |
7 | 2024-02-05 00:00:00.000 | 2 | 5 | 160 |
8 | 2024-02-04 00:00:00.000 | 2 | 4 | 90 |
9 | 2024-02-03 00:00:00.000 | 2 | 3 | 76 |
10 | 2024-02-02 00:00:00.000 | 2 | 2 | 176 |
11 | 2024-02-01 00:00:00.000 | 2 | 1 | 121 |
12 | 2024-01-31 00:00:00.000 | 1 | 31 | 125 |
13 | 2024-01-30 00:00:00.000 | 1 | 30 | 43 |
14 | 2024-01-29 00:00:00.000 | 1 | 29 | 75 |
15 | 2024-01-28 00:00:00.000 | 1 | 28 | 41 |
16 | 2024-01-27 00:00:00.000 | 1 | 27 | 41 |
17 | 2024-01-26 00:00:00.000 | 1 | 26 | 89 |
18 | 2024-01-25 00:00:00.000 | 1 | 25 | 146 |
19 | 2024-01-24 00:00:00.000 | 1 | 24 | 87 |
20 | 2024-01-23 00:00:00.000 | 1 | 23 | 115 |
messariAtlas - DailyCommits
Updated 2024-01-04
9
1
2
3
4
5
6
›
⌄
SELECT BLOCK_TIMESTAMP::DATE AS full_date, EXTRACT(MONTH FROM BLOCK_TIMESTAMP) AS month, EXTRACT(DAY FROM BLOCK_TIMESTAMP) AS day, COUNT(*) AS commits_count
FROM near.social.fact_widget_deployments
GROUP BY full_date, month, day
ORDER BY full_date DESC, month DESC, day DESC;
Last run: about 1 year ago
...
489
17KB
4s