DAY | TOTAL_GAS_FEES | |
|---|---|---|
1 | 2025-03-28 00:00:00.000 | |
2 | 2025-03-29 00:00:00.000 | 26297281.880623 |
3 | 2025-03-30 00:00:00.000 | 952214.864689867 |
4 | 2025-03-31 00:00:00.000 | 5327.078764739 |
5 | 2025-04-01 00:00:00.000 | 860312.006637156 |
6 | 2025-04-02 00:00:00.000 | 557259203.138415 |
7 | 2025-04-03 00:00:00.000 | 6036926.25978558 |
8 | 2025-04-04 00:00:00.000 | 4756666.07036831 |
9 | 2025-04-05 00:00:00.000 | 1798727.38798801 |
10 | 2025-04-06 00:00:00.000 | 1648356.13848883 |
kentoTotal Gas Fees Spent per Day
Updated 2025-04-06
9
1
2
3
4
5
6
7
8
›
⌄
SELECT
DATE(block_timestamp) AS day,
SUM(gas_used * gas_price) AS total_gas_fees
FROM mezo.testnet.fact_transactions
WHERE block_timestamp BETWEEN '2025-01-01' AND '2025-12-31'
GROUP BY day
ORDER BY day;
Last run: 29 days ago
10
436B
1s