Updated 2025-04-10
    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
    Total Fees (BTC)
    Average Fees (BTC)
    ($)Total Fees
    ($) Average Fees
    1
    0.70918468040.000011032227558079.3885882980.9034953034
    1
    61B
    2s