DATE | Total blocks | cumulative blocks | |
|---|---|---|---|
1 | 2025-01-23 00:00:00.000 | 39112 | 9694644 |
2 | 2025-02-04 00:00:00.000 | 37368 | 10152342 |
3 | 2024-06-08 00:00:00.000 | 30268 | 54327 |
4 | 2024-07-07 00:00:00.000 | 38356 | 1135516 |
5 | 2024-07-21 00:00:00.000 | 46072 | 1761128 |
6 | 2024-10-11 00:00:00.000 | 41470 | 5461716 |
7 | 2024-08-31 00:00:00.000 | 41751 | 3719182 |
8 | 2024-09-19 00:00:00.000 | 45021 | 4522259 |
9 | 2024-10-27 00:00:00.000 | 39494 | 6135732 |
10 | 2024-10-26 00:00:00.000 | 41074 | 6096238 |
11 | 2024-12-12 00:00:00.000 | 41078 | 8028832 |
12 | 2024-12-25 00:00:00.000 | 39656 | 8540695 |
13 | 2024-12-20 00:00:00.000 | 38290 | 8340205 |
14 | 2025-01-21 00:00:00.000 | 40858 | 9614065 |
15 | 2024-12-21 00:00:00.000 | 38920 | 8379125 |
16 | 2024-06-13 00:00:00.000 | 33379 | 217059 |
17 | 2024-10-21 00:00:00.000 | 43529 | 5893757 |
18 | 2024-06-28 00:00:00.000 | 37689 | 788517 |
19 | 2024-07-06 00:00:00.000 | 38348 | 1097160 |
20 | 2024-07-11 00:00:00.000 | 44917 | 1309795 |
Mrfti2024-07-25 01:01 AM
Updated 2025-03-04
9
1
2
3
4
5
6
›
⌄
SELECT
date_trunc (day, block_timestamp) as date,
count (DISTINCT block_number) as "Total blocks",
sum ("Total blocks") over (order by date) as "cumulative blocks"
from berachain.testnet.fact_blocks
GROUP by 1
Last run: about 2 months agoAuto-refreshes every 12 hours
...
246
10KB
1s