DATE | Total blocks | cumulative blocks | |
|---|---|---|---|
1 | 2024-12-12 00:00:00.000 | 43200 | 675648 |
2 | 2024-12-21 00:00:00.000 | 43200 | 1064448 |
3 | 2024-12-20 00:00:00.000 | 43200 | 1021248 |
4 | 2025-01-21 00:00:00.000 | 43200 | 2403648 |
5 | 2025-02-08 00:00:00.000 | 43200 | 3181248 |
6 | 2025-01-23 00:00:00.000 | 43200 | 2490048 |
7 | 2025-02-04 00:00:00.000 | 43200 | 3008448 |
8 | 2024-12-25 00:00:00.000 | 43200 | 1237248 |
9 | 2025-02-12 00:00:00.000 | 43200 | 3354048 |
10 | 2024-12-13 00:00:00.000 | 43200 | 718848 |
11 | 2025-03-01 00:00:00.000 | 43200 | 4088448 |
12 | 2025-03-04 00:00:00.000 | 43200 | 4218048 |
13 | 2024-12-24 00:00:00.000 | 43200 | 1194048 |
14 | 2024-11-28 00:00:00.000 | 43200 | 70848 |
15 | 2024-12-30 00:00:00.000 | 43200 | 1453248 |
16 | 2025-02-06 00:00:00.000 | 43200 | 3094848 |
17 | 2025-02-10 00:00:00.000 | 43200 | 3267648 |
18 | 2025-03-15 00:00:00.000 | 43200 | 4693248 |
19 | 2025-01-05 00:00:00.000 | 43200 | 1712448 |
20 | 2024-12-10 00:00:00.000 | 43200 | 589248 |
Mrfti2024-07-25 01:01 AM copy
Updated 14 hours ago
99
1
2
3
4
5
6
7
8
9
10
›
⌄
-- forked from 2024-07-25 01:01 AM @ https://flipsidecrypto.xyz/studio/queries/3737f134-fde6-4bb6-bb69-1f41db98a659
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 swell.core.fact_blocks
GROUP by 1
Last run: about 14 hours agoAuto-refreshes every 12 hours
...
110
4KB
2s