DAY | Average Gas Price | |
|---|---|---|
1 | 2024-06-06 00:00:00.000 | 0.05111511625 |
2 | 2024-11-01 00:00:00.000 | 0.009329311076 |
3 | 2024-09-03 00:00:00.000 | 0.01222355154 |
4 | 2024-04-06 00:00:00.000 | 0.07846935976 |
5 | 2024-05-21 00:00:00.000 | 0.1397732372 |
6 | 2024-08-07 00:00:00.000 | 0.01984932503 |
7 | 2024-11-22 00:00:00.000 | 0.009730232596 |
8 | 2024-06-20 00:00:00.000 | 0.2792675506 |
9 | 2024-08-15 00:00:00.000 | 0.006895031378 |
10 | 2024-11-23 00:00:00.000 | 0.01069169467 |
11 | 2024-07-30 00:00:00.000 | 0.0129760165 |
12 | 2024-09-30 00:00:00.000 | 0.007597504895 |
13 | 2024-10-18 00:00:00.000 | 0.008270477398 |
14 | 2025-01-10 00:00:00.000 | 0.007726884944 |
15 | 2024-05-29 00:00:00.000 | 0.07049725963 |
16 | 2024-08-22 00:00:00.000 | 0.02287191336 |
17 | 2024-07-04 00:00:00.000 | 0.05840753198 |
18 | 2024-04-20 00:00:00.000 | 0.07125039931 |
19 | 2025-02-16 00:00:00.000 | 0.01023732609 |
20 | 2024-03-10 00:00:00.000 | 0.1350274384 |
yolo_gamesAverage Gas Price Blast
Updated 2024-08-06
9
1
2
3
4
5
6
7
8
›
⌄
SELECT DATE_TRUNC('day', BLOCK_TIMESTAMP) as Day, AVG(GAS_PRICE) as "Average Gas Price"
FROM blast.core.fact_transactions
WHERE STATUS = 'SUCCESS'
GROUP BY 1
Last run: 2 months ago
...
360
15KB
11s