DATE | AVG_TX_FEE | |
|---|---|---|
1 | 2024-10-01 00:00:00.000 | 0.001469171511 |
2 | 2024-10-02 00:00:00.000 | 0.001471698737 |
3 | 2024-10-03 00:00:00.000 | 0.001406135805 |
4 | 2024-10-04 00:00:00.000 | 0.001369099022 |
5 | 2024-10-05 00:00:00.000 | 0.001374120536 |
6 | 2024-10-06 00:00:00.000 | 0.00138367934 |
7 | 2024-10-07 00:00:00.000 | 0.001383151055 |
8 | 2024-10-08 00:00:00.000 | 0.00138980105 |
9 | 2024-10-09 00:00:00.000 | 0.001401991038 |
10 | 2024-10-10 00:00:00.000 | 0.001575157104 |
11 | 2024-10-11 00:00:00.000 | 0.001674728314 |
12 | 2024-10-12 00:00:00.000 | 0.00160111279 |
13 | 2024-10-13 00:00:00.000 | 0.001575559767 |
14 | 2024-10-14 00:00:00.000 | 0.001541017644 |
15 | 2024-10-15 00:00:00.000 | 0.00170425921 |
16 | 2024-10-16 00:00:00.000 | 0.001592747221 |
17 | 2024-10-17 00:00:00.000 | 0.001551542545 |
18 | 2024-10-18 00:00:00.000 | 0.001599188183 |
19 | 2024-10-19 00:00:00.000 | 0.002075774755 |
20 | 2024-10-20 00:00:00.000 | 0.00177538482 |
permaryGas Usage Analysis
Updated 2025-03-18
9
1
2
3
4
5
6
7
8
›
⌄
SELECT
DATE_TRUNC('day', block_timestamp) as date,
AVG(tx_fee) as avg_tx_fee
FROM ronin.core.fact_transactions
WHERE tx_succeeded = true
GROUP BY 1
ORDER BY 1;
Last run: 26 days ago
...
169
7KB
2s