flipside

    Identify any noticeable patterns in transaction fees based on the time of day or day of the week in March 2024
    gigiokobaIdentify any noticeable patterns in transaction fees based on the time of day or day of the week in March 2024
    Updated 2024-04-04
    SELECT EXTRACT(HOUR FROM BLOCK_TIMESTAMP) AS hour_of_day,
    AVG(FEE) AS average_fee
    FROM bitcoin.core.fact_transactions
    WHERE EXTRACT(MONTH FROM BLOCK_TIMESTAMP) = 3
    AND EXTRACT(YEAR FROM BLOCK_TIMESTAMP) = 2024
    GROUP BY hour_of_day
    ORDER BY hour_of_day;

    QueryRunArchived: QueryRun has been archived