TOTAL_GAS_FEE_MEZO | TOTAL_GAS_FEE_USD | |
|---|---|---|
1 | 834900495.382121 | 83490.049538212 |
kentovictorious-moccasin
Updated 2025-04-06
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
WITH gas_fees_in_mezo AS (
SELECT
SUM(gas_used * gas_price) AS total_gas_fee_mezo
FROM mezo.testnet.fact_transactions
WHERE block_timestamp BETWEEN '2025-01-01' AND '2025-12-31'
)
SELECT
total_gas_fee_mezo,
total_gas_fee_mezo * 0.0001 AS total_gas_fee_usd -- Replace 0.0001 with the actual exchange rate
FROM gas_fees_in_mezo;
Last run: 7 days ago
1
36B
1s