DAY | Daily Average Block Utilization (%) | |
|---|---|---|
1 | 2024-11-27 00:00:00.000 | 0.0762393627 |
2 | 2024-11-28 00:00:00.000 | 0.0794080625 |
3 | 2024-11-29 00:00:00.000 | 0.0758533403 |
4 | 2024-11-30 00:00:00.000 | 0.0762345394 |
5 | 2024-12-01 00:00:00.000 | 0.0762729167 |
6 | 2024-12-02 00:00:00.000 | 0.0822555671 |
7 | 2024-12-03 00:00:00.000 | 0.0878299282 |
8 | 2024-12-04 00:00:00.000 | 0.0827010903 |
9 | 2024-12-05 00:00:00.000 | 0.0806627292 |
10 | 2024-12-06 00:00:00.000 | 0.0813585486 |
11 | 2024-12-07 00:00:00.000 | 0.0788123495 |
12 | 2024-12-08 00:00:00.000 | 0.0819435509 |
13 | 2024-12-09 00:00:00.000 | 0.0857210139 |
14 | 2024-12-10 00:00:00.000 | 0.0851575116 |
15 | 2024-12-11 00:00:00.000 | 0.0837540231 |
16 | 2024-12-12 00:00:00.000 | 0.0803979444 |
17 | 2024-12-13 00:00:00.000 | 0.080874912 |
18 | 2024-12-14 00:00:00.000 | 0.0793641435 |
19 | 2024-12-15 00:00:00.000 | 0.0790732153 |
20 | 2024-12-16 00:00:00.000 | 0.0827602199 |
Mrftieager-gray copy
Updated 2025-02-07
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
-- forked from eager-gray @ https://flipsidecrypto.xyz/studio/queries/8658df2c-0149-48f2-9194-1d048e1ffba2
WITH daily_block_data AS
(
SELECT
DATE_TRUNC('day', block_timestamp) AS day,
AVG(GAS_USED / NULLIF(GAS_LIMIT, 0)) * 100 AS daily_avg_block_utilization
FROM swell.core.fact_blocks
GROUP BY 1
)
SELECT
day,
daily_avg_block_utilization AS "Daily Average Block Utilization (%)"
FROM daily_block_data
ORDER BY 1
Last run: about 1 month ago
73
3KB
2s