flipside

    Calculate the median transaction fee in Bitcoin for March 2024:
    gigiokobaCalculate the median transaction fee in Bitcoin for March 2024:
    Updated 2024-04-04
    SELECT PERCENTILE_CONT(0.5) WITHIN GROUP (ORDER BY FEE) AS median_transaction_fee
    FROM bitcoin.core.fact_transactions
    WHERE EXTRACT(MONTH FROM BLOCK_TIMESTAMP) = 3
    AND EXTRACT(YEAR FROM BLOCK_TIMESTAMP) = 2024;

    QueryRunArchived: QueryRun has been archived