Total Fees (BTC) | Average Fees (BTC) | ($)Total Fees | ($) Average Fees | |
---|---|---|---|---|
1 | 0.7091846804 | 0.0000110322275 | 58079.388588298 | 0.9034953034 |
alfredfx10Fees
Updated 2025-04-10
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
WITH Price AS (
SELECT PRICE
FROM crosschain.price.ez_prices_hourly
WHERE BLOCKCHAIN = 'bitcoin' AND IS_NATIVE = 'TRUE'
ORDER BY hour DESC
LIMIT 1
)
SELECT
SUM(TX_FEE) AS "Total Fees (BTC)",
SUM(TX_FEE) / COUNT(DISTINCT tx_hash) AS "Average Fees (BTC)",
SUM(TX_FEE * P.PRICE) AS "($)Total Fees",
SUM(TX_FEE * P.PRICE) / COUNT(DISTINCT tx_hash) AS "($) Average Fees"
FROM mezo.testnet.fact_transactions
LEFT JOIN Price P ON TRUE;
Last run: about 2 months ago
1
61B
2s